Add more granular logging to the Observer
The following discussion from !79692 (merged) should be addressed:
-
@10io started a discussion: I'm wondering if we shouldn't scope the relation to the conditions used by the Enqueuer job.
Basically, I'm wondering if we want to have the progress within the workable scope.
Right now, the line above takes into account all container images. Wouldn't be more informative to have only the images that are eligible to be picked up by the Enqueuer job?
In other words, the Observer metrics should be bring an answer to:
What is the % progression of the current migrations (that targets Free plan and non VIP users)?
WDYT?
These count queries are not performant, so we will need to investigate solutions to optimize the queries or find alternative ways to log this data:
- https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/8476/commands/30041 - Full filter query (query that would run while importing free tier)
- https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/8476/commands/30108 - gitlab-org query (query that would run while importing gitlab-org)
- https://console.postgres.ai/gitlab/gitlab-production-tunnel-pg12/sessions/8476/commands/30136 - query that would run on FOSS