-
🔴 @smcgivernAuthor ContributorCurrent state
Timed out:
https://gitlab.com/dashboard/issues?label_name%5B%5D=bug
https://gitlab.com/groups/gitlab-org/-/issues?search=test
Full output:
D, [2018-06-05T16:07:59.923769 #124484] DEBUG -- : (214.9ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:08:02.036523 #124484] DEBUG -- : (2011.7ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "issues"."confidential" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count [["confidential", false]] D, [2018-06-05T16:08:04.534008 #124484] DEBUG -- : (2395.8ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."merge_requests_access_level" IN (NULL,20) OR ("project_features"."merge_requests_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("merge_requests"."title" ILIKE '%test%' OR "merge_requests"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:08:04.910543 #124484] DEBUG -- : (334.9ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "milestones" WHERE "milestones"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20))) AND ("milestones"."title" ILIKE '%test%' OR "milestones"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:08:04.955406 #124484] DEBUG -- : (14.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 20 OFFSET 0) subquery_for_count D, [2018-06-05T16:08:05.019715 #124484] DEBUG -- : Project Load (43.6ms) SELECT "projects".* FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') ORDER BY "projects"."id" DESC LIMIT 21 OFFSET 0 D, [2018-06-05T16:08:07.133215 #124484] DEBUG -- : (6.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%') AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:08:07.430954 #124484] DEBUG -- : (203.6ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "issues"."confidential" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "issues"."project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count [["confidential", false]] D, [2018-06-05T16:08:08.663210 #124484] DEBUG -- : (175.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."merge_requests_access_level" IN (NULL,20) OR ("project_features"."merge_requests_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND (merge_requests.id IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."source_project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')) UNION SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')))) AND ("merge_requests"."title" ILIKE '%test%' OR "merge_requests"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:08:08.711715 #124484] DEBUG -- : (15.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "milestones" WHERE "milestones"."project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')) AND ("milestones"."title" ILIKE '%test%' OR "milestones"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:08:08.742797 #124484] DEBUG -- : (5.9ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%') AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 20 OFFSET 0) subquery_for_count D, [2018-06-05T16:08:08.772564 #124484] DEBUG -- : Project Load (6.3ms) SELECT "projects".* FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%') AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') ORDER BY "projects"."id" DESC LIMIT 21 OFFSET 0 D, [2018-06-05T16:08:21.275675 #124484] DEBUG -- : (689.9ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "issues"."confidential" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "issues"."project_id" = 13083 AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count [["confidential", false]] D, [2018-06-05T16:08:21.515932 #124484] DEBUG -- : (120.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."merge_requests_access_level" IN (NULL,20) OR ("project_features"."merge_requests_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND (merge_requests.id IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."source_project_id" = 13083 UNION SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 13083)) AND ("merge_requests"."title" ILIKE '%test%' OR "merge_requests"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:08:21.564328 #124484] DEBUG -- : (6.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "milestones" WHERE "milestones"."project_id" = 13083 AND ("milestones"."title" ILIKE '%test%' OR "milestones"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:08:24.538602 #124484] DEBUG -- : (2723.5ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "notes" WHERE "notes"."project_id" = 13083 AND "notes"."noteable_type" = 'Issue' AND "notes"."noteable_id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 13083) AND ("notes"."note" ILIKE '%test%') AND "notes"."system" = 'f' LIMIT 1001) subquery_for_count [["project_id", 13083], ["noteable_type", "Issue"], ["system", false]] D, [2018-06-05T16:08:27.313551 #124484] DEBUG -- : Issue Load (29.7ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND (EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 AND issue_id = issues.id)) AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["archived", false], ["archived", false]] D, [2018-06-05T16:08:29.103846 #124484] DEBUG -- : (12.9ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 AND issue_id = issues.id)) AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) GROUP BY "issues"."state" [["archived", false]] D, [2018-06-05T16:08:33.652663 #124484] DEBUG -- : Issue Load (12.2ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "issues"."author_id" = 443319 AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["author_id", 443319], ["archived", false], ["archived", false]] D, [2018-06-05T16:08:34.732098 #124484] DEBUG -- : (9.4ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND "issues"."author_id" = 443319 AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) GROUP BY "issues"."state" [["author_id", 443319], ["archived", false]] D, [2018-06-05T16:08:36.825049 #124484] DEBUG -- : (6.7ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "issues"."author_id" = 443319 AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' [["author_id", 443319], ["archived", false], ["archived", false]] D, [2018-06-05T16:08:53.346029 #124484] DEBUG -- : Issue Load (15537.8ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "label_links" ON "label_links"."target_id" = "issues"."id" AND "label_links"."target_type" = 'Issue' INNER JOIN "labels" ON "labels"."id" = "label_links"."label_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' AND "labels"."title" = 'bug' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["target_type", "Issue"], ["archived", false], ["archived", false]] D, [2018-06-05T16:08:55.430786 #124484] DEBUG -- : Issue Load (25.1ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' AND "milestones"."title" = '10.8' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["archived", false], ["title", "10.8"], ["archived", false]] D, [2018-06-05T16:08:56.632338 #124484] DEBUG -- : (19.5ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND "projects"."archived" = 'f' AND "milestones"."title" = '10.8' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) GROUP BY "issues"."state" [["archived", false], ["title", "10.8"]] D, [2018-06-05T16:08:59.454538 #124484] DEBUG -- : (15.7ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' AND "milestones"."title" = '10.8' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' [["archived", false], ["title", "10.8"], ["archived", false]] D, [2018-06-05T16:09:15.899376 #124484] DEBUG -- : Issue Load (15002.6ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') AND "projects"."archived" = 'f' AND "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 9970 UNION SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS "namespaces") AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["archived", false], ["archived", false]] D, [2018-06-05T16:09:18.465771 #124484] DEBUG -- : Issue Load (14.6ms) SELECT "issues".* FROM "issues" WHERE ("issues"."state" IN ('opened')) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') AND "issues"."project_id" = 13083 ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 D, [2018-06-05T16:09:21.225414 #124484] DEBUG -- : (1510.1ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" WHERE ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') AND "issues"."project_id" = 13083 GROUP BY "issues"."state"
Edited by Sean McGivern -
🔴 @smcgivernAuthor ContributorAfter removing
item_project_ids
class IssuableFinder def by_project(items) items = if project? items.of_projects(projects).references_project elsif projects items.merge(projects.reorder(nil)).join_project else items.none end items end end
Timed out:
https://gitlab.com/dashboard/issues?label_name%5B%5D=bug
https://gitlab.com/groups/gitlab-org/-/issues?search=test
Full output:
D, [2018-06-05T16:13:12.756662 #124484] DEBUG -- : (190.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:13:14.683714 #124484] DEBUG -- : (1827.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "issues"."confidential" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count [["confidential", false]] D, [2018-06-05T16:13:17.133821 #124484] DEBUG -- : (2355.6ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."merge_requests_access_level" IN (NULL,20) OR ("project_features"."merge_requests_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("merge_requests"."title" ILIKE '%test%' OR "merge_requests"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:13:17.430765 #124484] DEBUG -- : (257.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "milestones" WHERE "milestones"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20))) AND ("milestones"."title" ILIKE '%test%' OR "milestones"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:13:17.487730 #124484] DEBUG -- : (16.6ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 20 OFFSET 0) subquery_for_count D, [2018-06-05T16:13:17.705515 #124484] DEBUG -- : Project Load (30.6ms) SELECT "projects".* FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') ORDER BY "projects"."id" DESC LIMIT 21 OFFSET 0 D, [2018-06-05T16:13:19.822676 #124484] DEBUG -- : (7.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%') AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:13:20.124705 #124484] DEBUG -- : (202.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "issues"."confidential" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "issues"."project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count [["confidential", false]] D, [2018-06-05T16:13:20.395258 #124484] DEBUG -- : (178.1ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."merge_requests_access_level" IN (NULL,20) OR ("project_features"."merge_requests_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND (merge_requests.id IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."source_project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')) UNION SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')))) AND ("merge_requests"."title" ILIKE '%test%' OR "merge_requests"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:13:20.444442 #124484] DEBUG -- : (9.8ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "milestones" WHERE "milestones"."project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')) AND ("milestones"."title" ILIKE '%test%' OR "milestones"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:13:20.475662 #124484] DEBUG -- : (5.6ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%') AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 20 OFFSET 0) subquery_for_count D, [2018-06-05T16:13:20.505981 #124484] DEBUG -- : Project Load (6.7ms) SELECT "projects".* FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%') AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') ORDER BY "projects"."id" DESC LIMIT 21 OFFSET 0 D, [2018-06-05T16:13:27.107691 #124484] DEBUG -- : (646.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "issues"."confidential" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "issues"."project_id" = 13083 AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count [["confidential", false]] D, [2018-06-05T16:13:27.341909 #124484] DEBUG -- : (94.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."merge_requests_access_level" IN (NULL,20) OR ("project_features"."merge_requests_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND (merge_requests.id IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."source_project_id" = 13083 UNION SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 13083)) AND ("merge_requests"."title" ILIKE '%test%' OR "merge_requests"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:13:27.394890 #124484] DEBUG -- : (2.8ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "milestones" WHERE "milestones"."project_id" = 13083 AND ("milestones"."title" ILIKE '%test%' OR "milestones"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T16:13:30.509474 #124484] DEBUG -- : (2910.8ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "notes" WHERE "notes"."project_id" = 13083 AND "notes"."noteable_type" = 'Issue' AND "notes"."noteable_id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 13083) AND ("notes"."note" ILIKE '%test%') AND "notes"."system" = 'f' LIMIT 1001) subquery_for_count [["project_id", 13083], ["noteable_type", "Issue"], ["system", false]] D, [2018-06-05T16:13:32.371349 #124484] DEBUG -- : Issue Load (19.6ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND (EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 AND issue_id = issues.id)) AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["archived", false], ["archived", false]] D, [2018-06-05T16:13:33.515576 #124484] DEBUG -- : (13.4ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 AND issue_id = issues.id)) AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) GROUP BY "issues"."state" [["archived", false]] D, [2018-06-05T16:13:36.311353 #124484] DEBUG -- : Issue Load (10.8ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "issues"."author_id" = 443319 AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["author_id", 443319], ["archived", false], ["archived", false]] D, [2018-06-05T16:13:37.400365 #124484] DEBUG -- : (8.4ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND "issues"."author_id" = 443319 AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) GROUP BY "issues"."state" [["author_id", 443319], ["archived", false]] D, [2018-06-05T16:13:39.315992 #124484] DEBUG -- : (13.6ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "issues"."author_id" = 443319 AND "projects"."archived" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' [["author_id", 443319], ["archived", false], ["archived", false]] D, [2018-06-05T16:13:55.598886 #124484] DEBUG -- : Issue Load (15316.9ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "label_links" ON "label_links"."target_id" = "issues"."id" AND "label_links"."target_type" = 'Issue' INNER JOIN "labels" ON "labels"."id" = "label_links"."label_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' AND "labels"."title" = 'bug' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["target_type", "Issue"], ["archived", false], ["archived", false]] D, [2018-06-05T16:13:57.482680 #124484] DEBUG -- : Issue Load (18.7ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' AND "milestones"."title" = '10.8' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["archived", false], ["title", "10.8"], ["archived", false]] D, [2018-06-05T16:13:58.759116 #124484] DEBUG -- : (19.2ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND "projects"."archived" = 'f' AND "milestones"."title" = '10.8' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) GROUP BY "issues"."state" [["archived", false], ["title", "10.8"]] D, [2018-06-05T16:14:01.091810 #124484] DEBUG -- : (14.3ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' AND "milestones"."title" = '10.8' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' [["archived", false], ["title", "10.8"], ["archived", false]] D, [2018-06-05T16:14:17.386694 #124484] DEBUG -- : Issue Load (15004.1ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND ("issues"."state" IN ('opened')) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') AND "projects"."archived" = 'f' AND "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 9970 UNION SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS "namespaces") AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["archived", false], ["archived", false]] D, [2018-06-05T16:14:19.598554 #124484] DEBUG -- : Issue Load (12.4ms) SELECT "issues".* FROM "issues" WHERE ("issues"."state" IN ('opened')) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') AND "issues"."project_id" = 13083 ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 D, [2018-06-05T16:14:22.102367 #124484] DEBUG -- : (1542.8ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" WHERE ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') AND "issues"."project_id" = 13083 GROUP BY "issues"."state"
Edited by Sean McGivern -
🔴 @smcgivernAuthor ContributorAfter adding a CTE when searching in a project
class IssuableFinder def execute items = init_collection items = filter_items(items) # This has to be last as we may use a CTE as an optimization fence # https://www.postgresql.org/docs/current/static/queries-with.html items = by_search(items) sort(items) end def filter_items(items) items = by_project(items) items = by_scope(items) items = by_created_at(items) items = by_updated_at(items) items = by_state(items) items = by_group(items) items = by_assignee(items) items = by_author(items) items = by_non_archived(items) items = by_iids(items) items = by_milestone(items) items = by_label(items) by_my_reaction_emoji(items) end def by_search(items) return items unless search if (project? || group) && Gitlab::Database.postgresql? cte = Gitlab::SQL::RecursiveCTE.new(klass.table_name) cte << items items = klass.with(cte.to_arel).from(klass.table_name) end items.full_search(search) end end
Timed out:
https://gitlab.com/dashboard/issues?label_name%5B%5D=bug
Full output:
D, [2018-06-05T17:19:48.381631 #124484] DEBUG -- : (216.1ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T17:19:50.357474 #124484] DEBUG -- : (1883.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "issues"."confidential" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count [["confidential", false]] D, [2018-06-05T17:19:52.880588 #124484] DEBUG -- : (2412.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."merge_requests_access_level" IN (NULL,20) OR ("project_features"."merge_requests_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("merge_requests"."title" ILIKE '%test%' OR "merge_requests"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T17:19:53.197488 #124484] DEBUG -- : (274.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "milestones" WHERE "milestones"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20))) AND ("milestones"."title" ILIKE '%test%' OR "milestones"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T17:19:53.242630 #124484] DEBUG -- : (13.9ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 20 OFFSET 0) subquery_for_count D, [2018-06-05T17:19:53.294261 #124484] DEBUG -- : Project Load (28.9ms) SELECT "projects".* FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') ORDER BY "projects"."id" DESC LIMIT 21 OFFSET 0 D, [2018-06-05T17:20:00.202017 #124484] DEBUG -- : (6.1ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%') AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T17:20:00.561209 #124484] DEBUG -- : (258.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "issues"."confidential" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "issues"."project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')) AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count [["confidential", false]] D, [2018-06-05T17:20:00.864786 #124484] DEBUG -- : (183.7ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."merge_requests_access_level" IN (NULL,20) OR ("project_features"."merge_requests_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND (merge_requests.id IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."source_project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')) UNION SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')))) AND ("merge_requests"."title" ILIKE '%test%' OR "merge_requests"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T17:20:00.924222 #124484] DEBUG -- : (10.1ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "milestones" WHERE "milestones"."project_id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%')) AND ("milestones"."title" ILIKE '%test%' OR "milestones"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T17:20:00.965109 #124484] DEBUG -- : (6.6ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%') AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') LIMIT 20 OFFSET 0) subquery_for_count D, [2018-06-05T17:20:00.998164 #124484] DEBUG -- : Project Load (7.8ms) SELECT "projects".* FROM "projects" INNER JOIN routes rs ON rs.source_id = projects.id AND rs.source_type = 'Project' WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND (rs.path LIKE 'gitlab-org/%') AND (("projects"."path" ILIKE '%test%' OR "projects"."name" ILIKE '%test%') OR "projects"."description" ILIKE '%test%') ORDER BY "projects"."id" DESC LIMIT 21 OFFSET 0 D, [2018-06-05T17:20:08.053678 #124484] DEBUG -- : (622.7ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "issues"."confidential" = 'f' AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "issues"."project_id" = 13083 AND ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count [["confidential", false]] D, [2018-06-05T17:20:08.280487 #124484] DEBUG -- : (113.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "merge_requests" INNER JOIN "projects" ON "projects"."id" = "merge_requests"."target_project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."merge_requests_access_level" IN (NULL,20) OR ("project_features"."merge_requests_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND (merge_requests.id IN (SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."source_project_id" = 13083 UNION SELECT "merge_requests"."id" FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 13083)) AND ("merge_requests"."title" ILIKE '%test%' OR "merge_requests"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T17:20:08.324657 #124484] DEBUG -- : (2.4ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "milestones" WHERE "milestones"."project_id" = 13083 AND ("milestones"."title" ILIKE '%test%' OR "milestones"."description" ILIKE '%test%') LIMIT 1001) subquery_for_count D, [2018-06-05T17:20:10.172187 #124484] DEBUG -- : (1674.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "notes" WHERE "notes"."project_id" = 13083 AND "notes"."noteable_type" = 'Issue' AND "notes"."noteable_id" IN (SELECT "issues"."id" FROM "issues" WHERE "issues"."project_id" = 13083) AND ("notes"."note" ILIKE '%test%') AND "notes"."system" = 'f' LIMIT 1001) subquery_for_count [["project_id", 13083], ["noteable_type", "Issue"], ["system", false]] D, [2018-06-05T17:20:12.152309 #124484] DEBUG -- : Issue Load (17.7ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND (EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 AND issue_id = issues.id)) AND "projects"."archived" = 'f' AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["archived", false], ["archived", false]] D, [2018-06-05T17:20:13.395608 #124484] DEBUG -- : (11.3ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND (EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 AND issue_id = issues.id)) AND "projects"."archived" = 'f' GROUP BY "issues"."state" [["archived", false]] D, [2018-06-05T17:20:16.187072 #124484] DEBUG -- : Issue Load (9.9ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND "issues"."author_id" = 443319 AND "projects"."archived" = 'f' AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["author_id", 443319], ["archived", false], ["archived", false]] D, [2018-06-05T17:20:17.367384 #124484] DEBUG -- : (8.2ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "issues"."author_id" = 443319 AND "projects"."archived" = 'f' GROUP BY "issues"."state" [["author_id", 443319], ["archived", false]] D, [2018-06-05T17:20:19.465331 #124484] DEBUG -- : (8.1ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND "issues"."author_id" = 443319 AND "projects"."archived" = 'f' AND "projects"."archived" = 'f' [["author_id", 443319], ["archived", false], ["archived", false]] D, [2018-06-05T17:20:35.540794 #124484] DEBUG -- : Issue Load (15172.7ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "label_links" ON "label_links"."target_id" = "issues"."id" AND "label_links"."target_type" = 'Issue' INNER JOIN "labels" ON "labels"."id" = "label_links"."label_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' AND "labels"."title" = 'bug' AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["target_type", "Issue"], ["archived", false], ["archived", false]] D, [2018-06-05T17:20:37.500366 #124484] DEBUG -- : Issue Load (18.0ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' AND "milestones"."title" = '10.8' AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["archived", false], ["title", "10.8"], ["archived", false]] D, [2018-06-05T17:20:38.771183 #124484] DEBUG -- : (19.9ms) SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' AND "milestones"."title" = '10.8' GROUP BY "issues"."state" [["archived", false], ["title", "10.8"]] D, [2018-06-05T17:20:41.259825 #124484] DEBUG -- : (13.7ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id LEFT OUTER JOIN milestones ON issues.milestone_id = milestones.id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' AND "milestones"."title" = '10.8' AND "projects"."archived" = 'f' [["archived", false], ["title", "10.8"], ["archived", false]] D, [2018-06-05T17:20:43.260856 #124484] DEBUG -- : Issue Load (648.6ms) WITH "issues" AS (SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 9970 UNION SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS "namespaces") AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f') SELECT "issues".* FROM issues INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" WHERE ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') AND "projects"."archived" = 'f' ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 [["archived", false]] D, [2018-06-05T17:20:44.704434 #124484] DEBUG -- : (134.4ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 9970 UNION SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS "namespaces") AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f' [["archived", false]] D, [2018-06-05T17:20:47.429619 #124484] DEBUG -- : (2348.6ms) WITH "issues" AS (SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 9970 UNION SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS "namespaces") AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND "projects"."archived" = 'f') SELECT COUNT(*) AS count_all, "state" AS state FROM issues WHERE ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') GROUP BY "state" D, [2018-06-05T17:20:49.962661 #124484] DEBUG -- : (620.1ms) WITH "issues" AS (SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 9970 UNION SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS "namespaces") AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f') SELECT COUNT(*) FROM issues INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" WHERE ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') AND "projects"."archived" = 'f' [["archived", false]] D, [2018-06-05T17:20:51.567237 #124484] DEBUG -- : (54.5ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE ( issues.confidential IS NOT TRUE OR (issues.confidential = TRUE AND (issues.author_id = 443319 OR EXISTS (SELECT TRUE FROM issue_assignees WHERE user_id = 443319 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 "project_authorizations"."user_id" = 443319 AND (project_authorizations.access_level >= 20))))) AND "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 9970 UNION SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS "namespaces") AND ("project_features"."issues_access_level" IN (NULL,20) OR ("project_features"."issues_access_level" = 10 AND EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 443319 AND (project_authorizations.project_id = projects.id)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f' [["archived", false]] D, [2018-06-05T17:20:56.240345 #124484] DEBUG -- : Issue Load (424.5ms) WITH "issues" AS (SELECT "issues".* FROM "issues" WHERE "issues"."project_id" = 13083 AND ("issues"."state" IN ('opened'))) SELECT "issues".* FROM issues WHERE ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') ORDER BY "issues"."created_at" DESC, "issues"."id" DESC LIMIT 20 OFFSET 0 D, [2018-06-05T17:20:58.762533 #124484] DEBUG -- : (1544.0ms) WITH "issues" AS (SELECT "issues".* FROM "issues" WHERE "issues"."project_id" = 13083) SELECT COUNT(*) AS count_all, "state" AS state FROM issues WHERE ("issues"."title" ILIKE '%test%' OR "issues"."description" ILIKE '%test%') GROUP BY "state"
Edited by Sean McGivern
Please register or sign in to comment