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
~"feature::maintenance" groupproject management missed:13.12 ~performance
priority2 sectiondev severity2 workflowin review
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