/admin/projects page hits database statement timeout
https://sentry.gitlap.com/gitlab/gitlabcom/issues/154546/
PG::QueryCanceled: ********
app/views/admin/projects/_projects.html.haml:4:in `_app_views_admin_projects__projects_html_haml__4322483333894598588_70118666570640'
- @projects.each_with_index do |project|
app/views/admin/projects/index.html.haml:44:in `_app_views_admin_projects_index_html_haml___1294238048535578675_70118668290960'
= render 'projects'
app/controllers/admin/projects_controller.rb:12:in `index'
respond_to do |format|
lib/gitlab/i18n.rb:50:in `with_locale'
yield
lib/gitlab/i18n.rb:56:in `with_user_locale'
with_locale(user&.preferred_language, &block)
...
(187 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: ********
ActionView::Template::Error: ********
ActionView::Template::Error: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: 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"."import_status" AS t0_r12, "projects"."merge_requests_template" AS t0_r13, "projects"."star_count" AS t0_r14, "projects"."merge_requests_rebase_enabled" AS t0_r15, "projects"."import_type" AS t0_r16, "projects"."import_source" AS t0_r17, "projects"."avatar" AS t0_r18, "projects"."approvals_before_merge" AS t0_r19, "projects"."reset_approvals_on_push" AS t0_r20, "projects"."merge_requests_ff_only_enabled" AS t0_r21, "projects"."issues_template" AS t0_r22, "projects"."mirror" AS t0_r23, "projects"."mirror_last_update_at" AS t0_r24, "projects"."mirror_last_successful_update_at" AS t0_r25, "projects"."mirror_user_id" AS t0_r26, "projects"."import_error" AS t0_r27, "projects"."ci_id" AS t0_r28, "projects"."shared_runners_enabled" AS t0_r29, "projects"."runners_token" AS t0_r30, "projects"."build_coverage_regex" AS t0_r31, "projects"."build_allow_git_fetch" AS t0_r32, "projects"."build_timeout" AS t0_r33, "projects"."mirror_trigger_builds" AS t0_r34, "projects"."public_builds" AS t0_r35, "projects"."pending_delete" AS t0_r36, "projects"."last_repository_check_failed" AS t0_r37, "projects"."last_repository_check_at" AS t0_r38, "projects"."container_registry_enabled" AS t0_r39, "projects"."only_allow_merge_if_pipeline_succeeds" AS t0_r40, "projects"."has_external_issue_tracker" AS t0_r41, "projects"."repository_storage" AS t0_r42, "projects"."request_access_enabled" AS t0_r43, "projects"."has_external_wiki" AS t0_r44, "projects"."repository_read_only" AS t0_r45, "projects"."lfs_enabled" AS t0_r46, "projects"."description_html" AS t0_r47, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t0_r48, "projects"."repository_size_limit" AS t0_r49, "projects"."service_desk_enabled" AS t0_r50, "projects"."printing_merge_request_link_enabled" AS t0_r51, "projects"."auto_cancel_pending_pipelines" AS t0_r52, "projects"."import_jid" AS t0_r53, "projects"."cached_markdown_version" AS t0_r54, "projects"."last_repository_updated_at" AS t0_r55, "projects"."ci_config_path" AS t0_r56, "projects"."disable_overriding_approvers_per_merge_request" AS t0_r57, "projects"."delete_error" AS t0_r58, "projects"."storage_version" AS t0_r59, "projects"."resolve_outdated_diff_discussions" AS t0_r60, "projects"."remote_mirror_available_overridden" AS t0_r61, "projects"."only_mirror_protected_branches" AS t0_r62, "projects"."pull_mirror_available_overridden" AS t0_r63, "projects"."jobs_cache_index" AS t0_r64, "projects"."external_authorization_classification_label" AS t0_r65, "projects"."mirror_overwrites_diverged_branches" AS t0_r66, "projects"."external_webhook_token" AS t0_r67, "project_statistics"."id" AS t1_r0, "project_statistics"."project_id" AS t1_r1, "project_statistics"."namespace_id" AS t1_r2, "project_statistics"."commit_count" AS t1_r3, "project_statistics"."storage_size" AS t1_r4, "project_statistics"."repository_size" AS t1_r5, "project_statistics"."lfs_objects_size" AS t1_r6, "project_statistics"."build_artifacts_size" AS t1_r7, "project_statistics"."shared_runners_seconds" AS t1_r8, "project_statistics"."shared_runners_seconds_last_reset" AS t1_r9, "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"."plan_id" AS t2_r26, "namespaces"."project_creation_level" AS t2_r27 FROM "projects" LEFT OUTER JOIN "project_statistics" ON "project_statistics"."project_id" = "projects"."id" LEFT OUTER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" WHERE "projects"."pending_delete" = 'f' AND "projects"."archived" = 'f' ORDER BY "projects"."last_activity_at" DESC, namespaces.path, projects.name ASC LIMIT 20 OFFSET 0