Enable labels to use reference filter cache

What does this MR do?

With the refactored Banzai reference cache, we now enable the LabelReferenceFilter to take advantage of it.

You can see the reduced SQL queries I've added as review comments to the spec.

Related to #327630 (closed)

Database

Plan of the UNION query, which targets the Gitlab.org group and Gitlab project, query for the valid label APM and several invalid labels.

SELECT "labels".* FROM ((SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" IN (1, 2))
UNION
(SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" IN ('APM', 'werty', 'ertyu', 'rtyui'))) labels ORDER BY "labels"."title" ASC

Summary

Time: 197.195 ms  
  - planning: 1.934 ms  
  - execution: 195.261 ms  
    - I/O read: 193.742 ms  
    - I/O write: 0.000 ms  
  
Shared buffers:  
  - hits: 77 (~616.00 KiB) from the buffer pool  
  - reads: 140 (~1.10 MiB) from the OS file cache, including disk I/O  
  - dirtied: 0  
  - writes: 0  

Explain

Sort  (cost=158.75..158.75 rows=2 width=1162) (actual time=195.115..195.119 rows=1 loops=1)
   Sort Key: labels.title
   Sort Method: quicksort  Memory: 25kB
   Buffers: shared hit=77 read=140
   I/O Timings: read=193.742 write=0.000
   ->  Unique  (cost=158.65..158.72 rows=2 width=1162) (actual time=195.081..195.086 rows=1 loops=1)
         Buffers: shared hit=74 read=140
         I/O Timings: read=193.742 write=0.000
         ->  Sort  (cost=158.65..158.65 rows=2 width=1162) (actual time=195.080..195.083 rows=1 loops=1)
               Sort Key: labels.id, labels.title, labels.color, labels.project_id, labels.created_at, labels.updated_at, labels.template, labels.description, labels.description_html, labels.type, labels.group_id, labels.cached_markdown_version, labels.remove_on_close
               Sort Method: quicksort  Memory: 25kB
               Buffers: shared hit=74 read=140
               I/O Timings: read=193.742 write=0.000
               ->  Append  (cost=0.43..158.64 rows=2 width=1162) (actual time=174.046..195.046 rows=1 loops=1)
                     Buffers: shared hit=63 read=140
                     I/O Timings: read=193.742 write=0.000
                     ->  Index Scan using labels_pkey on public.labels  (cost=0.43..5.64 rows=1 width=91) (actual time=11.686..11.686 rows=0 loops=1)
                           Index Cond: (labels.id = ANY ('{1,2}'::integer[]))
                           Filter: ((((labels.type)::text = 'GroupLabel'::text) AND (labels.group_id = 9970)) OR (((labels.type)::text = 'ProjectLabel'::text) AND (labels.project_id = 278964)))
                           Rows Removed by Filter: 0
                           Buffers: shared hit=6 read=3
                           I/O Timings: read=11.641 write=0.000
                     ->  Bitmap Heap Scan on public.labels labels_1  (cost=139.08..152.96 rows=1 width=91) (actual time=162.359..183.355 rows=1 loops=1)
                           Filter: (((labels_1.title)::text = ANY ('{APM,werty,ertyu,rtyui}'::text[])) AND ((((labels_1.type)::text = 'GroupLabel'::text) AND (labels_1.group_id = 9970)) OR (((labels_1.type)::text = 'ProjectLabel'::text) AND (labels_1.project_id = 278964))))
                           Rows Removed by Filter: 124
                           Buffers: shared hit=57 read=137
                           I/O Timings: read=182.102 write=0.000
                           ->  BitmapOr  (cost=139.08..139.08 rows=9 width=0) (actual time=20.960..20.961 rows=0 loops=1)
                                 Buffers: shared hit=57 read=22
                                 I/O Timings: read=20.409 write=0.000
                                 ->  Bitmap Index Scan using index_labels_on_group_id_and_project_id_and_title  (cost=0.00..137.08 rows=1 width=0) (actual time=15.973..15.973 rows=1 loops=1)
                                       Index Cond: ((labels_1.group_id = 9970) AND ((labels_1.title)::text = ANY ('{APM,werty,ertyu,rtyui}'::text[])))
                                       Buffers: shared hit=57 read=19
                                       I/O Timings: read=15.468 write=0.000
                                 ->  Bitmap Index Scan using index_labels_on_project_id  (cost=0.00..2.00 rows=9 width=0) (actual time=4.984..4.984 rows=124 loops=1)
                                       Index Cond: (labels_1.project_id = 278964)
                                       Buffers: shared read=3
                                       I/O Timings: read=4.941 write=0.000

Does this MR meet the acceptance criteria?

Adding several unique and duplicate label references here, so we can easily see the before and after effects on the performance bar timing and sql count.

Before adding labels (113 queries)

0.497ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_details".* FROM "user_details" WHERE "user_details"."user_id" = 194645 LIMIT 1  
Replica
0.733ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "identities" WHERE "identities"."user_id" = 194645 AND (provider LIKE 'ldap%' AND extern_uid IS NOT NULL) LIMIT 1  
Primary
0.52ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = 194645 LIMIT 1  
Replica
0.524ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/user/avatar/194645/avatar.png', 'user/avatar/194645/avatar.png') ORDER BY "uploads"."id" ASC LIMIT 1000 
Replica
0.057ms	
SELECT "projects"."id" AS t0_r0, "projects"."name" AS t0_r1, "projects"."path" AS t0_r2, "projects"."description" AS t0_r3, "projects"."created_at" AS t0_r4, "projects"."updated_at" AS t0_r5, "projects"."creator_id" AS t0_r6, "projects"."namespace_id" AS t0_r7, "projects"."last_activity_at" AS t0_r8, "projects"."import_url" AS t0_r9, "projects"."visibility_level" AS t0_r10, "projects"."archived" AS t0_r11, "projects"."merge_requests_template" AS t0_r12, "projects"."star_count" AS t0_r13, "projects"."merge_requests_rebase_enabled" AS t0_r14, "projects"."import_type" AS t0_r15, "projects"."import_source" AS t0_r16, "projects"."avatar" AS t0_r17, "projects"."approvals_before_merge" AS t0_r18, "projects"."reset_approvals_on_push" AS t0_r19, "projects"."merge_requests_ff_only_enabled" AS t0_r20, "projects"."issues_template" AS t0_r21, "projects"."mirror" AS t0_r22, "projects"."mirror_user_id" AS t0_r23, "projects"."shared_runners_enabled" AS t0_r24, "projects"."runners_token" AS t0_r25, "projects"."build_coverage_regex" AS t0_r26, "projects"."build_allow_git_fetch" AS t0_r27, "projects"."build_timeout" AS t0_r28, "projects"."mirror_trigger_builds" AS t0_r29, "projects"."public_builds" AS t0_r30, "projects"."pending_delete" AS t0_r31, "projects"."last_repository_check_failed" AS t0_r32, "projects"."last_repository_check_at" AS t0_r33, "projects"."container_registry_enabled" AS t0_r34, "projects"."only_allow_merge_if_pipeline_succeeds" AS t0_r35, "projects"."has_external_issue_tracker" AS t0_r36, "projects"."repository_storage" AS t0_r37, "projects"."request_access_enabled" AS t0_r38, "projects"."has_external_wiki" AS t0_r39, "projects"."repository_read_only" AS t0_r40, "projects"."lfs_enabled" AS t0_r41, "projects"."description_html" AS t0_r42, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t0_r43, "projects"."repository_size_limit" AS t0_r44, "projects"."service_desk_enabled" AS t0_r45, "projects"."printing_merge_request_link_enabled" AS t0_r46, "projects"."auto_cancel_pending_pipelines" AS t0_r47, "projects"."cached_markdown_version" AS t0_r48, "projects"."last_repository_updated_at" AS t0_r49, "projects"."ci_config_path" AS t0_r50, "projects"."disable_overriding_approvers_per_merge_request" AS t0_r51, "projects"."delete_error" AS t0_r52, "projects"."storage_version" AS t0_r53, "projects"."resolve_outdated_diff_discussions" AS t0_r54, "projects"."remote_mirror_available_overridden" AS t0_r55, "projects"."only_mirror_protected_branches" AS t0_r56, "projects"."pull_mirror_available_overridden" AS t0_r57, "projects"."jobs_cache_index" AS t0_r58, "projects"."external_authorization_classification_label" AS t0_r59, "projects"."mirror_overwrites_diverged_branches" AS t0_r60, "projects"."external_webhook_token" AS t0_r61, "projects"."pages_https_only" AS t0_r62, "projects"."packages_enabled" AS t0_r63, "projects"."merge_requests_author_approval" AS t0_r64, "projects"."pool_repository_id" AS t0_r65, "projects"."runners_token_encrypted" AS t0_r66, "projects"."bfg_object_map" AS t0_r67, "projects"."detected_repository_languages" AS t0_r68, "projects"."merge_requests_disable_committers_approval" AS t0_r69, "projects"."require_password_to_approve" AS t0_r70, "projects"."emails_disabled" AS t0_r71, "projects"."max_pages_size" AS t0_r72, "projects"."max_artifacts_size" AS t0_r73, "projects"."remove_source_branch_after_merge" AS t0_r74, "projects"."marked_for_deletion_at" AS t0_r75, "projects"."marked_for_deletion_by_user_id" AS t0_r76, "projects"."suggestion_commit_message" AS t0_r77, "projects"."autoclose_referenced_issues" AS t0_r78, "routes"."id" AS t1_r0, "routes"."source_id" AS t1_r1, "routes"."source_type" AS t1_r2, "routes"."path" AS t1_r3, "routes"."created_at" AS t1_r4, "routes"."updated_at" AS t1_r5, "routes"."name" AS t1_r6 FROM "projects" LEFT OUTER JOIN "routes" ON "routes"."source_type" = 'Project' AND "routes"."source_id" = "projects"."id" WHERE "routes"."path" = 'gitlab-org/gitlab' LIMIT 1  
Cached
Replica
0.576ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Replica
0.532ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT DISTINCT "plans".* FROM "plans" INNER JOIN "gitlab_subscriptions" ON "gitlab_subscriptions"."hosted_plan_id" = "plans"."id" WHERE "plans"."name" IN ('bronze', 'silver', 'premium', 'gold', 'ultimate', 'ultimate_trial', 'premium_trial') AND "gitlab_subscriptions"."namespace_id" = 9970  
Replica
0.358ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ip_restrictions".* FROM "ip_restrictions" WHERE "ip_restrictions"."group_id" = 9970  
Replica
0.564ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964 LIMIT 1  
Replica
1.153ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 278964 AND "merge_requests"."iid" = 61648 LIMIT 1  
Replica
0.588ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 99774863  
Replica
0.436ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_assignees".* FROM "merge_request_assignees" WHERE "merge_request_assignees"."merge_request_id" = 99774863  
Replica
0.693ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Replica
0.331ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_statuses".* FROM "user_statuses" WHERE "user_statuses"."user_id" = 194645  
Replica
0.036ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.055ms	
SELECT "user_statuses".* FROM "user_statuses" WHERE "user_statuses"."user_id" = 194645  
Cached
Replica
0.461ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_blocks".* FROM "merge_request_blocks" WHERE "merge_request_blocks"."blocked_merge_request_id" = 99774863  
Replica
0.55ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Replica
0.425ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 9970 LIMIT 1  
Replica
0.471ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT MAX("project_authorizations"."access_level") AS maximum_access_level, "project_authorizations"."user_id" AS project_authorizations_user_id FROM "project_authorizations" WHERE "project_authorizations"."project_id" = 278964 AND "project_authorizations"."user_id" = 194645 GROUP BY "project_authorizations"."user_id"  
Replica
2.26ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM ((SELECT "members".* FROM "members" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "users"."state" = 'active' AND "members"."requested_at" IS NULL AND "members"."invite_token" IS NULL AND (members.access_level > 5) AND (members.access_level > 5) AND "members"."source_id" = 9970) UNION (WITH "group_group_links_cte" AS MATERIALIZED (SELECT "group_group_links".* FROM "group_group_links" WHERE "group_group_links"."shared_group_id" = 9970) SELECT "members"."id", LEAST("group_group_links"."group_access", "members"."access_level") AS access_level, "members"."source_id", "members"."source_type", "members"."user_id", "members"."notification_level", "members"."type", "members"."created_at", "members"."updated_at", "members"."created_by_id", "members"."invite_email", "members"."invite_token", "members"."invite_accepted_at", "members"."requested_at", "members"."expires_at", "members"."ldap", "members"."override" FROM "members", "group_group_links_cte" AS "group_group_links" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."source_id" = "group_group_links"."shared_with_group_id" AND "members"."source_type" = 'Namespace' AND (members.access_level > 5))) members LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND (("members"."user_id" IS NULL AND "members"."invite_token" IS NOT NULL) OR "users"."state" = 'active') AND "members"."requested_at" IS NULL AND (members.access_level > 5) AND "members"."access_level" = 50 AND "members"."user_id" = 194645 LIMIT 1  
Primary
1.066ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Replica
0.514ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 196830017 LIMIT 1  
Replica
0.48ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_context_commits".* FROM "merge_request_context_commits" WHERE "merge_request_context_commits"."merge_request_id" = 99774863 ORDER BY committed_date DESC  
Replica
0.457ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_diff_commits".* FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" = 196830017 ORDER BY "merge_request_diff_commits"."merge_request_diff_id" ASC, "merge_request_diff_commits"."relative_order" ASC  
Replica
0.463ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 1850113 LIMIT 1  
Replica
0.054ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
0.453ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Replica
1.664ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 99774863 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC  
Replica
1.772ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "todos".* FROM "todos" WHERE "todos"."user_id" = 194645 AND "todos"."target_type" = 'MergeRequest' AND "todos"."target_id" = 99774863 AND "todos"."state" = 'pending' LIMIT 1  
Replica
0.426ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "protected_branches".* FROM "protected_branches" WHERE "protected_branches"."project_id" = 278964 
Replica
0.435ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "protected_branch_push_access_levels".* FROM "protected_branch_push_access_levels" WHERE "protected_branch_push_access_levels"."protected_branch_id" = 109607  
Replica
0.535ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 2584649 LIMIT 1  
Replica
4.641ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" = 'GroupMember' AND "members"."source_id" = 2584649 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."access_level" != 5 AND "users"."id" = 194645 LIMIT 1  
Primary
0.736ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 1786152 LIMIT 1  
Replica
0.847ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 2324599 LIMIT 1  
Replica
0.415ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "protected_branch_merge_access_levels".* FROM "protected_branch_merge_access_levels" WHERE "protected_branch_merge_access_levels"."protected_branch_id" = 109607  
Replica
0.069ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 1786152 LIMIT 1  
Cached
Replica
0.036ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 2324599 LIMIT 1  
Cached
Replica
0.051ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 2584649 LIMIT 1  
Cached
Replica
0.061ms	
SELECT 1 AS one FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" = 'GroupMember' AND "members"."source_id" = 2584649 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."access_level" != 5 AND "users"."id" = 194645 LIMIT 1  
Cached
Primary
0.051ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Cached
Replica
0.776ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."owner_id" = 194645 AND "namespaces"."type" IS NULL LIMIT 1  
Replica
0.737ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."id" = 316356654 LIMIT 1  
Replica
0.726ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."pipeline_id" = 316356654 AND "ci_pipeline_artifacts"."file_type" = 1 LIMIT 1  
Primary
0.056ms	
SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964 LIMIT 1  
Cached
Replica
48.935ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ WITH "shas" AS MATERIALIZED (SELECT DISTINCT "merge_request_diff_commits"."sha" FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" IN (SELECT "merge_request_diffs"."id" FROM "merge_request_diffs" WHERE "merge_request_diffs"."merge_request_id" = 99774863 AND "merge_request_diffs"."diff_type" = 1 ORDER BY "merge_request_diffs"."id" DESC LIMIT 100) LIMIT 10000) SELECT COUNT(*) FROM ((SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."source" = 10 AND "ci_pipelines"."merge_request_id" = 99774863 AND "ci_pipelines"."project_id" IN (278964, 278964)) UNION (SELECT "ci_pipelines".* FROM "ci_pipelines" INNER JOIN "shas" ON encode("shas"."sha", 'hex') = "ci_pipelines"."sha" WHERE "ci_pipelines"."project_id" = 278964 AND ("ci_pipelines"."source" IN (1, 2, 3, 4, 5, 6, 7, 8, 11) OR "ci_pipelines"."source" IS NULL) AND "ci_pipelines"."ref" = 'bw-reference-label-caching' AND "ci_pipelines"."tag" = FALSE)) ci_pipelines  
Replica
0.479ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_diff_commits"."sha" FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" = 196830017 ORDER BY "merge_request_diff_commits"."merge_request_diff_id" ASC, "merge_request_diff_commits"."relative_order" ASC LIMIT 100  
Replica
0.924ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT COUNT(*) FROM ((SELECT "notes".* FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest') UNION ALL (SELECT "notes".* FROM "notes" WHERE "notes"."system" = FALSE AND "notes"."project_id" IN (278964, 278964) AND "notes"."noteable_type" = 'Commit' AND "notes"."commit_id" IN ('01be9b5fa07c0b7f04dfae742f6c655db3fe2955', '58d5c4bef6a6807255671f2c82d08bc72a5ef058', 'b875724e0f6cadff1e3e823418d287a5a3c5ce29'))) notes WHERE "notes"."system" = FALSE  
Replica
0.732ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "notes"."id" FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest'  
Replica
0.99ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964  
Replica
0.45ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964  
Replica
0.688ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970  
Replica
0.64ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970  
Replica
0.886ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issues".* FROM "issues" WHERE "issues"."id" = 85130477  
Replica
0.046ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.378ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issue_assignees".* FROM "issue_assignees" WHERE "issue_assignees"."issue_id" = 85130477  
Replica
0.034ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.038ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964  
Cached
Replica
0.051ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970  
Cached
Replica
0.038ms	
SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964  
Cached
Replica
0.423ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 278964 
Replica
0.085ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
1.412ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" = 97889785  
Replica
0.081ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.537ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_assignees".* FROM "merge_request_assignees" WHERE "merge_request_assignees"."merge_request_id" = 97889785  
Replica
0.063ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.043ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964  
Cached
Replica
0.052ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970  
Cached
Replica
0.496ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 9970 
Replica
0.04ms	
SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964  
Cached
Replica
0.046ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 278964  
Cached
Replica
0.914ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 194645 LIMIT 1  
Replica
0.559ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 278964 AND "routes"."source_type" = 'Project' LIMIT 1  
Replica
6.539ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" WHERE "ci_job_artifacts"."id" IN (SELECT max(ci_job_artifacts.id) as id FROM "ci_job_artifacts" INNER JOIN "ci_builds" ON "ci_job_artifacts"."job_id" = "ci_builds"."id" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 316356654 AND "ci_job_artifacts"."file_type" IN (4, 5, 6, 7, 8, 9, 10, 101, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) GROUP BY "ci_job_artifacts"."file_type")  
Replica
1.07ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_builds".* FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."id" IN (1325143593, 1325143596, 1325143604, 1325143417, 1325143588, 1325143614, 1325143584, 1325143530)  
Replica
0.042ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.059ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.057ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
0.061ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Cached
Replica
0.087ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.075ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
2.094ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 316356654 AND ("ci_builds"."retried" = FALSE OR "ci_builds"."retried" IS NULL) AND (EXISTS (SELECT 1 FROM "ci_job_artifacts" WHERE (ci_builds.id = ci_job_artifacts.job_id) AND "ci_job_artifacts"."file_type" = 12)) LIMIT 1  
Primary
0.572ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_callouts".* FROM "user_callouts" WHERE "user_callouts"."user_id" = 194645  
Replica
1.007ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issues".* FROM "issues" INNER JOIN "merge_requests_closing_issues" ON "issues"."id" = "merge_requests_closing_issues"."issue_id" WHERE "merge_requests_closing_issues"."merge_request_id" = 99774863  
Replica
0.566ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "grafana_integrations".* FROM "grafana_integrations" WHERE "grafana_integrations"."project_id" = 278964 LIMIT 1  
Replica
2.752ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects"."id" AS t0_r0, "projects"."name" AS t0_r1, "projects"."path" AS t0_r2, "projects"."description" AS t0_r3, "projects"."created_at" AS t0_r4, "projects"."updated_at" AS t0_r5, "projects"."creator_id" AS t0_r6, "projects"."namespace_id" AS t0_r7, "projects"."last_activity_at" AS t0_r8, "projects"."import_url" AS t0_r9, "projects"."visibility_level" AS t0_r10, "projects"."archived" AS t0_r11, "projects"."merge_requests_template" AS t0_r12, "projects"."star_count" AS t0_r13, "projects"."merge_requests_rebase_enabled" AS t0_r14, "projects"."import_type" AS t0_r15, "projects"."import_source" AS t0_r16, "projects"."avatar" AS t0_r17, "projects"."approvals_before_merge" AS t0_r18, "projects"."reset_approvals_on_push" AS t0_r19, "projects"."merge_requests_ff_only_enabled" AS t0_r20, "projects"."issues_template" AS t0_r21, "projects"."mirror" AS t0_r22, "projects"."mirror_user_id" AS t0_r23, "projects"."shared_runners_enabled" AS t0_r24, "projects"."runners_token" AS t0_r25, "projects"."build_coverage_regex" AS t0_r26, "projects"."build_allow_git_fetch" AS t0_r27, "projects"."build_timeout" AS t0_r28, "projects"."mirror_trigger_builds" AS t0_r29, "projects"."public_builds" AS t0_r30, "projects"."pending_delete" AS t0_r31, "projects"."last_repository_check_failed" AS t0_r32, "projects"."last_repository_check_at" AS t0_r33, "projects"."container_registry_enabled" AS t0_r34, "projects"."only_allow_merge_if_pipeline_succeeds" AS t0_r35, "projects"."has_external_issue_tracker" AS t0_r36, "projects"."repository_storage" AS t0_r37, "projects"."request_access_enabled" AS t0_r38, "projects"."has_external_wiki" AS t0_r39, "projects"."repository_read_only" AS t0_r40, "projects"."lfs_enabled" AS t0_r41, "projects"."description_html" AS t0_r42, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t0_r43, "projects"."repository_size_limit" AS t0_r44, "projects"."service_desk_enabled" AS t0_r45, "projects"."printing_merge_request_link_enabled" AS t0_r46, "projects"."auto_cancel_pending_pipelines" AS t0_r47, "projects"."cached_markdown_version" AS t0_r48, "projects"."last_repository_updated_at" AS t0_r49, "projects"."ci_config_path" AS t0_r50, "projects"."disable_overriding_approvers_per_merge_request" AS t0_r51, "projects"."delete_error" AS t0_r52, "projects"."storage_version" AS t0_r53, "projects"."resolve_outdated_diff_discussions" AS t0_r54, "projects"."remote_mirror_available_overridden" AS t0_r55, "projects"."only_mirror_protected_branches" AS t0_r56, "projects"."pull_mirror_available_overridden" AS t0_r57, "projects"."jobs_cache_index" AS t0_r58, "projects"."external_authorization_classification_label" AS t0_r59, "projects"."mirror_overwrites_diverged_branches" AS t0_r60, "projects"."external_webhook_token" AS t0_r61, "projects"."pages_https_only" AS t0_r62, "projects"."packages_enabled" AS t0_r63, "projects"."merge_requests_author_approval" AS t0_r64, "projects"."pool_repository_id" AS t0_r65, "projects"."runners_token_encrypted" AS t0_r66, "projects"."bfg_object_map" AS t0_r67, "projects"."detected_repository_languages" AS t0_r68, "projects"."merge_requests_disable_committers_approval" AS t0_r69, "projects"."require_password_to_approve" AS t0_r70, "projects"."emails_disabled" AS t0_r71, "projects"."max_pages_size" AS t0_r72, "projects"."max_artifacts_size" AS t0_r73, "projects"."remove_source_branch_after_merge" AS t0_r74, "projects"."marked_for_deletion_at" AS t0_r75, "projects"."marked_for_deletion_by_user_id" AS t0_r76, "projects"."suggestion_commit_message" AS t0_r77, "projects"."autoclose_referenced_issues" AS t0_r78, "routes"."id" AS t1_r0, "routes"."source_id" AS t1_r1, "routes"."source_type" AS t1_r2, "routes"."path" AS t1_r3, "routes"."created_at" AS t1_r4, "routes"."updated_at" AS t1_r5, "routes"."name" AS t1_r6, "namespaces"."id" AS t2_r0, "namespaces"."name" AS t2_r1, "namespaces"."path" AS t2_r2, "namespaces"."owner_id" AS t2_r3, "namespaces"."created_at" AS t2_r4, "namespaces"."updated_at" AS t2_r5, "namespaces"."type" AS t2_r6, "namespaces"."description" AS t2_r7, "namespaces"."avatar" AS t2_r8, "namespaces"."membership_lock" AS t2_r9, "namespaces"."share_with_group_lock" AS t2_r10, "namespaces"."visibility_level" AS t2_r11, "namespaces"."request_access_enabled" AS t2_r12, "namespaces"."ldap_sync_status" AS t2_r13, "namespaces"."ldap_sync_error" AS t2_r14, "namespaces"."ldap_sync_last_update_at" AS t2_r15, "namespaces"."ldap_sync_last_successful_update_at" AS t2_r16, "namespaces"."ldap_sync_last_sync_at" AS t2_r17, "namespaces"."lfs_enabled" AS t2_r18, "namespaces"."description_html" AS t2_r19, "namespaces"."parent_id" AS t2_r20, "namespaces"."shared_runners_minutes_limit" AS t2_r21, "namespaces"."repository_size_limit" AS t2_r22, "namespaces"."require_two_factor_authentication" AS t2_r23, "namespaces"."two_factor_grace_period" AS t2_r24, "namespaces"."cached_markdown_version" AS t2_r25, "namespaces"."project_creation_level" AS t2_r26, "namespaces"."runners_token" AS t2_r27, "namespaces"."file_template_project_id" AS t2_r28, "namespaces"."saml_discovery_token" AS t2_r29, "namespaces"."runners_token_encrypted" AS t2_r30, "namespaces"."custom_project_templates_group_id" AS t2_r31, "namespaces"."auto_devops_enabled" AS t2_r32, "namespaces"."extra_shared_runners_minutes_limit" AS t2_r33, "namespaces"."last_ci_minutes_notification_at" AS t2_r34, "namespaces"."last_ci_minutes_usage_notification_level" AS t2_r35, "namespaces"."subgroup_creation_level" AS t2_r36, "namespaces"."emails_disabled" AS t2_r37, "namespaces"."max_pages_size" AS t2_r38, "namespaces"."max_artifacts_size" AS t2_r39, "namespaces"."mentions_disabled" AS t2_r40, "namespaces"."default_branch_protection" AS t2_r41, "namespaces"."unlock_membership_to_ldap" AS t2_r42, "namespaces"."max_personal_access_token_lifetime" AS t2_r43, "namespaces"."push_rule_id" AS t2_r44, "namespaces"."shared_runners_enabled" AS t2_r45, "namespaces"."allow_descendants_override_disabled_shared_runners" AS t2_r46, "namespaces"."traversal_ids" AS t2_r47, "routes_namespaces"."id" AS t3_r0, "routes_namespaces"."source_id" AS t3_r1, "routes_namespaces"."source_type" AS t3_r2, "routes_namespaces"."path" AS t3_r3, "routes_namespaces"."created_at" AS t3_r4, "routes_namespaces"."updated_at" AS t3_r5, "routes_namespaces"."name" AS t3_r6 FROM "projects" LEFT OUTER JOIN "routes" ON "routes"."source_type" = 'Project' AND "routes"."source_id" = "projects"."id" LEFT OUTER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" LEFT OUTER JOIN "routes" "routes_namespaces" ON "routes_namespaces"."source_type" = 'Namespace' AND "routes_namespaces"."source_id" = "namespaces"."id" WHERE ((LOWER(routes.path) = LOWER('gitlab-org/gitlab')))  
Replica
0.972ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issues".* FROM "issues" WHERE "issues"."project_id" = 278964 AND "issues"."iid" = 327630  
Replica
0.761ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 278964 AND "merge_requests"."iid" = 60566  
Replica
0.882ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'security' ORDER BY "labels"."title" ASC LIMIT 1  
Replica
0.067ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
0.57ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 2779335 ORDER BY "labels"."title" ASC LIMIT 1  
Replica
0.066ms	
SELECT "issues".* FROM "issues" WHERE "issues"."project_id" = 278964 AND "issues"."iid" = 327630  
Cached
Replica
1.081ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 278964 AND ("ci_pipelines"."source" IN (1, 2, 3, 4, 5, 6, 7, 8, 10, 11) OR "ci_pipelines"."source" IS NULL) AND "ci_pipelines"."sha" = 'fa007604f58dc61126e9d62e37c0e18a123db838' AND "ci_pipelines"."ref" = 'master' ORDER BY "ci_pipelines"."id" DESC LIMIT 1  
Replica
1.681ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" WHERE "ci_job_artifacts"."id" IN (SELECT max(ci_job_artifacts.id) as id FROM "ci_job_artifacts" INNER JOIN "ci_builds" ON "ci_job_artifacts"."job_id" = "ci_builds"."id" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 316354834 AND "ci_job_artifacts"."file_type" IN (4, 5, 6, 7, 8, 9, 10, 101, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) GROUP BY "ci_job_artifacts"."file_type")  
Replica
1.017ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_builds".* FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."id" = 1325136367 
Replica
0.596ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT COUNT(*) FROM (SELECT 1 AS one FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest' LIMIT 10) subquery_for_count  
Replica
0.042ms	
SELECT "protected_branches".* FROM "protected_branches" WHERE "protected_branches"."project_id" = 278964  
Cached
Replica
0.038ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
0.037ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Cached
Replica
0.79ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."pipeline_id" = 316356654 AND "ci_pipeline_artifacts"."file_type" = 2 LIMIT 1  
Primary
1.096ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "users" INNER JOIN "merge_request_reviewers" ON "users"."id" = "merge_request_reviewers"."user_id" WHERE "merge_request_reviewers"."merge_request_id" = 99774863 LIMIT 1  
Primary
0.052ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Cached
Replica
0.743ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/group/avatar/9970/logo-extra-whitespace.png', 'group/avatar/9970/logo-extra-whitespace.png', 'uploads/-/system/group/avatar/2584649/61yepqAnAZL._UX522_.jpg', 'group/avatar/2584649/61yepqAnAZL._UX522_.jpg') ORDER BY "uploads"."id" ASC LIMIT 1000  
Replica
0.571ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/project/avatar/278964/logo-extra-whitespace.png', 'project/avatar/278964/logo-extra-whitespace.png') ORDER BY "uploads"."id" ASC LIMIT 1000  
Replica
0.537ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_statuses".* FROM "user_statuses" WHERE "user_statuses"."user_id" = 194645 LIMIT 1  
Replica
4.329ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "projects" WHERE "projects"."namespace_id" IN (SELECT traversal_ids[array_length(traversal_ids, 1)] AS id FROM "namespaces" WHERE (traversal_ids @> ('{9970}'))) AND "projects"."shared_runners_enabled" = TRUE LIMIT 1  
Primary
0.737ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "onboarding_progresses" WHERE "onboarding_progresses"."namespace_id" = 9970 LIMIT 1 
Primary
0.627ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "services".* FROM "services" WHERE "services"."type" = 'JiraService' AND "services"."project_id" = 278964 LIMIT 1  
Replica
0.553ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_settings".* FROM "project_settings" WHERE "project_settings"."project_id" = 278964 LIMIT 1  
Replica
0.46ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "gitlab_subscriptions".* FROM "gitlab_subscriptions" WHERE "gitlab_subscriptions"."namespace_id" = 9970 LIMIT 1  
Replica
0.046ms	
SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 9970 LIMIT 1  
Cached
Replica
1.986ms	
/*application:web,correlation_id:01F7PGJVWPG2E3WQDTGBCMTA69,endpoint_id:Projects::MergeRequestsController#show*/ SELECT MAX("members"."access_level") AS maximum_access_level, "members"."user_id" AS members_user_id FROM ((SELECT "members".* FROM "members" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "users"."state" = 'active' AND "members"."requested_at" IS NULL AND "members"."invite_token" IS NULL AND (members.access_level > 5) AND (members.access_level > 5) AND "members"."source_id" = 9970) UNION (WITH "group_group_links_cte" AS MATERIALIZED (SELECT "group_group_links".* FROM "group_group_links" WHERE "group_group_links"."shared_group_id" = 9970) SELECT "members"."id", LEAST("group_group_links"."group_access", "members"."access_level") AS access_level, "members"."source_id", "members"."source_type", "members"."user_id", "members"."notification_level", "members"."type", "members"."created_at", "members"."updated_at", "members"."created_by_id", "members"."invite_email", "members"."invite_token", "members"."invite_accepted_at", "members"."requested_at", "members"."expires_at", "members"."ldap", "members"."override" FROM "members", "group_group_links_cte" AS "group_group_links" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."source_id" = "group_group_links"."shared_with_group_id" AND "members"."source_type" = 'Namespace' AND (members.access_level > 5))) members WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "members"."user_id" = 194645 GROUP BY "members"."user_id"  
Replica

backend banzai devopsplan

~"feature::maintenance" groupproject management missed:13.12 ~performance

priority2 sectiondev severity2 workflowin review

backend banzai devopsplan

After adding labels (144 queries)

0.405ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_details".* FROM "user_details" WHERE "user_details"."user_id" = 194645 LIMIT 1  
Replica
0.713ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "identities" WHERE "identities"."user_id" = 194645 AND (provider LIKE 'ldap%' AND extern_uid IS NOT NULL) LIMIT 1  
Primary
0.569ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = 194645 LIMIT 1  
Replica
0.515ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/user/avatar/194645/avatar.png', 'user/avatar/194645/avatar.png') ORDER BY "uploads"."id" ASC LIMIT 1000  
Replica
0.034ms	
SELECT "projects"."id" AS t0_r0, "projects"."name" AS t0_r1, "projects"."path" AS t0_r2, "projects"."description" AS t0_r3, "projects"."created_at" AS t0_r4, "projects"."updated_at" AS t0_r5, "projects"."creator_id" AS t0_r6, "projects"."namespace_id" AS t0_r7, "projects"."last_activity_at" AS t0_r8, "projects"."import_url" AS t0_r9, "projects"."visibility_level" AS t0_r10, "projects"."archived" AS t0_r11, "projects"."merge_requests_template" AS t0_r12, "projects"."star_count" AS t0_r13, "projects"."merge_requests_rebase_enabled" AS t0_r14, "projects"."import_type" AS t0_r15, "projects"."import_source" AS t0_r16, "projects"."avatar" AS t0_r17, "projects"."approvals_before_merge" AS t0_r18, "projects"."reset_approvals_on_push" AS t0_r19, "projects"."merge_requests_ff_only_enabled" AS t0_r20, "projects"."issues_template" AS t0_r21, "projects"."mirror" AS t0_r22, "projects"."mirror_user_id" AS t0_r23, "projects"."shared_runners_enabled" AS t0_r24, "projects"."runners_token" AS t0_r25, "projects"."build_coverage_regex" AS t0_r26, "projects"."build_allow_git_fetch" AS t0_r27, "projects"."build_timeout" AS t0_r28, "projects"."mirror_trigger_builds" AS t0_r29, "projects"."public_builds" AS t0_r30, "projects"."pending_delete" AS t0_r31, "projects"."last_repository_check_failed" AS t0_r32, "projects"."last_repository_check_at" AS t0_r33, "projects"."container_registry_enabled" AS t0_r34, "projects"."only_allow_merge_if_pipeline_succeeds" AS t0_r35, "projects"."has_external_issue_tracker" AS t0_r36, "projects"."repository_storage" AS t0_r37, "projects"."request_access_enabled" AS t0_r38, "projects"."has_external_wiki" AS t0_r39, "projects"."repository_read_only" AS t0_r40, "projects"."lfs_enabled" AS t0_r41, "projects"."description_html" AS t0_r42, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t0_r43, "projects"."repository_size_limit" AS t0_r44, "projects"."service_desk_enabled" AS t0_r45, "projects"."printing_merge_request_link_enabled" AS t0_r46, "projects"."auto_cancel_pending_pipelines" AS t0_r47, "projects"."cached_markdown_version" AS t0_r48, "projects"."last_repository_updated_at" AS t0_r49, "projects"."ci_config_path" AS t0_r50, "projects"."disable_overriding_approvers_per_merge_request" AS t0_r51, "projects"."delete_error" AS t0_r52, "projects"."storage_version" AS t0_r53, "projects"."resolve_outdated_diff_discussions" AS t0_r54, "projects"."remote_mirror_available_overridden" AS t0_r55, "projects"."only_mirror_protected_branches" AS t0_r56, "projects"."pull_mirror_available_overridden" AS t0_r57, "projects"."jobs_cache_index" AS t0_r58, "projects"."external_authorization_classification_label" AS t0_r59, "projects"."mirror_overwrites_diverged_branches" AS t0_r60, "projects"."external_webhook_token" AS t0_r61, "projects"."pages_https_only" AS t0_r62, "projects"."packages_enabled" AS t0_r63, "projects"."merge_requests_author_approval" AS t0_r64, "projects"."pool_repository_id" AS t0_r65, "projects"."runners_token_encrypted" AS t0_r66, "projects"."bfg_object_map" AS t0_r67, "projects"."detected_repository_languages" AS t0_r68, "projects"."merge_requests_disable_committers_approval" AS t0_r69, "projects"."require_password_to_approve" AS t0_r70, "projects"."emails_disabled" AS t0_r71, "projects"."max_pages_size" AS t0_r72, "projects"."max_artifacts_size" AS t0_r73, "projects"."remove_source_branch_after_merge" AS t0_r74, "projects"."marked_for_deletion_at" AS t0_r75, "projects"."marked_for_deletion_by_user_id" AS t0_r76, "projects"."suggestion_commit_message" AS t0_r77, "projects"."autoclose_referenced_issues" AS t0_r78, "routes"."id" AS t1_r0, "routes"."source_id" AS t1_r1, "routes"."source_type" AS t1_r2, "routes"."path" AS t1_r3, "routes"."created_at" AS t1_r4, "routes"."updated_at" AS t1_r5, "routes"."name" AS t1_r6 FROM "projects" LEFT OUTER JOIN "routes" ON "routes"."source_type" = 'Project' AND "routes"."source_id" = "projects"."id" WHERE "routes"."path" = 'gitlab-org/gitlab' LIMIT 1  
Cached
Replica
0.555ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Replica
0.552ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT DISTINCT "plans".* FROM "plans" INNER JOIN "gitlab_subscriptions" ON "gitlab_subscriptions"."hosted_plan_id" = "plans"."id" WHERE "plans"."name" IN ('bronze', 'silver', 'premium', 'gold', 'ultimate', 'ultimate_trial', 'premium_trial') AND "gitlab_subscriptions"."namespace_id" = 9970  
Replica
0.379ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ip_restrictions".* FROM "ip_restrictions" WHERE "ip_restrictions"."group_id" = 9970  
Replica
0.492ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964 LIMIT 1  
Replica
2.41ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 278964 AND "merge_requests"."iid" = 61648 LIMIT 1  
Replica
0.398ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 99774863  
Replica
0.548ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_assignees".* FROM "merge_request_assignees" WHERE "merge_request_assignees"."merge_request_id" = 99774863  
Replica
0.638ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Replica
0.573ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_statuses".* FROM "user_statuses" WHERE "user_statuses"."user_id" = 194645  
Replica
0.034ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.034ms	
SELECT "user_statuses".* FROM "user_statuses" WHERE "user_statuses"."user_id" = 194645  
Cached
Replica
0.401ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_blocks".* FROM "merge_request_blocks" WHERE "merge_request_blocks"."blocked_merge_request_id" = 99774863  
Replica
0.557ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Replica
0.374ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 9970 LIMIT 1  
Replica
0.57ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT MAX("project_authorizations"."access_level") AS maximum_access_level, "project_authorizations"."user_id" AS project_authorizations_user_id FROM "project_authorizations" WHERE "project_authorizations"."project_id" = 278964 AND "project_authorizations"."user_id" = 194645 GROUP BY "project_authorizations"."user_id"  
Replica
2.122ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM ((SELECT "members".* FROM "members" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "users"."state" = 'active' AND "members"."requested_at" IS NULL AND "members"."invite_token" IS NULL AND (members.access_level > 5) AND (members.access_level > 5) AND "members"."source_id" = 9970) UNION (WITH "group_group_links_cte" AS MATERIALIZED (SELECT "group_group_links".* FROM "group_group_links" WHERE "group_group_links"."shared_group_id" = 9970) SELECT "members"."id", LEAST("group_group_links"."group_access", "members"."access_level") AS access_level, "members"."source_id", "members"."source_type", "members"."user_id", "members"."notification_level", "members"."type", "members"."created_at", "members"."updated_at", "members"."created_by_id", "members"."invite_email", "members"."invite_token", "members"."invite_accepted_at", "members"."requested_at", "members"."expires_at", "members"."ldap", "members"."override" FROM "members", "group_group_links_cte" AS "group_group_links" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."source_id" = "group_group_links"."shared_with_group_id" AND "members"."source_type" = 'Namespace' AND (members.access_level > 5))) members LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND (("members"."user_id" IS NULL AND "members"."invite_token" IS NOT NULL) OR "users"."state" = 'active') AND "members"."requested_at" IS NULL AND (members.access_level > 5) AND "members"."access_level" = 50 AND "members"."user_id" = 194645 LIMIT 1  
Primary
0.887ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Replica
0.412ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ BEGIN  
In a transaction
Primary
0.731ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 1850113 LIMIT 1  
In a transaction
Primary
1.296ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970) UNION (SELECT "namespaces".* FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "namespaces".* FROM "base_and_ancestors" AS "namespaces"  
In a transaction
Primary
0.706ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
In a transaction
Primary
1.116ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 278964 AND "merge_requests"."source_branch" = 'bw-reference-label-caching' AND "merge_requests"."target_branch" = 'master' AND "merge_requests"."source_project_id" = 278964 AND ("merge_requests"."state_id" IN (1)) AND "merge_requests"."id" != 99774863 ORDER BY "merge_requests"."id" ASC LIMIT 1  
In a transaction
Primary
8.682ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ UPDATE "merge_requests" SET "merge_status" = 'checking' WHERE "merge_requests"."id" = 99774863  
In a transaction
Primary
4.426ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ COMMIT  
Primary
0.594ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1 
Primary
0.402ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ BEGIN  
In a transaction
Primary
0.594ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 99774863 AND "merge_request_metrics"."target_project_id" = 278964 LIMIT 1  
In a transaction
Primary
0.327ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ COMMIT  
Primary
0.6ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 196830017 LIMIT 1 
Primary
0.746ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_context_commits".* FROM "merge_request_context_commits" WHERE "merge_request_context_commits"."merge_request_id" = 99774863 ORDER BY committed_date DESC  
Primary
0.639ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_diff_commits".* FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" = 196830017 ORDER BY "merge_request_diff_commits"."merge_request_diff_id" ASC, "merge_request_diff_commits"."relative_order" ASC  
Primary
0.047ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1 
Cached
Primary
2.847ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 99774863 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC  
Primary
0.728ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "todos".* FROM "todos" WHERE "todos"."user_id" = 194645 AND "todos"."target_type" = 'MergeRequest' AND "todos"."target_id" = 99774863 AND "todos"."state" = 'pending' LIMIT 1  
Primary
0.605ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "protected_branches".* FROM "protected_branches" WHERE "protected_branches"."project_id" = 278964  
Primary
0.68ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "protected_branch_push_access_levels".* FROM "protected_branch_push_access_levels" WHERE "protected_branch_push_access_levels"."protected_branch_id" = 109607  
Primary
0.748ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 2584649 LIMIT 1  
Primary
1.021ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" = 'GroupMember' AND "members"."source_id" = 2584649 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."access_level" != 5 AND "users"."id" = 194645 LIMIT 1  
Primary
1.092ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 1786152 LIMIT 1  
Primary
1.186ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 2324599 LIMIT 1  
Primary
0.523ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "protected_branch_merge_access_levels".* FROM "protected_branch_merge_access_levels" WHERE "protected_branch_merge_access_levels"."protected_branch_id" = 109607  
Primary
0.038ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 1786152 LIMIT 1  
Cached
Primary
0.046ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 2324599 LIMIT 1  
Cached
Primary
0.032ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 2584649 LIMIT 1  
Cached
Primary
0.039ms	
SELECT 1 AS one FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" = 'GroupMember' AND "members"."source_id" = 2584649 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."access_level" != 5 AND "users"."id" = 194645 LIMIT 1  
Cached
Primary
0.785ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."owner_id" = 194645 AND "namespaces"."type" IS NULL LIMIT 1  
Primary
0.791ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."id" = 316356654 LIMIT 1  
Primary
0.634ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."pipeline_id" = 316356654 AND "ci_pipeline_artifacts"."file_type" = 1 LIMIT 1  
Primary
0.665ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964 LIMIT 1  
Primary
17.038ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ WITH "shas" AS MATERIALIZED (SELECT DISTINCT "merge_request_diff_commits"."sha" FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" IN (SELECT "merge_request_diffs"."id" FROM "merge_request_diffs" WHERE "merge_request_diffs"."merge_request_id" = 99774863 AND "merge_request_diffs"."diff_type" = 1 ORDER BY "merge_request_diffs"."id" DESC LIMIT 100) LIMIT 10000) SELECT COUNT(*) FROM ((SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."source" = 10 AND "ci_pipelines"."merge_request_id" = 99774863 AND "ci_pipelines"."project_id" IN (278964, 278964)) UNION (SELECT "ci_pipelines".* FROM "ci_pipelines" INNER JOIN "shas" ON encode("shas"."sha", 'hex') = "ci_pipelines"."sha" WHERE "ci_pipelines"."project_id" = 278964 AND ("ci_pipelines"."source" IN (1, 2, 3, 4, 5, 6, 7, 8, 11) OR "ci_pipelines"."source" IS NULL) AND "ci_pipelines"."ref" = 'bw-reference-label-caching' AND "ci_pipelines"."tag" = FALSE)) ci_pipelines  
Primary
0.637ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_diff_commits"."sha" FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" = 196830017 ORDER BY "merge_request_diff_commits"."merge_request_diff_id" ASC, "merge_request_diff_commits"."relative_order" ASC LIMIT 100  
Primary
2.861ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT COUNT(*) FROM ((SELECT "notes".* FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest') UNION ALL (SELECT "notes".* FROM "notes" WHERE "notes"."system" = FALSE AND "notes"."project_id" IN (278964, 278964) AND "notes"."noteable_type" = 'Commit' AND "notes"."commit_id" IN ('01be9b5fa07c0b7f04dfae742f6c655db3fe2955', '58d5c4bef6a6807255671f2c82d08bc72a5ef058', 'b875724e0f6cadff1e3e823418d287a5a3c5ce29'))) notes WHERE "notes"."system" = FALSE  
Primary
60.417ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "notes"."id" FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest'  
Primary
1.681ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964  
Primary
0.684ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964  
Primary
0.784ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 
Primary
0.672ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970  
Primary
1.121ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issues".* FROM "issues" WHERE "issues"."id" = 85130477  
Primary
0.936ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Primary
0.721ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issue_assignees".* FROM "issue_assignees" WHERE "issue_assignees"."issue_id" = 85130477  
Primary
0.039ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Primary
0.033ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964  
Cached
Primary
0.043ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970  
Cached
Primary
0.033ms	
SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964  
Cached
Primary
0.553ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 278964  
Primary
0.943ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Primary
1.257ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" = 97889785  
Primary
0.061ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Primary
0.593ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_assignees".* FROM "merge_request_assignees" WHERE "merge_request_assignees"."merge_request_id" = 97889785  
Primary
0.036ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Primary
0.049ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964  
Cached
Primary
0.052ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970  
Cached
Primary
0.578ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 9970  
Primary
0.044ms	
SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964  
Cached
Primary
0.037ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 278964  
Cached
Primary
0.857ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 194645 LIMIT 1  
Primary
0.567ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 278964 AND "routes"."source_type" = 'Project' LIMIT 1 
Primary
5.048ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" WHERE "ci_job_artifacts"."id" IN (SELECT max(ci_job_artifacts.id) as id FROM "ci_job_artifacts" INNER JOIN "ci_builds" ON "ci_job_artifacts"."job_id" = "ci_builds"."id" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 316356654 AND "ci_job_artifacts"."file_type" IN (4, 5, 6, 7, 8, 9, 10, 101, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) GROUP BY "ci_job_artifacts"."file_type")  
Primary
1.332ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_builds".* FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."id" IN (1325143593, 1325143596, 1325143604, 1325143417, 1325143588, 1325143614, 1325143584, 1325143530)  
Primary
1.009ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Primary
0.033ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Primary
0.675ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Primary
0.033ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1 
Cached
Primary
0.032ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Primary
0.032ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Cached
Primary
1.261ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 316356654 AND ("ci_builds"."retried" = FALSE OR "ci_builds"."retried" IS NULL) AND (EXISTS (SELECT 1 FROM "ci_job_artifacts" WHERE (ci_builds.id = ci_job_artifacts.job_id) AND "ci_job_artifacts"."file_type" = 12)) LIMIT 1  
Primary
1.374ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_callouts".* FROM "user_callouts" WHERE "user_callouts"."user_id" = 194645  
Primary
1.188ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issues".* FROM "issues" INNER JOIN "merge_requests_closing_issues" ON "issues"."id" = "merge_requests_closing_issues"."issue_id" WHERE "merge_requests_closing_issues"."merge_request_id" = 99774863  
Primary
0.861ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "grafana_integrations".* FROM "grafana_integrations" WHERE "grafana_integrations"."project_id" = 278964 LIMIT 1  
Primary
2.443ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects"."id" AS t0_r0, "projects"."name" AS t0_r1, "projects"."path" AS t0_r2, "projects"."description" AS t0_r3, "projects"."created_at" AS t0_r4, "projects"."updated_at" AS t0_r5, "projects"."creator_id" AS t0_r6, "projects"."namespace_id" AS t0_r7, "projects"."last_activity_at" AS t0_r8, "projects"."import_url" AS t0_r9, "projects"."visibility_level" AS t0_r10, "projects"."archived" AS t0_r11, "projects"."merge_requests_template" AS t0_r12, "projects"."star_count" AS t0_r13, "projects"."merge_requests_rebase_enabled" AS t0_r14, "projects"."import_type" AS t0_r15, "projects"."import_source" AS t0_r16, "projects"."avatar" AS t0_r17, "projects"."approvals_before_merge" AS t0_r18, "projects"."reset_approvals_on_push" AS t0_r19, "projects"."merge_requests_ff_only_enabled" AS t0_r20, "projects"."issues_template" AS t0_r21, "projects"."mirror" AS t0_r22, "projects"."mirror_user_id" AS t0_r23, "projects"."shared_runners_enabled" AS t0_r24, "projects"."runners_token" AS t0_r25, "projects"."build_coverage_regex" AS t0_r26, "projects"."build_allow_git_fetch" AS t0_r27, "projects"."build_timeout" AS t0_r28, "projects"."mirror_trigger_builds" AS t0_r29, "projects"."public_builds" AS t0_r30, "projects"."pending_delete" AS t0_r31, "projects"."last_repository_check_failed" AS t0_r32, "projects"."last_repository_check_at" AS t0_r33, "projects"."container_registry_enabled" AS t0_r34, "projects"."only_allow_merge_if_pipeline_succeeds" AS t0_r35, "projects"."has_external_issue_tracker" AS t0_r36, "projects"."repository_storage" AS t0_r37, "projects"."request_access_enabled" AS t0_r38, "projects"."has_external_wiki" AS t0_r39, "projects"."repository_read_only" AS t0_r40, "projects"."lfs_enabled" AS t0_r41, "projects"."description_html" AS t0_r42, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t0_r43, "projects"."repository_size_limit" AS t0_r44, "projects"."service_desk_enabled" AS t0_r45, "projects"."printing_merge_request_link_enabled" AS t0_r46, "projects"."auto_cancel_pending_pipelines" AS t0_r47, "projects"."cached_markdown_version" AS t0_r48, "projects"."last_repository_updated_at" AS t0_r49, "projects"."ci_config_path" AS t0_r50, "projects"."disable_overriding_approvers_per_merge_request" AS t0_r51, "projects"."delete_error" AS t0_r52, "projects"."storage_version" AS t0_r53, "projects"."resolve_outdated_diff_discussions" AS t0_r54, "projects"."remote_mirror_available_overridden" AS t0_r55, "projects"."only_mirror_protected_branches" AS t0_r56, "projects"."pull_mirror_available_overridden" AS t0_r57, "projects"."jobs_cache_index" AS t0_r58, "projects"."external_authorization_classification_label" AS t0_r59, "projects"."mirror_overwrites_diverged_branches" AS t0_r60, "projects"."external_webhook_token" AS t0_r61, "projects"."pages_https_only" AS t0_r62, "projects"."packages_enabled" AS t0_r63, "projects"."merge_requests_author_approval" AS t0_r64, "projects"."pool_repository_id" AS t0_r65, "projects"."runners_token_encrypted" AS t0_r66, "projects"."bfg_object_map" AS t0_r67, "projects"."detected_repository_languages" AS t0_r68, "projects"."merge_requests_disable_committers_approval" AS t0_r69, "projects"."require_password_to_approve" AS t0_r70, "projects"."emails_disabled" AS t0_r71, "projects"."max_pages_size" AS t0_r72, "projects"."max_artifacts_size" AS t0_r73, "projects"."remove_source_branch_after_merge" AS t0_r74, "projects"."marked_for_deletion_at" AS t0_r75, "projects"."marked_for_deletion_by_user_id" AS t0_r76, "projects"."suggestion_commit_message" AS t0_r77, "projects"."autoclose_referenced_issues" AS t0_r78, "routes"."id" AS t1_r0, "routes"."source_id" AS t1_r1, "routes"."source_type" AS t1_r2, "routes"."path" AS t1_r3, "routes"."created_at" AS t1_r4, "routes"."updated_at" AS t1_r5, "routes"."name" AS t1_r6, "namespaces"."id" AS t2_r0, "namespaces"."name" AS t2_r1, "namespaces"."path" AS t2_r2, "namespaces"."owner_id" AS t2_r3, "namespaces"."created_at" AS t2_r4, "namespaces"."updated_at" AS t2_r5, "namespaces"."type" AS t2_r6, "namespaces"."description" AS t2_r7, "namespaces"."avatar" AS t2_r8, "namespaces"."membership_lock" AS t2_r9, "namespaces"."share_with_group_lock" AS t2_r10, "namespaces"."visibility_level" AS t2_r11, "namespaces"."request_access_enabled" AS t2_r12, "namespaces"."ldap_sync_status" AS t2_r13, "namespaces"."ldap_sync_error" AS t2_r14, "namespaces"."ldap_sync_last_update_at" AS t2_r15, "namespaces"."ldap_sync_last_successful_update_at" AS t2_r16, "namespaces"."ldap_sync_last_sync_at" AS t2_r17, "namespaces"."lfs_enabled" AS t2_r18, "namespaces"."description_html" AS t2_r19, "namespaces"."parent_id" AS t2_r20, "namespaces"."shared_runners_minutes_limit" AS t2_r21, "namespaces"."repository_size_limit" AS t2_r22, "namespaces"."require_two_factor_authentication" AS t2_r23, "namespaces"."two_factor_grace_period" AS t2_r24, "namespaces"."cached_markdown_version" AS t2_r25, "namespaces"."project_creation_level" AS t2_r26, "namespaces"."runners_token" AS t2_r27, "namespaces"."file_template_project_id" AS t2_r28, "namespaces"."saml_discovery_token" AS t2_r29, "namespaces"."runners_token_encrypted" AS t2_r30, "namespaces"."custom_project_templates_group_id" AS t2_r31, "namespaces"."auto_devops_enabled" AS t2_r32, "namespaces"."extra_shared_runners_minutes_limit" AS t2_r33, "namespaces"."last_ci_minutes_notification_at" AS t2_r34, "namespaces"."last_ci_minutes_usage_notification_level" AS t2_r35, "namespaces"."subgroup_creation_level" AS t2_r36, "namespaces"."emails_disabled" AS t2_r37, "namespaces"."max_pages_size" AS t2_r38, "namespaces"."max_artifacts_size" AS t2_r39, "namespaces"."mentions_disabled" AS t2_r40, "namespaces"."default_branch_protection" AS t2_r41, "namespaces"."unlock_membership_to_ldap" AS t2_r42, "namespaces"."max_personal_access_token_lifetime" AS t2_r43, "namespaces"."push_rule_id" AS t2_r44, "namespaces"."shared_runners_enabled" AS t2_r45, "namespaces"."allow_descendants_override_disabled_shared_runners" AS t2_r46, "namespaces"."traversal_ids" AS t2_r47, "routes_namespaces"."id" AS t3_r0, "routes_namespaces"."source_id" AS t3_r1, "routes_namespaces"."source_type" AS t3_r2, "routes_namespaces"."path" AS t3_r3, "routes_namespaces"."created_at" AS t3_r4, "routes_namespaces"."updated_at" AS t3_r5, "routes_namespaces"."name" AS t3_r6 FROM "projects" LEFT OUTER JOIN "routes" ON "routes"."source_type" = 'Project' AND "routes"."source_id" = "projects"."id" LEFT OUTER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" LEFT OUTER JOIN "routes" "routes_namespaces" ON "routes_namespaces"."source_type" = 'Namespace' AND "routes_namespaces"."source_id" = "namespaces"."id" WHERE ((LOWER(routes.path) = LOWER('gitlab-org/gitlab')))  
Primary
1.217ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issues".* FROM "issues" WHERE "issues"."project_id" = 278964 AND "issues"."iid" = 327630  
Primary
1.648ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 278964 AND "merge_requests"."iid" = 60566  
Primary
1.352ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'backend' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.039ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Cached
Primary
0.841ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 2492649 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
1.285ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'banzai' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.663ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 2699341 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
1.237ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'devops::plan' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.697ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 3103451 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
1.045ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'feature::maintenance' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.666ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 15119514 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
1.101ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'group::project management' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.699ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 10690691 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.926ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'missed:13.12' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.868ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 19695786 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
1.011ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'performance' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.638ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 2731248 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.943ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'priority::2' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.693ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 3857523 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
1.218ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'section::dev' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.726ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 14918378 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
1.026ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'severity::2' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.772ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 3713902 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
1.023ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'workflow::in review' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.736ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 2526326 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.894ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" = 'security' ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.692ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."id" = 2779335 ORDER BY "labels"."title" ASC LIMIT 1  
Primary
0.614ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "custom_emoji" WHERE "custom_emoji"."namespace_id" = 9970 LIMIT 1  
Primary
0.054ms	
SELECT "issues".* FROM "issues" WHERE "issues"."project_id" = 278964 AND "issues"."iid" = 327630  
Cached
Primary
1.515ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 278964 AND ("ci_pipelines"."source" IN (1, 2, 3, 4, 5, 6, 7, 8, 10, 11) OR "ci_pipelines"."source" IS NULL) AND "ci_pipelines"."sha" = 'fa007604f58dc61126e9d62e37c0e18a123db838' AND "ci_pipelines"."ref" = 'master' ORDER BY "ci_pipelines"."id" DESC LIMIT 1  
Primary
11.128ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" WHERE "ci_job_artifacts"."id" IN (SELECT max(ci_job_artifacts.id) as id FROM "ci_job_artifacts" INNER JOIN "ci_builds" ON "ci_job_artifacts"."job_id" = "ci_builds"."id" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 316354834 AND "ci_job_artifacts"."file_type" IN (4, 5, 6, 7, 8, 9, 10, 101, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) GROUP BY "ci_job_artifacts"."file_type")  
Primary
1.81ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_builds".* FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."id" = 1325136367  
Primary
0.759ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT COUNT(*) FROM (SELECT 1 AS one FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest' LIMIT 10) subquery_for_count  
Primary
0.037ms	
SELECT "protected_branches".* FROM "protected_branches" WHERE "protected_branches"."project_id" = 278964  
Cached
Primary
0.033ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Cached
Primary
0.032ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1 
Cached
Primary
0.83ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."pipeline_id" = 316356654 AND "ci_pipeline_artifacts"."file_type" = 2 LIMIT 1  
Primary
1.28ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "users" INNER JOIN "merge_request_reviewers" ON "users"."id" = "merge_request_reviewers"."user_id" WHERE "merge_request_reviewers"."merge_request_id" = 99774863 LIMIT 1  
Primary
0.046ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1 
Cached
Primary
0.756ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/group/avatar/9970/logo-extra-whitespace.png', 'group/avatar/9970/logo-extra-whitespace.png', 'uploads/-/system/group/avatar/2584649/61yepqAnAZL._UX522_.jpg', 'group/avatar/2584649/61yepqAnAZL._UX522_.jpg') ORDER BY "uploads"."id" ASC LIMIT 1000  
Primary
0.873ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/project/avatar/278964/logo-extra-whitespace.png', 'project/avatar/278964/logo-extra-whitespace.png') ORDER BY "uploads"."id" ASC LIMIT 1000  
Primary
0.947ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_statuses".* FROM "user_statuses" WHERE "user_statuses"."user_id" = 194645 LIMIT 1  
Primary
4.45ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "projects" WHERE "projects"."namespace_id" IN (SELECT traversal_ids[array_length(traversal_ids, 1)] AS id FROM "namespaces" WHERE (traversal_ids @> ('{9970}'))) AND "projects"."shared_runners_enabled" = TRUE LIMIT 1  
Primary
0.469ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "onboarding_progresses" WHERE "onboarding_progresses"."namespace_id" = 9970 LIMIT 1  
Primary
0.714ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "services".* FROM "services" WHERE "services"."type" = 'JiraService' AND "services"."project_id" = 278964 LIMIT 1  
Primary
0.641ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_settings".* FROM "project_settings" WHERE "project_settings"."project_id" = 278964 LIMIT 1  
Primary
0.682ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "gitlab_subscriptions".* FROM "gitlab_subscriptions" WHERE "gitlab_subscriptions"."namespace_id" = 9970 LIMIT 1  
Primary
0.568ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 9970 LIMIT 1  
Primary
1.917ms	
/*application:web,correlation_id:01F7PHA3ZKQKB3XJ0TJF1KJCY1,endpoint_id:Projects::MergeRequestsController#show*/ SELECT MAX("members"."access_level") AS maximum_access_level, "members"."user_id" AS members_user_id FROM ((SELECT "members".* FROM "members" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "users"."state" = 'active' AND "members"."requested_at" IS NULL AND "members"."invite_token" IS NULL AND (members.access_level > 5) AND (members.access_level > 5) AND "members"."source_id" = 9970) UNION (WITH "group_group_links_cte" AS MATERIALIZED (SELECT "group_group_links".* FROM "group_group_links" WHERE "group_group_links"."shared_group_id" = 9970) SELECT "members"."id", LEAST("group_group_links"."group_access", "members"."access_level") AS access_level, "members"."source_id", "members"."source_type", "members"."user_id", "members"."notification_level", "members"."type", "members"."created_at", "members"."updated_at", "members"."created_by_id", "members"."invite_email", "members"."invite_token", "members"."invite_accepted_at", "members"."requested_at", "members"."expires_at", "members"."ldap", "members"."override" FROM "members", "group_group_links_cte" AS "group_group_links" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."source_id" = "group_group_links"."shared_with_group_id" AND "members"."source_type" = 'Namespace' AND (members.access_level > 5))) members WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "members"."user_id" = 194645 GROUP BY "members"."user_id"  
Primary

After MR deployment (136)

0.523ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_details".* FROM "user_details" WHERE "user_details"."user_id" = 194645 LIMIT 1  
Replica
0.67ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "identities" WHERE "identities"."user_id" = 194645 AND (provider LIKE 'ldap%' AND extern_uid IS NOT NULL) LIMIT 1  
Primary
0.558ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = 194645 LIMIT 1  
Replica
0.658ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/user/avatar/194645/avatar.png', 'user/avatar/194645/avatar.png') ORDER BY "uploads"."id" ASC LIMIT 1000 
Replica
0.042ms	
SELECT "projects"."id" AS t0_r0, "projects"."name" AS t0_r1, "projects"."path" AS t0_r2, "projects"."description" AS t0_r3, "projects"."created_at" AS t0_r4, "projects"."updated_at" AS t0_r5, "projects"."creator_id" AS t0_r6, "projects"."namespace_id" AS t0_r7, "projects"."last_activity_at" AS t0_r8, "projects"."import_url" AS t0_r9, "projects"."visibility_level" AS t0_r10, "projects"."archived" AS t0_r11, "projects"."merge_requests_template" AS t0_r12, "projects"."star_count" AS t0_r13, "projects"."merge_requests_rebase_enabled" AS t0_r14, "projects"."import_type" AS t0_r15, "projects"."import_source" AS t0_r16, "projects"."avatar" AS t0_r17, "projects"."approvals_before_merge" AS t0_r18, "projects"."reset_approvals_on_push" AS t0_r19, "projects"."merge_requests_ff_only_enabled" AS t0_r20, "projects"."issues_template" AS t0_r21, "projects"."mirror" AS t0_r22, "projects"."mirror_user_id" AS t0_r23, "projects"."shared_runners_enabled" AS t0_r24, "projects"."runners_token" AS t0_r25, "projects"."build_coverage_regex" AS t0_r26, "projects"."build_allow_git_fetch" AS t0_r27, "projects"."build_timeout" AS t0_r28, "projects"."mirror_trigger_builds" AS t0_r29, "projects"."public_builds" AS t0_r30, "projects"."pending_delete" AS t0_r31, "projects"."last_repository_check_failed" AS t0_r32, "projects"."last_repository_check_at" AS t0_r33, "projects"."container_registry_enabled" AS t0_r34, "projects"."only_allow_merge_if_pipeline_succeeds" AS t0_r35, "projects"."has_external_issue_tracker" AS t0_r36, "projects"."repository_storage" AS t0_r37, "projects"."request_access_enabled" AS t0_r38, "projects"."has_external_wiki" AS t0_r39, "projects"."repository_read_only" AS t0_r40, "projects"."lfs_enabled" AS t0_r41, "projects"."description_html" AS t0_r42, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t0_r43, "projects"."repository_size_limit" AS t0_r44, "projects"."service_desk_enabled" AS t0_r45, "projects"."printing_merge_request_link_enabled" AS t0_r46, "projects"."auto_cancel_pending_pipelines" AS t0_r47, "projects"."cached_markdown_version" AS t0_r48, "projects"."last_repository_updated_at" AS t0_r49, "projects"."ci_config_path" AS t0_r50, "projects"."disable_overriding_approvers_per_merge_request" AS t0_r51, "projects"."delete_error" AS t0_r52, "projects"."storage_version" AS t0_r53, "projects"."resolve_outdated_diff_discussions" AS t0_r54, "projects"."remote_mirror_available_overridden" AS t0_r55, "projects"."only_mirror_protected_branches" AS t0_r56, "projects"."pull_mirror_available_overridden" AS t0_r57, "projects"."jobs_cache_index" AS t0_r58, "projects"."external_authorization_classification_label" AS t0_r59, "projects"."mirror_overwrites_diverged_branches" AS t0_r60, "projects"."external_webhook_token" AS t0_r61, "projects"."pages_https_only" AS t0_r62, "projects"."packages_enabled" AS t0_r63, "projects"."merge_requests_author_approval" AS t0_r64, "projects"."pool_repository_id" AS t0_r65, "projects"."runners_token_encrypted" AS t0_r66, "projects"."bfg_object_map" AS t0_r67, "projects"."detected_repository_languages" AS t0_r68, "projects"."merge_requests_disable_committers_approval" AS t0_r69, "projects"."require_password_to_approve" AS t0_r70, "projects"."emails_disabled" AS t0_r71, "projects"."max_pages_size" AS t0_r72, "projects"."max_artifacts_size" AS t0_r73, "projects"."remove_source_branch_after_merge" AS t0_r74, "projects"."marked_for_deletion_at" AS t0_r75, "projects"."marked_for_deletion_by_user_id" AS t0_r76, "projects"."suggestion_commit_message" AS t0_r77, "projects"."autoclose_referenced_issues" AS t0_r78, "routes"."id" AS t1_r0, "routes"."source_id" AS t1_r1, "routes"."source_type" AS t1_r2, "routes"."path" AS t1_r3, "routes"."created_at" AS t1_r4, "routes"."updated_at" AS t1_r5, "routes"."name" AS t1_r6 FROM "projects" LEFT OUTER JOIN "routes" ON "routes"."source_type" = 'Project' AND "routes"."source_id" = "projects"."id" WHERE "routes"."path" = 'gitlab-org/gitlab' LIMIT 1  
Cached
Replica
0.728ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Replica
0.741ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT DISTINCT "plans".* FROM "plans" INNER JOIN "gitlab_subscriptions" ON "gitlab_subscriptions"."hosted_plan_id" = "plans"."id" WHERE "plans"."name" IN ('bronze', 'silver', 'premium', 'gold', 'ultimate', 'ultimate_trial', 'premium_trial') AND "gitlab_subscriptions"."namespace_id" = 9970  
Replica
0.471ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ip_restrictions".* FROM "ip_restrictions" WHERE "ip_restrictions"."group_id" = 9970  
Replica
0.553ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964 LIMIT 1  
Replica
4.346ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 278964 AND "merge_requests"."iid" = 61648 LIMIT 1  
Replica
0.538ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_metrics".* FROM "merge_request_metrics" WHERE "merge_request_metrics"."merge_request_id" = 99774863  
Replica
0.63ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_assignees".* FROM "merge_request_assignees" WHERE "merge_request_assignees"."merge_request_id" = 99774863  
Replica
0.683ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Replica
0.491ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_statuses".* FROM "user_statuses" WHERE "user_statuses"."user_id" = 194645  
Replica
0.04ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.032ms	
SELECT "user_statuses".* FROM "user_statuses" WHERE "user_statuses"."user_id" = 194645  
Cached
Replica
0.485ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_blocks".* FROM "merge_request_blocks" WHERE "merge_request_blocks"."blocked_merge_request_id" = 99774863  
Replica
0.651ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Replica
0.421ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 9970 LIMIT 1  
Replica
0.519ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT MAX("project_authorizations"."access_level") AS maximum_access_level, "project_authorizations"."user_id" AS project_authorizations_user_id FROM "project_authorizations" WHERE "project_authorizations"."project_id" = 278964 AND "project_authorizations"."user_id" = 194645 GROUP BY "project_authorizations"."user_id"  
Replica
2.255ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM ((SELECT "members".* FROM "members" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "users"."state" = 'active' AND "members"."requested_at" IS NULL AND "members"."invite_token" IS NULL AND (members.access_level > 5) AND (members.access_level > 5) AND "members"."source_id" = 9970) UNION (WITH "group_group_links_cte" AS MATERIALIZED (SELECT "group_group_links".* FROM "group_group_links" WHERE "group_group_links"."shared_group_id" = 9970) SELECT "members"."id", LEAST("group_group_links"."group_access", "members"."access_level") AS access_level, "members"."source_id", "members"."source_type", "members"."user_id", "members"."notification_level", "members"."type", "members"."created_at", "members"."updated_at", "members"."created_by_id", "members"."invite_email", "members"."invite_token", "members"."invite_accepted_at", "members"."requested_at", "members"."expires_at", "members"."ldap", "members"."override" FROM "members", "group_group_links_cte" AS "group_group_links" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."source_id" = "group_group_links"."shared_with_group_id" AND "members"."source_type" = 'Namespace' AND (members.access_level > 5))) members LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND (("members"."user_id" IS NULL AND "members"."invite_token" IS NOT NULL) OR "users"."state" = 'active') AND "members"."requested_at" IS NULL AND (members.access_level > 5) AND "members"."access_level" = 50 AND "members"."user_id" = 194645 LIMIT 1  
Primary
1.077ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Replica
0.553ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 196830017 LIMIT 1  
Replica
0.597ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_context_commits".* FROM "merge_request_context_commits" WHERE "merge_request_context_commits"."merge_request_id" = 99774863 ORDER BY committed_date DESC  
Replica
0.573ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_diff_commits".* FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" = 196830017 ORDER BY "merge_request_diff_commits"."merge_request_diff_id" ASC, "merge_request_diff_commits"."relative_order" ASC  
Replica
0.609ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "milestones".* FROM "milestones" WHERE "milestones"."id" = 1850113 LIMIT 1  
Replica
0.037ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
0.445ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Replica
1.187ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" WHERE "label_links"."target_id" = 99774863 AND "label_links"."target_type" = 'MergeRequest' ORDER BY "labels"."title" ASC  
Replica
0.93ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "todos".* FROM "todos" WHERE "todos"."user_id" = 194645 AND "todos"."target_type" = 'MergeRequest' AND "todos"."target_id" = 99774863 AND "todos"."state" = 'pending' LIMIT 1  
Replica
0.512ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "protected_branches".* FROM "protected_branches" WHERE "protected_branches"."project_id" = 278964 
Replica
0.53ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "protected_branch_push_access_levels".* FROM "protected_branch_push_access_levels" WHERE "protected_branch_push_access_levels"."protected_branch_id" = 109607  
Replica
0.753ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 2584649 LIMIT 1  
Replica
1.121ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" = 'GroupMember' AND "members"."source_id" = 2584649 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."access_level" != 5 AND "users"."id" = 194645 LIMIT 1  
Primary
0.93ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 1786152 LIMIT 1  
Replica
1.066ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 2324599 LIMIT 1  
Replica
0.608ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "protected_branch_merge_access_levels".* FROM "protected_branch_merge_access_levels" WHERE "protected_branch_merge_access_levels"."protected_branch_id" = 109607  
Replica
0.044ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 1786152 LIMIT 1  
Cached
Replica
0.038ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 2324599 LIMIT 1  
Cached
Replica
0.036ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 2584649 LIMIT 1  
Cached
Replica
0.034ms	
SELECT 1 AS one FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" = 'GroupMember' AND "members"."source_id" = 2584649 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."access_level" != 5 AND "users"."id" = 194645 LIMIT 1  
Cached
Primary
0.034ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Cached
Replica
0.606ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."owner_id" = 194645 AND "namespaces"."type" IS NULL LIMIT 1  
Replica
0.594ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."id" = 318060052 LIMIT 1  
Replica
1.842ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."pipeline_id" = 318060052 AND "ci_pipeline_artifacts"."file_type" = 1 LIMIT 1  
Primary
0.056ms	
SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964 LIMIT 1  
Cached
Replica
4.791ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ WITH "shas" AS MATERIALIZED (SELECT DISTINCT "merge_request_diff_commits"."sha" FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" IN (SELECT "merge_request_diffs"."id" FROM "merge_request_diffs" WHERE "merge_request_diffs"."merge_request_id" = 99774863 AND "merge_request_diffs"."diff_type" = 1 ORDER BY "merge_request_diffs"."id" DESC LIMIT 100) LIMIT 10000) SELECT COUNT(*) FROM ((SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."source" = 10 AND "ci_pipelines"."merge_request_id" = 99774863 AND "ci_pipelines"."project_id" IN (278964, 278964)) UNION (SELECT "ci_pipelines".* FROM "ci_pipelines" INNER JOIN "shas" ON encode("shas"."sha", 'hex') = "ci_pipelines"."sha" WHERE "ci_pipelines"."project_id" = 278964 AND ("ci_pipelines"."source" IN (1, 2, 3, 4, 5, 6, 7, 8, 11) OR "ci_pipelines"."source" IS NULL) AND "ci_pipelines"."ref" = 'bw-reference-label-caching' AND "ci_pipelines"."tag" = FALSE)) ci_pipelines  
Replica
0.535ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_diff_commits"."sha" FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" = 196830017 ORDER BY "merge_request_diff_commits"."merge_request_diff_id" ASC, "merge_request_diff_commits"."relative_order" ASC LIMIT 100  
Replica
1.146ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT COUNT(*) FROM ((SELECT "notes".* FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest') UNION ALL (SELECT "notes".* FROM "notes" WHERE "notes"."system" = FALSE AND "notes"."project_id" IN (278964, 278964) AND "notes"."noteable_type" = 'Commit' AND "notes"."commit_id" IN ('01be9b5fa07c0b7f04dfae742f6c655db3fe2955', '58d5c4bef6a6807255671f2c82d08bc72a5ef058', 'b875724e0f6cadff1e3e823418d287a5a3c5ce29'))) notes WHERE "notes"."system" = FALSE  
Replica
0.857ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "notes"."id" FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest'  
Replica
1.283ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964  
Replica
0.627ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964  
Replica
0.711ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970  
Replica
0.774ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970  
Replica
0.854ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issues".* FROM "issues" WHERE "issues"."id" = 85130477  
Replica
0.056ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.576ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issue_assignees".* FROM "issue_assignees" WHERE "issue_assignees"."issue_id" = 85130477  
Replica
0.041ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.047ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964  
Cached
Replica
0.037ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970  
Cached
Replica
0.039ms	
SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964  
Cached
Replica
0.469ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 278964 
Replica
0.039ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
0.927ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" = 97889785  
Replica
0.048ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.579ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_request_assignees".* FROM "merge_request_assignees" WHERE "merge_request_assignees"."merge_request_id" = 97889785  
Replica
0.06ms	
SELECT "users".* FROM "users" WHERE "users"."id" = 194645  
Cached
Replica
0.06ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964  
Cached
Replica
0.057ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970  
Cached
Replica
0.562ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 9970 
Replica
0.055ms	
SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 278964  
Cached
Replica
0.103ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 278964  
Cached
Replica
0.807ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" = 194645 LIMIT 1  
Replica
2.41ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" WHERE "ci_job_artifacts"."id" IN (SELECT max(ci_job_artifacts.id) as id FROM "ci_job_artifacts" INNER JOIN "ci_builds" ON "ci_job_artifacts"."job_id" = "ci_builds"."id" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 318060052 AND "ci_job_artifacts"."file_type" IN (4, 5, 6, 7, 8, 9, 10, 101, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) GROUP BY "ci_job_artifacts"."file_type")  
Replica
1.183ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_builds".* FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."id" IN (1333232205, 1333232486, 1333232238, 1333232443, 1333232441, 1333232438, 1333232435, 1333232464)  
Replica
0.04ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.053ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.052ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
0.042ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Cached
Replica
0.042ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.049ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
1.405ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 318060052 AND ("ci_builds"."retried" = FALSE OR "ci_builds"."retried" IS NULL) AND (EXISTS (SELECT 1 FROM "ci_job_artifacts" WHERE (ci_builds.id = ci_job_artifacts.job_id) AND "ci_job_artifacts"."file_type" = 12)) LIMIT 1  
Primary
0.489ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 278964 AND "routes"."source_type" = 'Project' LIMIT 1  
Replica
0.547ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_callouts".* FROM "user_callouts" WHERE "user_callouts"."user_id" = 194645  
Replica
1.035ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issues".* FROM "issues" INNER JOIN "merge_requests_closing_issues" ON "issues"."id" = "merge_requests_closing_issues"."issue_id" WHERE "merge_requests_closing_issues"."merge_request_id" = 99774863  
Replica
0.483ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "grafana_integrations".* FROM "grafana_integrations" WHERE "grafana_integrations"."project_id" = 278964 LIMIT 1  
Replica
0.726ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "issues".* FROM "issues" WHERE "issues"."project_id" = 278964 AND "issues"."iid" = 327630  
Replica
0.854ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 278964 AND "merge_requests"."iid" = 60566  
Replica
4.138ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "labels".* FROM ((SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND 1=0) UNION (SELECT "labels".* FROM "labels" WHERE ("labels"."type" = 'GroupLabel' AND "labels"."group_id" IN (9970) OR "labels"."type" = 'ProjectLabel' AND "labels"."project_id" = 278964) AND "labels"."title" IN ('backend', 'banzai', 'devops::plan', 'feature::maintenance', 'group::project management', 'missed:13.12', 'performance', 'priority::2', 'section::dev', 'severity::2', 'workflow::in review', 'security'))) labels ORDER BY "labels"."title" ASC  
Replica
0.679ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "custom_emoji" WHERE "custom_emoji"."namespace_id" = 9970 LIMIT 1  
Primary
0.05ms	
SELECT "issues".* FROM "issues" WHERE "issues"."project_id" = 278964 AND "issues"."iid" = 327630  
Cached
Replica
1.402ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_pipelines".* FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 278964 AND ("ci_pipelines"."source" IN (1, 2, 3, 4, 5, 6, 7, 8, 10, 11) OR "ci_pipelines"."source" IS NULL) AND "ci_pipelines"."sha" = '987ce34cacd6bff060855d4507043681e3a4ffe7' AND "ci_pipelines"."ref" = 'master' ORDER BY "ci_pipelines"."id" DESC LIMIT 1  
Replica
2.361ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" WHERE "ci_job_artifacts"."id" IN (SELECT max(ci_job_artifacts.id) as id FROM "ci_job_artifacts" INNER JOIN "ci_builds" ON "ci_job_artifacts"."job_id" = "ci_builds"."id" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."commit_id" = 318056970 AND "ci_job_artifacts"."file_type" IN (4, 5, 6, 7, 8, 9, 10, 101, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) GROUP BY "ci_job_artifacts"."file_type")  
Replica
1.36ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "ci_builds".* FROM "ci_builds" WHERE "ci_builds"."type" = 'Ci::Build' AND "ci_builds"."id" IN (1333217772, 1333217711, 1333217781, 1333217757, 1333217612, 1333217777, 1333217766)  
Replica
0.04ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.035ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.056ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
0.032ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Cached
Replica
0.67ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT COUNT(*) FROM (SELECT 1 AS one FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest' LIMIT 10) subquery_for_count  
Replica
1.012ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "ci_pipeline_artifacts" WHERE "ci_pipeline_artifacts"."pipeline_id" = 318060052 AND "ci_pipeline_artifacts"."file_type" = 2 LIMIT 1  
Primary
1.292ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "users" INNER JOIN "merge_request_reviewers" ON "users"."id" = "merge_request_reviewers"."user_id" WHERE "merge_request_reviewers"."merge_request_id" = 99774863 LIMIT 1  
Primary
1.578ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" INNER JOIN "merge_request_reviewers" ON "users"."id" = "merge_request_reviewers"."user_id" WHERE "merge_request_reviewers"."merge_request_id" = 99774863  
Replica
0.62ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT MAX("project_authorizations"."access_level") AS maximum_access_level, "project_authorizations"."user_id" AS project_authorizations_user_id FROM "project_authorizations" WHERE "project_authorizations"."project_id" = 278964 AND "project_authorizations"."user_id" = 4059254 GROUP BY "project_authorizations"."user_id"  
Replica
1.378ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" = 'GroupMember' AND "members"."source_id" = 2584649 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."access_level" != 5 AND "users"."id" = 4059254 LIMIT 1  
Primary
0.034ms	
SELECT 1 AS one FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" = 'GroupMember' AND "members"."source_id" = 2584649 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."access_level" != 5 AND "users"."id" = 4059254 LIMIT 1  
Cached
Primary
0.04ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Cached
Replica
0.971ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "notes".* FROM "notes" WHERE "notes"."noteable_id" = 99774863 AND "notes"."noteable_type" = 'MergeRequest' AND (created_at >= '2021-06-09 23:05:02.262870') AND "notes"."system" = TRUE  
Replica
0.872ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "users".* FROM "users" WHERE "users"."id" IN (2324599, 194645, 4059254)  
Replica
0.605ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "award_emoji".* FROM "award_emoji" WHERE "award_emoji"."awardable_type" = 'Note' AND "award_emoji"."awardable_id" IN (597506734, 598215615, 597396618) ORDER BY "award_emoji"."id" ASC  
Replica
0.032ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 278964 AND "routes"."source_type" = 'Project' LIMIT 1 
Cached
Replica
0.032ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
3.701ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 278964 AND "merge_requests"."merge_commit_sha" = 'a003e5804add426d2f578a596c9be271fa24eb59' LIMIT 1  
Replica
0.045ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
150.339ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."source_project_id" = 278964 AND ("merge_requests"."state_id" IN (1)) AND "merge_requests"."allow_maintainer_to_push" = TRUE  
Replica
0.054ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.043ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.042ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.034ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.034ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.034ms	
SELECT "projects".* FROM "projects" WHERE "projects"."id" = 278964 LIMIT 1  
Cached
Replica
0.033ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 278964 AND "routes"."source_type" = 'Project' LIMIT 1 
Cached
Replica
0.04ms	
SELECT "protected_branches".* FROM "protected_branches" WHERE "protected_branches"."project_id" = 278964  
Cached
Replica
1.526ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "projects".* FROM "projects" INNER JOIN "fork_network_members" ON "projects"."id" = "fork_network_members"."forked_from_project_id" WHERE "fork_network_members"."project_id" = 278964 LIMIT 1  
Replica
0.034ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 278964 AND "routes"."source_type" = 'Project' LIMIT 1 
Cached
Replica
0.034ms	
SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 9970 LIMIT 1  
Cached
Replica
0.037ms	
SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 9970 AND "routes"."source_type" = 'Namespace' LIMIT 1  
Cached
Replica
0.788ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/group/avatar/9970/logo-extra-whitespace.png', 'group/avatar/9970/logo-extra-whitespace.png', 'uploads/-/system/group/avatar/2584649/61yepqAnAZL._UX522_.jpg', 'group/avatar/2584649/61yepqAnAZL._UX522_.jpg') ORDER BY "uploads"."id" ASC LIMIT 1000  
Replica
0.519ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "uploads".* FROM "uploads" WHERE "uploads"."uploader" = 'AvatarUploader' AND "uploads"."path" IN ('uploads/-/system/project/avatar/278964/logo-extra-whitespace.png', 'project/avatar/278964/logo-extra-whitespace.png') ORDER BY "uploads"."id" ASC LIMIT 1000  
Replica
0.531ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "user_statuses".* FROM "user_statuses" WHERE "user_statuses"."user_id" = 194645 LIMIT 1  
Replica
4.832ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "projects" WHERE "projects"."namespace_id" IN (SELECT traversal_ids[array_length(traversal_ids, 1)] AS id FROM "namespaces" WHERE (traversal_ids @> ('{9970}'))) AND "projects"."shared_runners_enabled" = TRUE LIMIT 1  
Primary
0.464ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT 1 AS one FROM "onboarding_progresses" WHERE "onboarding_progresses"."namespace_id" = 9970 LIMIT 1 
Primary
0.76ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "services".* FROM "services" WHERE "services"."type" = 'JiraService' AND "services"."project_id" = 278964 LIMIT 1  
Replica
0.541ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "project_settings".* FROM "project_settings" WHERE "project_settings"."project_id" = 278964 LIMIT 1  
Replica
0.582ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT "gitlab_subscriptions".* FROM "gitlab_subscriptions" WHERE "gitlab_subscriptions"."namespace_id" = 9970 LIMIT 1  
Replica
0.039ms	
SELECT "saml_providers".* FROM "saml_providers" WHERE "saml_providers"."group_id" = 9970 LIMIT 1  
Cached
Replica
1.808ms	
/*application:web,correlation_id:01F7V8D233SPNMPFNS4YP2S50R,endpoint_id:Projects::MergeRequestsController#show*/ SELECT MAX("members"."access_level") AS maximum_access_level, "members"."user_id" AS members_user_id FROM ((SELECT "members".* FROM "members" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "users"."state" = 'active' AND "members"."requested_at" IS NULL AND "members"."invite_token" IS NULL AND (members.access_level > 5) AND (members.access_level > 5) AND "members"."source_id" = 9970) UNION (WITH "group_group_links_cte" AS MATERIALIZED (SELECT "group_group_links".* FROM "group_group_links" WHERE "group_group_links"."shared_group_id" = 9970) SELECT "members"."id", LEAST("group_group_links"."group_access", "members"."access_level") AS access_level, "members"."source_id", "members"."source_type", "members"."user_id", "members"."notification_level", "members"."type", "members"."created_at", "members"."updated_at", "members"."created_by_id", "members"."invite_email", "members"."invite_token", "members"."invite_accepted_at", "members"."requested_at", "members"."expires_at", "members"."ldap", "members"."override" FROM "members", "group_group_links_cte" AS "group_group_links" WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."source_id" = "group_group_links"."shared_with_group_id" AND "members"."source_type" = 'Namespace' AND (members.access_level > 5))) members WHERE "members"."type" = 'GroupMember' AND "members"."source_type" = 'Namespace' AND "members"."user_id" = 194645 GROUP BY "members"."user_id"  
Replica

There is definitely a decrease in queries, previously lables required 23 queries, now we need only 1 (in this MR example). However it's difficult to compare directly the performance bar query count, as many changes were introduced between the first count and the final production deployment of this MR.

Conformity

• I have included a changelog entry, or it's not needed. (Does this MR need a changelog?)
• I have added/updated documentation, or it's not needed. (Is documentation required?)
• I have properly separated EE content from FOSS, or this MR is FOSS only. (Where should EE code go?)
• I have added information for database reviewers in the MR description, or it's not needed. (Does this MR have database related changes?)
• I have self-reviewed this MR per code review guidelines.
• This MR does not harm performance, or I have asked a reviewer to help assess the performance impact. (Merge request performance guidelines)
• I have followed the style guides.

Availability and Testing

• I have added/updated tests following the Testing Guide, or it's not needed. (Consider all test levels. See the Test Planning Process.)
• I have tested this MR in all supported browsers, or it's not needed.
• I have informed the Infrastructure department of a default or new setting change per definition of done, or it's not needed.

Security

Does this MR contain changes to processing or storing of credentials or tokens, authorization and authentication methods or other items described in the security review guidelines? If not, then delete this Security section.

• Label as security and @ mention @gitlab-com/gl-security/appsec
• The MR includes necessary changes to maintain consistency between UI, API, email, or other methods
• Security reports checked/validated by a reviewer from the AppSec team