Project Issues tab counter takes up 600ms of every project page load
Query:
SELECT COUNT(*) FROM "issues" WHERE "issues"."deleted_at" IS NULL AND ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 87854 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 87854 AND issue_id = issues.id) OR issues.project_id IN(SELECT "projects"."id" FROM "projects" INNER JOIN "project_authorizations" ON "projects"."id" = "project_authorizations"."project_id" WHERE "projects"."pending_delete" = 'f' AND "project_authorizations"."user_id" = 87854 AND (project_authorizations.access_level >= 20) ORDER BY "projects"."id" DESC)))) AND "issues"."project_id" = 13083 AND ("issues"."state" IN ('opened','reopened'));
Time: 598.726ms
See for yourself by browsing to any page in the project, hitting p b
and clicking the time next to pg
in the performance bar that appears.
/cc @smcgivern