Skip to content

Optimize projects_reporting_ci_cd_back_to_github query

Alex Buijs requested to merge 208923-enable-batch-counting-for-some-individual-queries-3 into master

What does this MR do?

Optimizes the projects_reporting_ci_cd_back_to_github counter query for batch counting in usage data

Part of issue #208923 (closed)

Query

SELECT COUNT(“services”.“id”) FROM “services” WHERE “services”.“type” = ‘GithubService’ AND “services”.“default” = false AND “services”.“active” = true AND “services”.“id” BETWEEN 0 AND 9999;

Optimization

No optimization needed since the index from !27093 (merged) could be reused for this query: https://explain.depesz.com/s/PLY9

Edited by Alex Buijs

Merge request reports