Projects::JobsController#index slow due to CI Query
This seems to be primarily due to
14698.364ms SELECT COUNT(*) FROM "ci_builds" WHERE "ci_builds"."type" IN ('Ci::Build') AND "ci_builds"."project_id" = 13083 AND "ci_builds"."status" IN ('pending', 'running', 'success', 'failed', 'canceled', 'skipped', 'manual')
However I note that there are a number of other moderately slow queries that look related:
155.067ms SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "ci_builds" WHERE "ci_builds"."type" IN ('Ci::Build') AND "ci_builds"."project_id" = 13083 AND "ci_builds"."status" IN ('pending', 'running', 'success', 'failed', 'canceled', 'skipped', 'manual') AND "ci_builds"."status" IN ('running', 'pending') LIMIT 1) subquery_for_count
127.289ms SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "ci_builds" WHERE "ci_builds"."type" IN ('Ci::Build') AND "ci_builds"."project_id" = 13083 AND "ci_builds"."status" IN ('pending', 'running', 'success', 'failed', 'canceled', 'skipped', 'manual') AND "ci_builds"."status" = 'pending' LIMIT 1001) subquery_for_count
79.019ms SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "ci_builds" WHERE "ci_builds"."type" IN ('Ci::Build') AND "ci_builds"."project_id" = 13083 AND "ci_builds"."status" IN ('pending', 'running', 'success', 'failed', 'canceled', 'skipped', 'manual') AND "ci_builds"."status" = 'running' LIMIT 1001) subquery_for_count