Reconcile and clean up all Gitlab::QueryLimiting.disable references with corresponding issues
We need to reconcile and clean up all the issues related to &5670 (closed), and ensure that every code occurrence has a link to a valid, open corresponding issue, and any stale/obsolete issues are closed.
Unresolved questions
- Process: What do we do about people not knowing to apply the querylimiting-disable label to new issues which are created? How we can enforce that?
- Process: This line in the epic is definitely not true currently, and I'm still not sure if it's supposed to be:
- "All of these occurrences should be allowlisted in the code with a Gitlab::QueryLimiting.disable!(ISSUE_LINK) block which links to a valid, open issue with the label querylimiting-disable"
- Should all of the issues have a corresponding allowlist entry in the code? Or not? If not, then the script needs to be updated to reflect what the actual process is supposed to be.
Tasks:
-
Apply the querylimiting-disable label to all issues related to allow-listing "executes more than 100 SQL queries" calls via Gitlab::QueryLimiting.disable
. -
Update all code occurrences of Gitlab::QueryLimiting.disable!(ISSUE_LINK)
to point to a valid, opened issue. (done in !57209 (merged)) -
Create an automated reporting script which can help reconcile the open issues to the code occurrences. (done in !57209 (merged)) -
Consolidate all issue links which are referenced in comments above/outside of a Gitlab::QueryLimiting.disable!(ISSUE_LINK)
to a single issue. See !57209 (comment 537154118) -
Automated report from !57209 (merged) should ideally not report any issues or code lines (maybe?), other than possibly remaining "calls with no issue number" which use variables/etc.
Output of query_limiting_report.rb
Latest output of `scripts/perf/query_limiting_report.rb --api-token XXXX`
Output as of 2021-03-25
Finding issues by label querylimiting-disable...
Finding code lines...
REPORT:
Found 195 total issues with 'querylimiting-disable' search label, 157 are still opened...
Found 42 total occurrences of 'QueryLimiting.disable' in code...
--------------------------------------------------------------------------------
Issues without any 'QueryLimiting.disable' code references (122 total):
[{:iid=>325691,
:state=>"opened",
:title=>
"Projects::MergeRequests::DiffsController#diff_for_path.json executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/325691"},
{:iid=>325690,
:state=>"opened",
:title=>
"PUT /api/projects/:id/merge_requests/:noteable_id/notes/:note_id executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/325690"},
{:iid=>325689,
:state=>"opened",
:title=>
"DELETE /api/projects/:id/merge_requests/:merge_request_iid executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/325689"},
{:iid=>325685,
:state=>"opened",
:title=>
"/api/:version/projects/:id/merge_requests/:merge_request_iid/add_spent_time executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/325685"},
{:iid=>325682,
:state=>"opened",
:title=>
"Controller Projects::MergeRequestsController#destroy executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/325682"},
{:iid=>21146,
:state=>"opened",
:title=>
"API PUT /projects/:id/merge_requests/:merge_request_iid/merge executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21146"},
{:iid=>21144,
:state=>"opened",
:title=>
"API PUT /projects/:id/merge_requests/:merge_request_id/merge executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21144"},
{:iid=>21143,
:state=>"opened",
:title=>
"API PUT /projects/:id/issues/:issue_iid executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21143"},
{:iid=>21142,
:state=>"opened",
:title=>
"API PUT /projects/:id/issues/:issue_id executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21142"},
{:iid=>21140,
:state=>"opened",
:title=>"API POST /projects/:id/issues executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21140"},
{:iid=>21138,
:state=>"opened",
:title=>"API POST /jobs/request executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21138"},
{:iid=>21137,
:state=>"opened",
:title=>"API POST /jobs/:id/artifacts executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21137"},
{:iid=>21136,
:state=>"opened",
:title=>"API POST /internal/allowed executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21136"},
{:iid=>21135,
:state=>"opened",
:title=>"API GET /users/:namespace/repos executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21135"},
{:iid=>21134,
:state=>"opened",
:title=>"API GET /runners/:id executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21134"},
{:iid=>21133,
:state=>"opened",
:title=>"API GET /projects/owned executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21133"},
{:iid=>21132,
:state=>"opened",
:title=>
"API GET /projects/:id/repository/tags executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21132"},
{:iid=>21131,
:state=>"opened",
:title=>
"API GET /projects/:id/repository/commits/:sha/comments executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21131"},
{:iid=>21130,
:state=>"opened",
:title=>
"API GET /projects/:id/repository/commits/:sha/builds executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21130"},
{:iid=>21129,
:state=>"opened",
:title=>
"API GET /projects/:id/milestones/:milestone_id/issues executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21129"},
{:iid=>21126,
:state=>"opened",
:title=>"API GET /projects/:id/labels executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21126"},
{:iid=>21125,
:state=>"opened",
:title=>
"API GET /projects/:id/issues/:noteable_id/notes executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21125"},
{:iid=>21124,
:state=>"opened",
:title=>
"API GET /projects/:id/issues/:issue_iid executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21124"},
{:iid=>21123,
:state=>"opened",
:title=>"API GET /projects/:id/issues executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21123"},
{:iid=>21122,
:state=>"opened",
:title=>"API GET /projects/:id/events executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21122"},
{:iid=>21121,
:state=>"opened",
:title=>"API GET /projects executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21121"},
{:iid=>21120,
:state=>"opened",
:title=>"API GET /issues executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21120"},
{:iid=>21119,
:state=>"opened",
:title=>
"API GET /groups/:id/milestones/:milestone_id/issues executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21119"},
{:iid=>21118,
:state=>"opened",
:title=>"API GET /groups/:id/issues executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21118"},
{:iid=>21117,
:state=>"opened",
:title=>"API GET /groups/:id executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21117"},
{:iid=>21116,
:state=>"opened",
:title=>"API GET /groups executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21116"},
{:iid=>21115,
:state=>"opened",
:title=>
"Controller UsersController#groups executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21115"},
{:iid=>21114,
:state=>"opened",
:title=>
"Controller UsersController#calendar_activities executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21114"},
{:iid=>21113,
:state=>"opened",
:title=>
"Controller SearchController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21113"},
{:iid=>21112,
:state=>"opened",
:title=>
"Controller Projects::WikisController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21112"},
{:iid=>21111,
:state=>"opened",
:title=>
"Controller Projects::WikisController#preview_markdown executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21111"},
{:iid=>21110,
:state=>"opened",
:title=>
"Controller Projects::VariablesController#update executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21110"},
{:iid=>21109,
:state=>"opened",
:title=>
"Controller Projects::TreeController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21109"},
{:iid=>21108,
:state=>"opened",
:title=>
"Controller Projects::TagsController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21108"},
{:iid=>21107,
:state=>"opened",
:title=>
"Controller Projects::Settings::CiCdController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21107"},
{:iid=>21106,
:state=>"opened",
:title=>
"Controller Projects::ProjectMembersController#leave executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21106"},
{:iid=>21105,
:state=>"opened",
:title=>
"Controller Projects::ProjectMembersController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21105"},
{:iid=>21104,
:state=>"opened",
:title=>
"Controller Projects::ProjectMembersController#destroy executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21104"},
{:iid=>21103,
:state=>"opened",
:title=>
"Controller Projects::ProjectMembersController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21103"},
{:iid=>21102,
:state=>"opened",
:title=>
"Controller Projects::ProjectMembersController#apply_import executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21102"},
{:iid=>21101,
:state=>"opened",
:title=>
"Controller Projects::PipelinesController#retry executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21101"},
{:iid=>21100,
:state=>"opened",
:title=>
"Controller Projects::PipelinesController#failures executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21100"},
{:iid=>21098,
:state=>"opened",
:title=>
"Controller Projects::PipelinesController#cancel executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21098"},
{:iid=>21097,
:state=>"opened",
:title=>
"Controller Projects::NotesController#update executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21097"},
{:iid=>21096,
:state=>"opened",
:title=>
"Controller Projects::NotesController#resolve executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21096"},
{:iid=>21095,
:state=>"opened",
:title=>
"Controller Projects::NotesController#create.json executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21095"},
{:iid=>21093,
:state=>"opened",
:title=>
"Controller Projects::MilestonesController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21093"},
{:iid=>21092,
:state=>"opened",
:title=>
"Controller Projects::MilestonesController#merge_requests executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21092"},
{:iid=>21091,
:state=>"opened",
:title=>
"Controller Projects::MilestonesController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21091"},
{:iid=>21090,
:state=>"opened",
:title=>
"Controller Projects::MilestonesController#destroy executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21090"},
{:iid=>21088,
:state=>"opened",
:title=>
"Controller Projects::MergeRequests::CreationsController#pipelines executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21088"},
{:iid=>21086,
:state=>"opened",
:title=>
"Controller Projects::MergeRequests::CreationsController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21086"},
{:iid=>21083,
:state=>"opened",
:title=>
"Controller Projects::MergeRequestsController#remove_wip executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21083"},
{:iid=>21082,
:state=>"opened",
:title=>
"Controller Projects::MergeRequestsController#pipelines executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21082"},
{:iid=>21078,
:state=>"opened",
:title=>
"Controller Projects::LabelsController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21078"},
{:iid=>21077,
:state=>"opened",
:title=>
"Controller Projects::LabelsController#destroy executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21077"},
{:iid=>21076,
:state=>"opened",
:title=>
"Controller Projects::JobsController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21076"},
{:iid=>21075,
:state=>"opened",
:title=>
"Controller Projects::JobsController#retry executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21075"},
{:iid=>21074,
:state=>"opened",
:title=>
"Controller Projects::JobsController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21074"},
{:iid=>21073,
:state=>"opened",
:title=>
"Controller Projects::IssuesController#update executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21073"},
{:iid=>21072,
:state=>"opened",
:title=>
"Controller Projects::IssuesController#move executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21072"},
{:iid=>21071,
:state=>"opened",
:title=>
"Controller Projects::IssuesController#create_merge_request executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21071"},
{:iid=>21070,
:state=>"opened",
:title=>
"Controller Projects::IssuesController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21070"},
{:iid=>21069,
:state=>"opened",
:title=>
"Controller Projects::IssuesController#can_create_branch executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21069"},
{:iid=>21068,
:state=>"opened",
:title=>
"Controller Projects::IssuesController#bulk_update executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21068"},
{:iid=>21067,
:state=>"opened",
:title=>
"Controller Projects::IssueLinksController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21067"},
{:iid=>21066,
:state=>"opened",
:title=>
"Controller Projects::ForksController#new executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21066"},
{:iid=>21065,
:state=>"opened",
:title=>
"Controller Projects::ForksController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21065"},
{:iid=>21064,
:state=>"opened",
:title=>
"Controller Projects::ForksController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21064"},
{:iid=>21063,
:state=>"opened",
:title=>
"Controller Projects::EnvironmentsController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21063"},
{:iid=>21062,
:state=>"opened",
:title=>
"Controller Projects::EnvironmentsController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21062"},
{:iid=>21061,
:state=>"opened",
:title=>
"Controller Projects::EnvironmentsController#folder executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21061"},
{:iid=>21060,
:state=>"opened",
:title=>
"Controller Projects::DiscussionsController#resolve executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21060"},
{:iid=>21058,
:state=>"opened",
:title=>
"Controller Projects::CycleAnalytics::EventsController#test executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21058"},
{:iid=>21057,
:state=>"opened",
:title=>
"Controller Projects::CycleAnalytics::EventsController#staging executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21057"},
{:iid=>21056,
:state=>"opened",
:title=>
"Controller ProjectsController#transfer executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21056"},
{:iid=>21055,
:state=>"opened",
:title=>
"Controller ProjectsController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21055"},
{:iid=>21054,
:state=>"opened",
:title=>
"Controller ProjectsController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21054"},
{:iid=>21053,
:state=>"opened",
:title=>
"Controller ProjectsController#activity executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21053"},
{:iid=>21052,
:state=>"opened",
:title=>
"Controller Projects::CompareController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21052"},
{:iid=>21051,
:state=>"opened",
:title=>
"Controller Projects::CommitsController#signatures executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21051"},
{:iid=>21050,
:state=>"opened",
:title=>
"Controller Projects::CommitsController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21050"},
{:iid=>21048,
:state=>"opened",
:title=>
"Controller Projects::CommitController#pipelines executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21048"},
{:iid=>21047,
:state=>"opened",
:title=>
"Controller Projects::BranchesController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21047"},
{:iid=>21046,
:state=>"opened",
:title=>
"Controller Projects::BlobController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21046"},
{:iid=>21044,
:state=>"opened",
:title=>
"Controller Profiles::SlacksController#edit executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21044"},
{:iid=>21043,
:state=>"opened",
:title=>
"Controller Profiles::NotificationsController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21043"},
{:iid=>21042,
:state=>"opened",
:title=>
"Controller ProfilesController#update_username executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21042"},
{:iid=>21041,
:state=>"opened",
:title=>
"Controller Import::GitlabProjectsController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21041"},
{:iid=>21040,
:state=>"opened",
:title=>
"Controller Import::GithubController#status executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21040"},
{:iid=>21039,
:state=>"opened",
:title=>
"Controller Import::GithubController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21039"},
{:iid=>21038,
:state=>"opened",
:title=>
"Controller Import::BitbucketController#status executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21038"},
{:iid=>21037,
:state=>"opened",
:title=>
"Controller Import::BitbucketController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21037"},
{:iid=>21036,
:state=>"opened",
:title=>
"Controller Groups::MilestonesController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21036"},
{:iid=>21035,
:state=>"opened",
:title=>
"Controller Groups::MilestonesController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21035"},
{:iid=>21034,
:state=>"opened",
:title=>
"Controller Groups::LabelsController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21034"},
{:iid=>21033,
:state=>"opened",
:title=>
"Controller Groups::GroupMembersController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21033"},
{:iid=>21032,
:state=>"opened",
:title=>
"Controller Groups::GroupMembersController#create executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21032"},
{:iid=>21031,
:state=>"opened",
:title=>
"Controller Groups::EpicIssuesController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21031"},
{:iid=>21030,
:state=>"opened",
:title=>
"Controller GroupsController#update executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21030"},
{:iid=>21029,
:state=>"opened",
:title=>
"Controller GroupsController#transfer executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21029"},
{:iid=>21028,
:state=>"opened",
:title=>
"Controller GroupsController#activity executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21028"},
{:iid=>21027,
:state=>"opened",
:title=>
"Controller Groups::ChildrenController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21027"},
{:iid=>21026,
:state=>"opened",
:title=>
"Controller Groups::AnalyticsController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21026"},
{:iid=>21024,
:state=>"opened",
:title=>
"Controller Explore::ProjectsController#trending executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21024"},
{:iid=>21023,
:state=>"opened",
:title=>
"Controller Dashboard::ProjectsController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21023"},
{:iid=>21022,
:state=>"opened",
:title=>
"Controller Dashboard::MilestonesController#show executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21022"},
{:iid=>21021,
:state=>"opened",
:title=>
"Controller Dashboard::MilestonesController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21021"},
{:iid=>21020,
:state=>"opened",
:title=>
"Controller Dashboard::GroupsController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21020"},
{:iid=>21019,
:state=>"opened",
:title=>
"Controller DashboardController#activity executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21019"},
{:iid=>21018,
:state=>"opened",
:title=>
"Controller Boards::ListsController#index executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21018"},
{:iid=>21017,
:state=>"opened",
:title=>
"Controller Boards::IssuesController#update executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/21017"},
{:iid=>4795,
:state=>"opened",
:title=>"API endpoint DELETE /groups/:id executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/4795"},
{:iid=>4792,
:state=>"opened",
:title=>
"Controller Projects::MergeRequestsController#merge executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/4792"},
{:iid=>20827,
:state=>"opened",
:title=>
"Controller Projects::MergeRequestsController#update executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/20827"},
{:iid=>20815,
:state=>"opened",
:title=>
"Controller Projects::IssuesController#create_merge_request executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/20815"},
{:iid=>20785,
:state=>"opened",
:title=>
"Controller Projects::PipelinesController#retry executes more than 100 SQL queries",
:issue_url=>"https://gitlab.com/gitlab-org/gitlab/issues/20785"}]
--------------------------------------------------------------------------------
'QueryLimiting.disable' calls with references to an issue which doesn't have 'querylimiting-disable' search label (0 total):
[]
--------------------------------------------------------------------------------
'QueryLimiting.disable' calls with no issue iid (4 total):
[{:file_location=>"app/controllers/graphql_controller.rb:72",
:line=>" Gitlab::QueryLimiting.disable!(disable_issue)",
:issue_iid=>0,
:has_issue_iid=>false},
{:file_location=>"scripts/perf/query_limiting_report.rb:5",
:line=>
"# Prints a report which helps reconcile occurrences of the `QueryLimiting.disable(ISSUE_LINK)`",
:issue_iid=>0,
:has_issue_iid=>false},
{:file_location=>"scripts/perf/query_limiting_report.rb:21",
:line=>" CODE_LINES_SEARCH_STRING = 'QueryLimiting.disable'",
:issue_iid=>0,
:has_issue_iid=>false},
{:file_location=>"spec/support/sidekiq_middleware.rb:22",
:line=>" ::Gitlab::QueryLimiting.disable!('https://mock-issue')",
:issue_iid=>0,
:has_issue_iid=>false}]
Edited by Chad Woolley