Skip to content

Solve a N+1 issue in Groups::AnalyticsController

Gregory Stark requested to merge index-for-groups-analytic-controller-4899 into master

I think this is all that's needed to avoid an N+1 query in Groups::AnalyticsController:

SELECT SUM("push_event_payloads"."commit_count") FROM "push_event_payloads" WHERE "push_event_payloads"."event_id" IN (SELECT "events"."id" FROM "events" WHERE (action = 5 OR (target_type IN ('MergeRequest','Issue') AND action IN (1,3,7)) OR (target_type = 'Note' AND action = 6)) AND (created_at > '2019-01-15') AND "events"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."namespace_id" = $1) AND "events"."action" = $2)  [["namespace_id", 107], ["action", 5]]

Closes https://gitlab.com/gitlab-org/gitlab-ee/issues/9365

Edited by Stan Hu

Merge request reports