Run vacuumdb with 2 commands simultaneously
What does this MR do?
Run vacuumdb
with 2
commands simultaneously via -j
option
In testing this fixed my timeout issues. Performance should not be a concern because PostgreSQL upgrade needs to be done offline anyways.
Based on --echo
output it appears to run ANALYZE
command in much more achievable within timeout chunks.
sudo su - gitlab-psql -c "/opt/gitlab/embedded/postgresql/11/bin/vacuumdb --echo --all --analyze-in-stages -h /var/opt/gitlab/postgresql"
$ sudo su - gitlab-psql -c "/opt/gitlab/embedded/postgresql/11/bin/vacuumdb --echo --all --analyze-in-stages -h /var/opt/gitlab/postgresql" SELECT pg_catalog.set_config('search_path', '', false) SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "gitlabhq_production": Generating minimal optimizer statistics (1 target) SET default_statistics_target=1; SET vacuum_cost_delay=0; ANALYZE; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "postgres": Generating minimal optimizer statistics (1 target) SET default_statistics_target=1; SET vacuum_cost_delay=0; ANALYZE; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "template1": Generating minimal optimizer statistics (1 target) SET default_statistics_target=1; SET vacuum_cost_delay=0; ANALYZE; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "gitlabhq_production": Generating medium optimizer statistics (10 targets) SET default_statistics_target=10; RESET vacuum_cost_delay; ANALYZE; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "postgres": Generating medium optimizer statistics (10 targets) SET default_statistics_target=10; RESET vacuum_cost_delay; ANALYZE; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "template1": Generating medium optimizer statistics (10 targets) SET default_statistics_target=10; RESET vacuum_cost_delay; ANALYZE; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "gitlabhq_production": Generating default (full) optimizer statistics RESET default_statistics_target; ANALYZE; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "postgres": Generating default (full) optimizer statistics RESET default_statistics_target; ANALYZE; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "template1": Generating default (full) optimizer statistics RESET default_statistics_target; ANALYZE;
sudo su - gitlab-psql -c "/opt/gitlab/embedded/postgresql/11/bin/vacuumdb -j2 --echo --all --analyze-in-stages -h /var/opt/gitlab/postgresql"
$ sudo su - gitlab-psql -c "/opt/gitlab/embedded/postgresql/11/bin/vacuumdb -j2 --echo --all --analyze-in-stages -h /var/opt/gitlab/postgresql" SELECT pg_catalog.set_config('search_path', '', false) SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "gitlabhq_production": Generating minimal optimizer statistics (1 target) SELECT c.relname, ns.nspname FROM pg_class c, pg_namespace ns WHERE relkind IN ('r', 'm') AND c.relnamespace = ns.oid ORDER BY c.relpages DESC; SELECT pg_catalog.set_config('search_path', '', false) SET default_statistics_target=1; SET vacuum_cost_delay=0; SET default_statistics_target=1; SET vacuum_cost_delay=0; ANALYZE pg_catalog.pg_attribute; ANALYZE public.audit_events; ANALYZE pg_catalog.pg_depend; ANALYZE pg_catalog.pg_statistic; ANALYZE pg_catalog.pg_proc; ANALYZE pg_catalog.pg_class; ANALYZE public.ci_builds; ANALYZE pg_catalog.pg_index; ANALYZE pg_catalog.pg_trigger; ANALYZE public.sent_notifications; ANALYZE pg_catalog.pg_type; ANALYZE pg_catalog.pg_description; ANALYZE pg_catalog.pg_attrdef; ANALYZE pg_catalog.pg_collation; ANALYZE public.web_hook_logs; ANALYZE pg_catalog.pg_constraint; ANALYZE public.oauth_access_grants; ANALYZE pg_catalog.pg_operator; ANALYZE public.ci_build_trace_sections; ANALYZE pg_catalog.pg_rewrite; ANALYZE public.schema_migrations; ANALYZE public.ci_runners; ANALYZE public.ci_pipelines; ANALYZE public.ci_stages; ANALYZE public.users; ANALYZE public.merge_request_diff_commits; ANALYZE public.ci_job_artifacts; ANALYZE public.appearances; ANALYZE public.user_agent_details; ANALYZE pg_catalog.pg_amop; ANALYZE information_schema.sql_features; ANALYZE public.notification_settings; ANALYZE public.system_note_metadata; ANALYZE public.notes; ANALYZE public.namespaces; ANALYZE public.events; ANALYZE public.projects; ANALYZE public.push_event_payloads; ANALYZE pg_catalog.pg_shdepend; ANALYZE public.routes; ANALYZE pg_catalog.pg_amproc; ANALYZE pg_catalog.pg_sequence; ANALYZE public.keys; ANALYZE public.members; ANALYZE public.application_settings; ANALYZE pg_catalog.pg_opclass; ANALYZE public.protected_branches; ANALYZE public.merge_request_diff_files; ANALYZE public.protected_branch_merge_access_levels; ANALYZE public.project_statistics; ANALYZE pg_catalog.pg_conversion; ANALYZE public.protected_branch_push_access_levels; ANALYZE public.identities; ANALYZE pg_catalog.pg_init_privs; ANALYZE pg_catalog.pg_cast; ANALYZE pg_catalog.pg_ts_config_map; ANALYZE public.oauth_access_tokens; ANALYZE public.merge_requests; ANALYZE public.user_highest_roles; ANALYZE public.broadcast_messages; ANALYZE public.issues; ANALYZE pg_catalog.pg_opfamily; ANALYZE pg_catalog.pg_aggregate; ANALYZE public.project_authorizations; ANALYZE public.services; ANALYZE public.merge_request_diffs; ANALYZE public.application_setting_terms; ANALYZE public.project_ci_cd_settings; ANALYZE public.personal_access_tokens; ANALYZE public.project_features; ANALYZE public.prometheus_metrics; ANALYZE public.resource_label_events; ANALYZE pg_catalog.pg_ts_config; ANALYZE pg_catalog.pg_shdescription; ANALYZE pg_catalog.pg_auth_members; ANALYZE public.ar_internal_metadata; ANALYZE public.ci_runner_projects; ANALYZE public.internal_ids; ANALYZE pg_catalog.pg_pltemplate; ANALYZE pg_catalog.pg_tablespace; ANALYZE pg_catalog.pg_database; ANALYZE public.ci_variables; ANALYZE public.ci_triggers; ANALYZE public.cluster_projects; ANALYZE public.shards; ANALYZE pg_catalog.pg_language; ANALYZE public.issue_assignees; ANALYZE public.issue_metrics; ANALYZE public.cluster_platforms_kubernetes; ANALYZE public.alerts_service_data; ANALYZE public.tags; ANALYZE public.trending_projects; ANALYZE public.timelogs; ANALYZE public.oauth_applications; ANALYZE public.taggings; ANALYZE public.term_agreements; ANALYZE public.deployments; ANALYZE public.clusters; ANALYZE public.todos; ANALYZE public.user_callouts; ANALYZE public.uploads; ANALYZE public.deployment_merge_requests; ANALYZE public.user_preferences; ANALYZE public.user_statuses; ANALYZE public.clusters_kubernetes_namespaces; ANALYZE public.user_details; ANALYZE public.user_interacted_projects; ANALYZE public.label_links; ANALYZE public.deploy_keys_projects; ANALYZE information_schema.sql_implementation_info; ANALYZE public.lfs_objects; ANALYZE public.namespace_root_storage_statistics; ANALYZE public.lfs_objects_projects; ANALYZE public.feature_gates; ANALYZE public.namespace_aggregation_schedules; ANALYZE public.labels; ANALYZE public.merge_request_assignees; ANALYZE public.container_expiration_policies; ANALYZE public.lists; ANALYZE pg_catalog.pg_namespace; ANALYZE information_schema.sql_languages; ANALYZE public.milestones; ANALYZE public.environments; ANALYZE public.ci_build_trace_section_names; ANALYZE public.container_repositories; ANALYZE pg_catalog.pg_ts_template; ANALYZE public.boards; ANALYZE public.project_auto_devops; ANALYZE public.features; ANALYZE pg_catalog.pg_extension; ANALYZE pg_catalog.pg_ts_parser; ANALYZE public.project_daily_statistics; ANALYZE public.fork_network_members; ANALYZE public.project_group_links; ANALYZE public.plan_limits; ANALYZE public.programming_languages; ANALYZE public.fork_networks; ANALYZE pg_catalog.pg_authid; ANALYZE public.plans; ANALYZE public.project_mirror_data; ANALYZE pg_catalog.pg_ts_dict; ANALYZE public.project_pages_metadata; ANALYZE public.ci_builds_metadata; ANALYZE public.project_settings; ANALYZE public.project_repositories; ANALYZE public.web_hooks; ANALYZE public.emails; ANALYZE public.repository_languages; ANALYZE public.redirect_routes; ANALYZE pg_catalog.pg_range; ANALYZE pg_catalog.pg_am; ANALYZE information_schema.sql_packages; ANALYZE public.merge_request_metrics; ANALYZE public.ci_pipelines_config; ANALYZE information_schema.sql_parts; ANALYZE public.ci_trigger_requests; ANALYZE information_schema.sql_sizing; ANALYZE public.open_project_tracker_data; ANALYZE public.operations_feature_flag_scopes; ANALYZE public.namespace_statistics; ANALYZE public.note_diff_files; ANALYZE public.oauth_openid_requests; ANALYZE public.operations_feature_flags_clients; ANALYZE public.operations_strategies; ANALYZE public.packages_conan_metadata; ANALYZE public.packages_build_infos; ANALYZE public.packages_dependencies; ANALYZE public.operations_user_lists; ANALYZE public.operations_feature_flags; ANALYZE public.operations_scopes; ANALYZE public.packages_conan_file_metadata; ANALYZE public.packages_maven_metadata; ANALYZE public.packages_dependency_links; ANALYZE public.pages_domains; ANALYZE public.packages_pypi_metadata; ANALYZE public.packages_tags; ANALYZE public.pool_repositories; ANALYZE public.pages_domain_acme_orders; ANALYZE public.packages_packages; ANALYZE public.path_locks; ANALYZE public.packages_package_files; ANALYZE public.project_incident_management_settings; ANALYZE public.project_feature_usages; ANALYZE public.project_alerting_settings; ANALYZE public.project_compliance_framework_settings; ANALYZE public.project_custom_attributes; ANALYZE public.project_error_tracking_settings; ANALYZE public.project_export_jobs; ANALYZE public.project_import_data; ANALYZE public.project_deploy_tokens; ANALYZE public.project_aliases; ANALYZE public.project_tracing_settings; ANALYZE public.protected_branch_unprotect_access_levels; ANALYZE public.prometheus_alerts; ANALYZE public.project_metrics_settings; ANALYZE public.project_repository_states; ANALYZE public.prometheus_alert_events; ANALYZE public.protected_tags; ANALYZE public.release_links; ANALYZE public.remote_mirrors; ANALYZE public.releases; ANALYZE public.protected_tag_create_access_levels; ANALYZE public.protected_environments; ANALYZE public.protected_environment_deploy_access_levels; ANALYZE public.push_rules; ANALYZE public.self_managed_prometheus_alert_events; ANALYZE public.resource_weight_events; ANALYZE public.scim_oauth_access_tokens; ANALYZE public.resource_milestone_events; ANALYZE public.saml_providers; ANALYZE public.requirements; ANALYZE public.security_scans; ANALYZE public.scim_identities; ANALYZE public.reviews; ANALYZE public.slack_integrations; ANALYZE public.serverless_domain_cluster; ANALYZE public.sentry_issues; ANALYZE public.snippet_user_mentions; ANALYZE public.snippets; ANALYZE public.software_licenses; ANALYZE public.smartcard_identities; ANALYZE public.service_desk_settings; ANALYZE public.snippet_repositories; ANALYZE public.software_license_policies; ANALYZE public.spam_logs; ANALYZE public.terraform_states; ANALYZE public.status_page_settings; ANALYZE public.subscriptions; ANALYZE public.suggestions; ANALYZE public.u2f_registrations; ANALYZE public.user_synced_attributes_metadata; ANALYZE public.user_canonical_emails; ANALYZE public.users_ops_dashboard_projects; ANALYZE public.user_custom_attributes; ANALYZE public.vulnerability_user_mentions; ANALYZE public.vulnerability_feedback; ANALYZE public.users_statistics; ANALYZE public.users_star_projects; ANALYZE public.users_security_dashboard_projects; ANALYZE public.vulnerability_occurrences; ANALYZE public.vulnerability_occurrence_identifiers; ANALYZE public.vulnerability_issue_links; ANALYZE public.vulnerability_exports; ANALYZE public.vulnerability_scanners; ANALYZE public.vulnerability_occurrence_pipelines; ANALYZE public.vulnerability_identifiers; ANALYZE public.vulnerabilities; ANALYZE public.zoom_meetings; ANALYZE public.x509_certificates; ANALYZE public.wiki_page_meta; ANALYZE public.x509_commit_signatures; ANALYZE public.x509_issuers; ANALYZE public.wiki_page_slugs; ANALYZE pg_catalog.pg_foreign_table; ANALYZE pg_catalog.pg_user_mapping; ANALYZE pg_catalog.pg_subscription; ANALYZE pg_catalog.pg_publication; ANALYZE pg_catalog.pg_publication_rel; ANALYZE pg_catalog.pg_subscription_rel; ANALYZE pg_catalog.pg_largeobject_metadata; ANALYZE pg_catalog.pg_inherits; ANALYZE pg_catalog.pg_statistic_ext; ANALYZE pg_catalog.pg_event_trigger; ANALYZE pg_catalog.pg_enum; ANALYZE pg_catalog.pg_db_role_setting; ANALYZE pg_catalog.pg_foreign_data_wrapper; ANALYZE pg_catalog.pg_foreign_server; ANALYZE pg_catalog.pg_policy; ANALYZE pg_catalog.pg_replication_origin; ANALYZE pg_catalog.pg_default_acl; ANALYZE pg_catalog.pg_seclabel; ANALYZE pg_catalog.pg_shseclabel; ANALYZE pg_catalog.pg_partitioned_table; ANALYZE pg_catalog.pg_transform; ANALYZE information_schema.sql_sizing_profiles; ANALYZE pg_catalog.pg_largeobject; ANALYZE public.abuse_reports; ANALYZE public.analytics_cycle_analytics_group_stages; ANALYZE public.approval_merge_request_rule_sources; ANALYZE public.allowed_email_domains; ANALYZE public.approval_merge_request_rules; ANALYZE public.analytics_language_trend_repository_languages; ANALYZE public.analytics_cycle_analytics_project_stages; ANALYZE public.approval_merge_request_rules_users; ANALYZE public.approval_project_rules_groups; ANALYZE public.approver_groups; ANALYZE public.approval_project_rules_users; ANALYZE public.approval_project_rules_protected_branches; ANALYZE public.aws_roles; ANALYZE public.approval_merge_request_rules_approved_approvers; ANALYZE public.approval_merge_request_rules_groups; ANALYZE public.approvers; ANALYZE public.award_emoji; ANALYZE public.approval_project_rules; ANALYZE public.approvals; ANALYZE public.board_group_recent_visits; ANALYZE public.board_labels; ANALYZE public.board_project_recent_visits; ANALYZE public.chat_teams; ANALYZE public.ci_build_needs; ANALYZE public.board_assignees; ANALYZE public.badges; ANALYZE public.ci_build_trace_chunks; ANALYZE public.chat_names; ANALYZE public.ci_pipeline_schedules; ANALYZE public.ci_job_variables; ANALYZE public.ci_daily_report_results; ANALYZE public.ci_pipeline_variables; ANALYZE public.ci_builds_runner_session; ANALYZE public.ci_pipeline_schedule_variables; ANALYZE public.ci_pipeline_chat_data; ANALYZE public.ci_group_variables; ANALYZE public.ci_sources_pipelines; ANALYZE public.ci_subscriptions_projects; ANALYZE public.ci_runner_namespaces; ANALYZE public.ci_resource_groups; ANALYZE public.ci_refs; ANALYZE public.ci_sources_projects; ANALYZE public.ci_resources; ANALYZE public.clusters_applications_elastic_stacks; ANALYZE public.cluster_groups; ANALYZE public.clusters_applications_fluentd; ANALYZE public.clusters_applications_crossplane; ANALYZE public.clusters_applications_cert_managers; ANALYZE public.cluster_providers_aws; ANALYZE public.cluster_providers_gcp; ANALYZE public.clusters_applications_prometheus; ANALYZE public.commit_user_mentions; ANALYZE public.clusters_applications_helm; ANALYZE public.clusters_applications_ingress; ANALYZE public.clusters_applications_knative; ANALYZE public.clusters_applications_jupyter; ANALYZE public.conversational_development_index_metrics; ANALYZE public.clusters_applications_runners; ANALYZE public.description_versions; ANALYZE public.dependency_proxy_group_settings; ANALYZE public.diff_note_positions; ANALYZE public.design_user_mentions; ANALYZE public.design_management_versions; ANALYZE public.deploy_tokens; ANALYZE public.dependency_proxy_blobs; ANALYZE public.deployment_clusters; ANALYZE public.design_management_designs; ANALYZE public.design_management_designs_versions; ANALYZE public.epic_issues; ANALYZE public.epic_metrics; ANALYZE public.elasticsearch_indexed_namespaces; ANALYZE public.epic_user_mentions; ANALYZE public.evidences; ANALYZE public.draft_notes; ANALYZE public.elasticsearch_indexed_projects; ANALYZE public.external_pull_requests; ANALYZE public.epics; ANALYZE public.geo_container_repository_updated_events; ANALYZE public.geo_lfs_object_deleted_events; ANALYZE public.geo_events; ANALYZE public.geo_hashed_storage_migrated_events; ANALYZE public.geo_node_statuses; ANALYZE public.geo_cache_invalidation_events; ANALYZE public.geo_node_namespace_links; ANALYZE public.geo_hashed_storage_attachments_events; ANALYZE public.geo_job_artifact_deleted_events; ANALYZE public.geo_event_log; ANALYZE public.gpg_key_subkeys; ANALYZE public.geo_repository_updated_events; ANALYZE public.geo_nodes; ANALYZE public.gitlab_subscriptions; ANALYZE public.geo_repository_created_events; ANALYZE public.geo_reset_checksum_events; ANALYZE public.geo_repository_renamed_events; ANALYZE public.gitlab_subscription_histories; ANALYZE public.geo_repository_deleted_events; ANALYZE public.geo_upload_deleted_events; ANALYZE public.gpg_keys; ANALYZE public.geo_repositories_changed_events; ANALYZE public.grafana_integrations; ANALYZE public.insights; ANALYZE public.group_custom_attributes; ANALYZE public.index_statuses; ANALYZE public.group_group_links; ANALYZE public.historical_data; ANALYZE public.gpg_signatures; ANALYZE public.import_export_uploads; ANALYZE public.group_deploy_tokens; ANALYZE public.import_failures; ANALYZE public.group_deletion_schedules; ANALYZE public.issue_user_mentions; ANALYZE public.jira_connect_subscriptions; ANALYZE public.jira_connect_installations; ANALYZE public.jira_imports; ANALYZE public.issues_self_managed_prometheus_alert_events; ANALYZE public.issue_tracker_data; ANALYZE public.jira_tracker_data; ANALYZE public.ip_restrictions; ANALYZE public.issue_links; ANALYZE public.issues_prometheus_alert_events; ANALYZE public.lfs_file_locks; ANALYZE public.ldap_group_links; ANALYZE public.licenses; ANALYZE public.merge_request_blocks; ANALYZE public.merge_request_context_commit_diff_files; ANALYZE public.list_user_preferences; ANALYZE public.label_priorities; ANALYZE public.merge_request_context_commits; ANALYZE public.metrics_dashboard_annotations; ANALYZE public.milestone_releases; ANALYZE public.merge_trains; ANALYZE public.merge_requests_closing_issues; ANALYZE public.merge_request_user_mentions; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "postgres": Generating minimal optimizer statistics (1 target) SELECT c.relname, ns.nspname FROM pg_class c, pg_namespace ns WHERE relkind IN ('r', 'm') AND c.relnamespace = ns.oid ORDER BY c.relpages DESC; SELECT pg_catalog.set_config('search_path', '', false) SET default_statistics_target=1; SET vacuum_cost_delay=0; SET default_statistics_target=1; SET vacuum_cost_delay=0; ANALYZE pg_catalog.pg_proc; ANALYZE pg_catalog.pg_depend; ANALYZE pg_catalog.pg_attribute; ANALYZE pg_catalog.pg_description; ANALYZE pg_catalog.pg_statistic; ANALYZE pg_catalog.pg_collation; ANALYZE pg_catalog.pg_operator; ANALYZE pg_catalog.pg_class; ANALYZE pg_catalog.pg_rewrite; ANALYZE pg_catalog.pg_type; ANALYZE pg_catalog.pg_amop; ANALYZE information_schema.sql_features; ANALYZE pg_catalog.pg_shdepend; ANALYZE pg_catalog.pg_amproc; ANALYZE pg_catalog.pg_opclass; ANALYZE pg_catalog.pg_index; ANALYZE pg_catalog.pg_conversion; ANALYZE pg_catalog.pg_aggregate; ANALYZE pg_catalog.pg_cast; ANALYZE pg_catalog.pg_ts_config_map; ANALYZE pg_catalog.pg_opfamily; ANALYZE pg_catalog.pg_init_privs; ANALYZE pg_catalog.pg_shdescription; ANALYZE pg_catalog.pg_ts_dict; ANALYZE pg_catalog.pg_ts_parser; ANALYZE pg_catalog.pg_ts_template; ANALYZE pg_catalog.pg_extension; ANALYZE information_schema.sql_implementation_info; ANALYZE pg_catalog.pg_am; ANALYZE pg_catalog.pg_range; ANALYZE pg_catalog.pg_language; ANALYZE information_schema.sql_packages; ANALYZE information_schema.sql_parts; ANALYZE information_schema.sql_sizing; ANALYZE information_schema.sql_languages; ANALYZE pg_catalog.pg_authid; ANALYZE pg_catalog.pg_namespace; ANALYZE pg_catalog.pg_database; ANALYZE pg_catalog.pg_constraint; ANALYZE pg_catalog.pg_tablespace; ANALYZE pg_catalog.pg_pltemplate; ANALYZE pg_catalog.pg_auth_members; ANALYZE pg_catalog.pg_ts_config; ANALYZE pg_catalog.pg_largeobject; ANALYZE pg_catalog.pg_foreign_table; ANALYZE pg_catalog.pg_user_mapping; ANALYZE pg_catalog.pg_subscription; ANALYZE pg_catalog.pg_sequence; ANALYZE pg_catalog.pg_publication; ANALYZE pg_catalog.pg_publication_rel; ANALYZE pg_catalog.pg_subscription_rel; ANALYZE pg_catalog.pg_largeobject_metadata; ANALYZE pg_catalog.pg_attrdef; ANALYZE pg_catalog.pg_inherits; ANALYZE pg_catalog.pg_statistic_ext; ANALYZE pg_catalog.pg_trigger; ANALYZE pg_catalog.pg_event_trigger; ANALYZE pg_catalog.pg_enum; ANALYZE pg_catalog.pg_db_role_setting; ANALYZE pg_catalog.pg_foreign_data_wrapper; ANALYZE pg_catalog.pg_foreign_server; ANALYZE pg_catalog.pg_policy; ANALYZE pg_catalog.pg_replication_origin; ANALYZE pg_catalog.pg_default_acl; ANALYZE pg_catalog.pg_seclabel; ANALYZE pg_catalog.pg_shseclabel; ANALYZE pg_catalog.pg_partitioned_table; ANALYZE pg_catalog.pg_transform; ANALYZE information_schema.sql_sizing_profiles; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "template1": Generating minimal optimizer statistics (1 target) SELECT c.relname, ns.nspname FROM pg_class c, pg_namespace ns WHERE relkind IN ('r', 'm') AND c.relnamespace = ns.oid ORDER BY c.relpages DESC; SELECT pg_catalog.set_config('search_path', '', false) SET default_statistics_target=1; SET vacuum_cost_delay=0; SET default_statistics_target=1; SET vacuum_cost_delay=0; ANALYZE pg_catalog.pg_proc; ANALYZE pg_catalog.pg_depend; ANALYZE pg_catalog.pg_attribute; ANALYZE pg_catalog.pg_description; ANALYZE pg_catalog.pg_statistic; ANALYZE pg_catalog.pg_collation; ANALYZE pg_catalog.pg_operator; ANALYZE pg_catalog.pg_class; ANALYZE pg_catalog.pg_rewrite; ANALYZE pg_catalog.pg_type; ANALYZE pg_catalog.pg_amop; ANALYZE information_schema.sql_features; ANALYZE pg_catalog.pg_shdepend; ANALYZE pg_catalog.pg_amproc; ANALYZE pg_catalog.pg_opclass; ANALYZE pg_catalog.pg_index; ANALYZE pg_catalog.pg_conversion; ANALYZE pg_catalog.pg_aggregate; ANALYZE pg_catalog.pg_cast; ANALYZE pg_catalog.pg_ts_config_map; ANALYZE pg_catalog.pg_opfamily; ANALYZE pg_catalog.pg_init_privs; ANALYZE pg_catalog.pg_shdescription; ANALYZE pg_catalog.pg_ts_dict; ANALYZE pg_catalog.pg_ts_parser; ANALYZE pg_catalog.pg_ts_template; ANALYZE pg_catalog.pg_extension; ANALYZE information_schema.sql_implementation_info; ANALYZE pg_catalog.pg_am; ANALYZE pg_catalog.pg_range; ANALYZE pg_catalog.pg_language; ANALYZE information_schema.sql_packages; ANALYZE information_schema.sql_parts; ANALYZE information_schema.sql_sizing; ANALYZE information_schema.sql_languages; ANALYZE pg_catalog.pg_authid; ANALYZE pg_catalog.pg_namespace; ANALYZE pg_catalog.pg_database; ANALYZE pg_catalog.pg_constraint; ANALYZE pg_catalog.pg_tablespace; ANALYZE pg_catalog.pg_pltemplate; ANALYZE pg_catalog.pg_auth_members; ANALYZE pg_catalog.pg_ts_config; ANALYZE pg_catalog.pg_largeobject; ANALYZE pg_catalog.pg_foreign_table; ANALYZE pg_catalog.pg_user_mapping; ANALYZE pg_catalog.pg_subscription; ANALYZE pg_catalog.pg_sequence; ANALYZE pg_catalog.pg_publication; ANALYZE pg_catalog.pg_publication_rel; ANALYZE pg_catalog.pg_subscription_rel; ANALYZE pg_catalog.pg_largeobject_metadata; ANALYZE pg_catalog.pg_attrdef; ANALYZE pg_catalog.pg_inherits; ANALYZE pg_catalog.pg_statistic_ext; ANALYZE pg_catalog.pg_trigger; ANALYZE pg_catalog.pg_event_trigger; ANALYZE pg_catalog.pg_enum; ANALYZE pg_catalog.pg_db_role_setting; ANALYZE pg_catalog.pg_foreign_data_wrapper; ANALYZE pg_catalog.pg_foreign_server; ANALYZE pg_catalog.pg_policy; ANALYZE pg_catalog.pg_replication_origin; ANALYZE pg_catalog.pg_default_acl; ANALYZE pg_catalog.pg_seclabel; ANALYZE pg_catalog.pg_shseclabel; ANALYZE pg_catalog.pg_partitioned_table; ANALYZE pg_catalog.pg_transform; ANALYZE information_schema.sql_sizing_profiles; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "gitlabhq_production": Generating medium optimizer statistics (10 targets) SELECT c.relname, ns.nspname FROM pg_class c, pg_namespace ns WHERE relkind IN ('r', 'm') AND c.relnamespace = ns.oid ORDER BY c.relpages DESC; SELECT pg_catalog.set_config('search_path', '', false) SET default_statistics_target=10; RESET vacuum_cost_delay; SET default_statistics_target=10; RESET vacuum_cost_delay; ANALYZE pg_catalog.pg_attribute; ANALYZE public.audit_events; ANALYZE pg_catalog.pg_depend; ANALYZE pg_catalog.pg_statistic; ANALYZE pg_catalog.pg_proc; ANALYZE pg_catalog.pg_class; ANALYZE public.ci_builds; ANALYZE pg_catalog.pg_index; ANALYZE pg_catalog.pg_trigger; ANALYZE public.sent_notifications; ANALYZE pg_catalog.pg_type; ANALYZE pg_catalog.pg_description; ANALYZE pg_catalog.pg_attrdef; ANALYZE pg_catalog.pg_collation; ANALYZE public.web_hook_logs; ANALYZE pg_catalog.pg_constraint; ANALYZE public.oauth_access_grants; ANALYZE pg_catalog.pg_operator; ANALYZE public.ci_build_trace_sections; ANALYZE pg_catalog.pg_rewrite; ANALYZE public.schema_migrations; ANALYZE public.ci_runners; ANALYZE public.ci_pipelines; ANALYZE public.ci_stages; ANALYZE public.users; ANALYZE public.merge_request_diff_commits; ANALYZE public.ci_job_artifacts; ANALYZE public.appearances; ANALYZE public.user_agent_details; ANALYZE pg_catalog.pg_amop; ANALYZE information_schema.sql_features; ANALYZE public.notification_settings; ANALYZE public.system_note_metadata; ANALYZE public.notes; ANALYZE public.namespaces; ANALYZE public.events; ANALYZE public.projects; ANALYZE public.push_event_payloads; ANALYZE pg_catalog.pg_shdepend; ANALYZE public.routes; ANALYZE pg_catalog.pg_amproc; ANALYZE pg_catalog.pg_sequence; ANALYZE public.keys; ANALYZE public.members; ANALYZE public.application_settings; ANALYZE pg_catalog.pg_opclass; ANALYZE public.protected_branches; ANALYZE public.merge_request_diff_files; ANALYZE public.protected_branch_merge_access_levels; ANALYZE public.project_statistics; ANALYZE pg_catalog.pg_conversion; ANALYZE public.protected_branch_push_access_levels; ANALYZE public.identities; ANALYZE pg_catalog.pg_init_privs; ANALYZE pg_catalog.pg_cast; ANALYZE pg_catalog.pg_ts_config_map; ANALYZE public.oauth_access_tokens; ANALYZE public.merge_requests; ANALYZE public.user_highest_roles; ANALYZE public.broadcast_messages; ANALYZE public.issues; ANALYZE pg_catalog.pg_opfamily; ANALYZE pg_catalog.pg_aggregate; ANALYZE public.project_authorizations; ANALYZE public.services; ANALYZE public.merge_request_diffs; ANALYZE public.application_setting_terms; ANALYZE public.project_ci_cd_settings; ANALYZE public.personal_access_tokens; ANALYZE public.project_features; ANALYZE public.prometheus_metrics; ANALYZE public.resource_label_events; ANALYZE pg_catalog.pg_ts_config; ANALYZE pg_catalog.pg_shdescription; ANALYZE pg_catalog.pg_auth_members; ANALYZE public.ar_internal_metadata; ANALYZE public.ci_runner_projects; ANALYZE public.internal_ids; ANALYZE pg_catalog.pg_pltemplate; ANALYZE pg_catalog.pg_tablespace; ANALYZE pg_catalog.pg_database; ANALYZE public.ci_variables; ANALYZE public.ci_triggers; ANALYZE public.cluster_projects; ANALYZE public.shards; ANALYZE pg_catalog.pg_language; ANALYZE public.issue_assignees; ANALYZE public.issue_metrics; ANALYZE public.cluster_platforms_kubernetes; ANALYZE public.alerts_service_data; ANALYZE public.tags; ANALYZE public.trending_projects; ANALYZE public.timelogs; ANALYZE public.oauth_applications; ANALYZE public.taggings; ANALYZE public.term_agreements; ANALYZE public.deployments; ANALYZE public.clusters; ANALYZE public.todos; ANALYZE public.user_callouts; ANALYZE public.uploads; ANALYZE public.deployment_merge_requests; ANALYZE public.user_preferences; ANALYZE public.user_statuses; ANALYZE public.clusters_kubernetes_namespaces; ANALYZE public.user_details; ANALYZE public.user_interacted_projects; ANALYZE public.label_links; ANALYZE public.deploy_keys_projects; ANALYZE information_schema.sql_implementation_info; ANALYZE public.lfs_objects; ANALYZE public.namespace_root_storage_statistics; ANALYZE public.lfs_objects_projects; ANALYZE public.feature_gates; ANALYZE public.namespace_aggregation_schedules; ANALYZE public.labels; ANALYZE public.merge_request_assignees; ANALYZE public.container_expiration_policies; ANALYZE public.lists; ANALYZE pg_catalog.pg_namespace; ANALYZE information_schema.sql_languages; ANALYZE public.milestones; ANALYZE public.environments; ANALYZE public.ci_build_trace_section_names; ANALYZE public.container_repositories; ANALYZE pg_catalog.pg_ts_template; ANALYZE public.boards; ANALYZE public.project_auto_devops; ANALYZE public.features; ANALYZE pg_catalog.pg_extension; ANALYZE pg_catalog.pg_ts_parser; ANALYZE public.project_daily_statistics; ANALYZE public.fork_network_members; ANALYZE public.project_group_links; ANALYZE public.plan_limits; ANALYZE public.programming_languages; ANALYZE public.fork_networks; ANALYZE pg_catalog.pg_authid; ANALYZE public.plans; ANALYZE public.project_mirror_data; ANALYZE pg_catalog.pg_ts_dict; ANALYZE public.project_pages_metadata; ANALYZE public.ci_builds_metadata; ANALYZE public.project_settings; ANALYZE public.project_repositories; ANALYZE public.web_hooks; ANALYZE public.emails; ANALYZE public.repository_languages; ANALYZE public.redirect_routes; ANALYZE pg_catalog.pg_range; ANALYZE pg_catalog.pg_am; ANALYZE information_schema.sql_packages; ANALYZE public.merge_request_metrics; ANALYZE public.ci_pipelines_config; ANALYZE information_schema.sql_parts; ANALYZE public.ci_trigger_requests; ANALYZE information_schema.sql_sizing; ANALYZE public.open_project_tracker_data; ANALYZE public.operations_feature_flag_scopes; ANALYZE public.namespace_statistics; ANALYZE public.note_diff_files; ANALYZE public.oauth_openid_requests; ANALYZE public.operations_feature_flags_clients; ANALYZE public.operations_strategies; ANALYZE public.packages_conan_metadata; ANALYZE public.packages_build_infos; ANALYZE public.packages_dependencies; ANALYZE public.operations_user_lists; ANALYZE public.operations_feature_flags; ANALYZE public.operations_scopes; ANALYZE public.packages_conan_file_metadata; ANALYZE public.packages_maven_metadata; ANALYZE public.packages_dependency_links; ANALYZE public.pages_domains; ANALYZE public.packages_pypi_metadata; ANALYZE public.packages_tags; ANALYZE public.pool_repositories; ANALYZE public.pages_domain_acme_orders; ANALYZE public.packages_packages; ANALYZE public.path_locks; ANALYZE public.packages_package_files; ANALYZE public.project_incident_management_settings; ANALYZE public.project_feature_usages; ANALYZE public.project_alerting_settings; ANALYZE public.project_compliance_framework_settings; ANALYZE public.project_custom_attributes; ANALYZE public.project_error_tracking_settings; ANALYZE public.project_export_jobs; ANALYZE public.project_import_data; ANALYZE public.project_deploy_tokens; ANALYZE public.project_aliases; ANALYZE public.project_tracing_settings; ANALYZE public.protected_branch_unprotect_access_levels; ANALYZE public.prometheus_alerts; ANALYZE public.project_metrics_settings; ANALYZE public.project_repository_states; ANALYZE public.prometheus_alert_events; ANALYZE public.protected_tags; ANALYZE public.release_links; ANALYZE public.remote_mirrors; ANALYZE public.releases; ANALYZE public.protected_tag_create_access_levels; ANALYZE public.protected_environments; ANALYZE public.protected_environment_deploy_access_levels; ANALYZE public.push_rules; ANALYZE public.self_managed_prometheus_alert_events; ANALYZE public.resource_weight_events; ANALYZE public.scim_oauth_access_tokens; ANALYZE public.resource_milestone_events; ANALYZE public.saml_providers; ANALYZE public.requirements; ANALYZE public.security_scans; ANALYZE public.scim_identities; ANALYZE public.reviews; ANALYZE public.slack_integrations; ANALYZE public.serverless_domain_cluster; ANALYZE public.sentry_issues; ANALYZE public.snippet_user_mentions; ANALYZE public.snippets; ANALYZE public.software_licenses; ANALYZE public.smartcard_identities; ANALYZE public.service_desk_settings; ANALYZE public.snippet_repositories; ANALYZE public.software_license_policies; ANALYZE public.spam_logs; ANALYZE public.terraform_states; ANALYZE public.status_page_settings; ANALYZE public.subscriptions; ANALYZE public.suggestions; ANALYZE public.u2f_registrations; ANALYZE public.user_synced_attributes_metadata; ANALYZE public.user_canonical_emails; ANALYZE public.users_ops_dashboard_projects; ANALYZE public.user_custom_attributes; ANALYZE public.vulnerability_user_mentions; ANALYZE public.vulnerability_feedback; ANALYZE public.users_statistics; ANALYZE public.users_star_projects; ANALYZE public.users_security_dashboard_projects; ANALYZE public.vulnerability_occurrences; ANALYZE public.vulnerability_occurrence_identifiers; ANALYZE public.vulnerability_issue_links; ANALYZE public.vulnerability_exports; ANALYZE public.vulnerability_scanners; ANALYZE public.vulnerability_occurrence_pipelines; ANALYZE public.vulnerability_identifiers; ANALYZE public.vulnerabilities; ANALYZE public.zoom_meetings; ANALYZE public.x509_certificates; ANALYZE public.wiki_page_meta; ANALYZE public.x509_commit_signatures; ANALYZE public.x509_issuers; ANALYZE public.wiki_page_slugs; ANALYZE pg_catalog.pg_foreign_table; ANALYZE pg_catalog.pg_user_mapping; ANALYZE pg_catalog.pg_subscription; ANALYZE pg_catalog.pg_publication; ANALYZE pg_catalog.pg_publication_rel; ANALYZE pg_catalog.pg_subscription_rel; ANALYZE pg_catalog.pg_largeobject_metadata; ANALYZE pg_catalog.pg_inherits; ANALYZE pg_catalog.pg_statistic_ext; ANALYZE pg_catalog.pg_event_trigger; ANALYZE pg_catalog.pg_enum; ANALYZE pg_catalog.pg_db_role_setting; ANALYZE pg_catalog.pg_foreign_data_wrapper; ANALYZE pg_catalog.pg_foreign_server; ANALYZE pg_catalog.pg_policy; ANALYZE pg_catalog.pg_replication_origin; ANALYZE pg_catalog.pg_default_acl; ANALYZE pg_catalog.pg_seclabel; ANALYZE pg_catalog.pg_shseclabel; ANALYZE pg_catalog.pg_partitioned_table; ANALYZE pg_catalog.pg_transform; ANALYZE information_schema.sql_sizing_profiles; ANALYZE pg_catalog.pg_largeobject; ANALYZE public.abuse_reports; ANALYZE public.analytics_cycle_analytics_group_stages; ANALYZE public.approval_merge_request_rule_sources; ANALYZE public.allowed_email_domains; ANALYZE public.approval_merge_request_rules; ANALYZE public.analytics_language_trend_repository_languages; ANALYZE public.analytics_cycle_analytics_project_stages; ANALYZE public.approval_merge_request_rules_users; ANALYZE public.approval_project_rules_groups; ANALYZE public.approver_groups; ANALYZE public.approval_project_rules_users; ANALYZE public.approval_project_rules_protected_branches; ANALYZE public.aws_roles; ANALYZE public.approval_merge_request_rules_approved_approvers; ANALYZE public.approval_merge_request_rules_groups; ANALYZE public.approvers; ANALYZE public.award_emoji; ANALYZE public.approval_project_rules; ANALYZE public.approvals; ANALYZE public.board_group_recent_visits; ANALYZE public.board_labels; ANALYZE public.board_project_recent_visits; ANALYZE public.chat_teams; ANALYZE public.ci_build_needs; ANALYZE public.board_assignees; ANALYZE public.badges; ANALYZE public.ci_build_trace_chunks; ANALYZE public.chat_names; ANALYZE public.ci_pipeline_schedules; ANALYZE public.ci_job_variables; ANALYZE public.ci_daily_report_results; ANALYZE public.ci_pipeline_variables; ANALYZE public.ci_builds_runner_session; ANALYZE public.ci_pipeline_schedule_variables; ANALYZE public.ci_pipeline_chat_data; ANALYZE public.ci_group_variables; ANALYZE public.ci_sources_pipelines; ANALYZE public.ci_subscriptions_projects; ANALYZE public.ci_runner_namespaces; ANALYZE public.ci_resource_groups; ANALYZE public.ci_refs; ANALYZE public.ci_sources_projects; ANALYZE public.ci_resources; ANALYZE public.clusters_applications_elastic_stacks; ANALYZE public.cluster_groups; ANALYZE public.clusters_applications_fluentd; ANALYZE public.clusters_applications_crossplane; ANALYZE public.clusters_applications_cert_managers; ANALYZE public.cluster_providers_aws; ANALYZE public.cluster_providers_gcp; ANALYZE public.clusters_applications_prometheus; ANALYZE public.commit_user_mentions; ANALYZE public.clusters_applications_helm; ANALYZE public.clusters_applications_ingress; ANALYZE public.clusters_applications_knative; ANALYZE public.clusters_applications_jupyter; ANALYZE public.conversational_development_index_metrics; ANALYZE public.clusters_applications_runners; ANALYZE public.description_versions; ANALYZE public.dependency_proxy_group_settings; ANALYZE public.diff_note_positions; ANALYZE public.design_user_mentions; ANALYZE public.design_management_versions; ANALYZE public.deploy_tokens; ANALYZE public.dependency_proxy_blobs; ANALYZE public.deployment_clusters; ANALYZE public.design_management_designs; ANALYZE public.design_management_designs_versions; ANALYZE public.epic_issues; ANALYZE public.epic_metrics; ANALYZE public.elasticsearch_indexed_namespaces; ANALYZE public.epic_user_mentions; ANALYZE public.evidences; ANALYZE public.draft_notes; ANALYZE public.elasticsearch_indexed_projects; ANALYZE public.external_pull_requests; ANALYZE public.epics; ANALYZE public.geo_container_repository_updated_events; ANALYZE public.geo_lfs_object_deleted_events; ANALYZE public.geo_events; ANALYZE public.geo_hashed_storage_migrated_events; ANALYZE public.geo_node_statuses; ANALYZE public.geo_cache_invalidation_events; ANALYZE public.geo_node_namespace_links; ANALYZE public.geo_hashed_storage_attachments_events; ANALYZE public.geo_job_artifact_deleted_events; ANALYZE public.geo_event_log; ANALYZE public.gpg_key_subkeys; ANALYZE public.geo_repository_updated_events; ANALYZE public.geo_nodes; ANALYZE public.gitlab_subscriptions; ANALYZE public.geo_repository_created_events; ANALYZE public.geo_reset_checksum_events; ANALYZE public.geo_repository_renamed_events; ANALYZE public.gitlab_subscription_histories; ANALYZE public.geo_repository_deleted_events; ANALYZE public.geo_upload_deleted_events; ANALYZE public.gpg_keys; ANALYZE public.geo_repositories_changed_events; ANALYZE public.grafana_integrations; ANALYZE public.insights; ANALYZE public.group_custom_attributes; ANALYZE public.index_statuses; ANALYZE public.group_group_links; ANALYZE public.historical_data; ANALYZE public.gpg_signatures; ANALYZE public.import_export_uploads; ANALYZE public.group_deploy_tokens; ANALYZE public.import_failures; ANALYZE public.group_deletion_schedules; ANALYZE public.issue_user_mentions; ANALYZE public.jira_connect_subscriptions; ANALYZE public.jira_connect_installations; ANALYZE public.jira_imports; ANALYZE public.issues_self_managed_prometheus_alert_events; ANALYZE public.issue_tracker_data; ANALYZE public.jira_tracker_data; ANALYZE public.ip_restrictions; ANALYZE public.issue_links; ANALYZE public.issues_prometheus_alert_events; ANALYZE public.lfs_file_locks; ANALYZE public.ldap_group_links; ANALYZE public.licenses; ANALYZE public.merge_request_blocks; ANALYZE public.merge_request_context_commit_diff_files; ANALYZE public.list_user_preferences; ANALYZE public.label_priorities; ANALYZE public.merge_request_context_commits; ANALYZE public.metrics_dashboard_annotations; ANALYZE public.milestone_releases; ANALYZE public.merge_trains; ANALYZE public.merge_requests_closing_issues; ANALYZE public.merge_request_user_mentions; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "postgres": Generating medium optimizer statistics (10 targets) SELECT c.relname, ns.nspname FROM pg_class c, pg_namespace ns WHERE relkind IN ('r', 'm') AND c.relnamespace = ns.oid ORDER BY c.relpages DESC; SELECT pg_catalog.set_config('search_path', '', false) SET default_statistics_target=10; RESET vacuum_cost_delay; SET default_statistics_target=10; RESET vacuum_cost_delay; ANALYZE pg_catalog.pg_proc; ANALYZE pg_catalog.pg_depend; ANALYZE pg_catalog.pg_attribute; ANALYZE pg_catalog.pg_description; ANALYZE pg_catalog.pg_statistic; ANALYZE pg_catalog.pg_collation; ANALYZE pg_catalog.pg_operator; ANALYZE pg_catalog.pg_class; ANALYZE pg_catalog.pg_rewrite; ANALYZE pg_catalog.pg_type; ANALYZE pg_catalog.pg_amop; ANALYZE information_schema.sql_features; ANALYZE pg_catalog.pg_shdepend; ANALYZE pg_catalog.pg_amproc; ANALYZE pg_catalog.pg_opclass; ANALYZE pg_catalog.pg_index; ANALYZE pg_catalog.pg_conversion; ANALYZE pg_catalog.pg_aggregate; ANALYZE pg_catalog.pg_cast; ANALYZE pg_catalog.pg_ts_config_map; ANALYZE pg_catalog.pg_opfamily; ANALYZE pg_catalog.pg_init_privs; ANALYZE pg_catalog.pg_shdescription; ANALYZE pg_catalog.pg_ts_dict; ANALYZE pg_catalog.pg_ts_parser; ANALYZE pg_catalog.pg_ts_template; ANALYZE pg_catalog.pg_extension; ANALYZE information_schema.sql_implementation_info; ANALYZE pg_catalog.pg_am; ANALYZE pg_catalog.pg_range; ANALYZE pg_catalog.pg_language; ANALYZE information_schema.sql_packages; ANALYZE information_schema.sql_parts; ANALYZE information_schema.sql_sizing; ANALYZE information_schema.sql_languages; ANALYZE pg_catalog.pg_authid; ANALYZE pg_catalog.pg_namespace; ANALYZE pg_catalog.pg_database; ANALYZE pg_catalog.pg_constraint; ANALYZE pg_catalog.pg_tablespace; ANALYZE pg_catalog.pg_pltemplate; ANALYZE pg_catalog.pg_auth_members; ANALYZE pg_catalog.pg_ts_config; ANALYZE pg_catalog.pg_largeobject; ANALYZE pg_catalog.pg_foreign_table; ANALYZE pg_catalog.pg_user_mapping; ANALYZE pg_catalog.pg_subscription; ANALYZE pg_catalog.pg_sequence; ANALYZE pg_catalog.pg_publication; ANALYZE pg_catalog.pg_publication_rel; ANALYZE pg_catalog.pg_subscription_rel; ANALYZE pg_catalog.pg_largeobject_metadata; ANALYZE pg_catalog.pg_attrdef; ANALYZE pg_catalog.pg_inherits; ANALYZE pg_catalog.pg_statistic_ext; ANALYZE pg_catalog.pg_trigger; ANALYZE pg_catalog.pg_event_trigger; ANALYZE pg_catalog.pg_enum; ANALYZE pg_catalog.pg_db_role_setting; ANALYZE pg_catalog.pg_foreign_data_wrapper; ANALYZE pg_catalog.pg_foreign_server; ANALYZE pg_catalog.pg_policy; ANALYZE pg_catalog.pg_replication_origin; ANALYZE pg_catalog.pg_default_acl; ANALYZE pg_catalog.pg_seclabel; ANALYZE pg_catalog.pg_shseclabel; ANALYZE pg_catalog.pg_partitioned_table; ANALYZE pg_catalog.pg_transform; ANALYZE information_schema.sql_sizing_profiles; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "template1": Generating medium optimizer statistics (10 targets) SELECT c.relname, ns.nspname FROM pg_class c, pg_namespace ns WHERE relkind IN ('r', 'm') AND c.relnamespace = ns.oid ORDER BY c.relpages DESC; SELECT pg_catalog.set_config('search_path', '', false) SET default_statistics_target=10; RESET vacuum_cost_delay; SET default_statistics_target=10; RESET vacuum_cost_delay; ANALYZE pg_catalog.pg_proc; ANALYZE pg_catalog.pg_depend; ANALYZE pg_catalog.pg_attribute; ANALYZE pg_catalog.pg_description; ANALYZE pg_catalog.pg_statistic; ANALYZE pg_catalog.pg_collation; ANALYZE pg_catalog.pg_operator; ANALYZE pg_catalog.pg_class; ANALYZE pg_catalog.pg_rewrite; ANALYZE pg_catalog.pg_type; ANALYZE pg_catalog.pg_amop; ANALYZE information_schema.sql_features; ANALYZE pg_catalog.pg_shdepend; ANALYZE pg_catalog.pg_amproc; ANALYZE pg_catalog.pg_opclass; ANALYZE pg_catalog.pg_index; ANALYZE pg_catalog.pg_conversion; ANALYZE pg_catalog.pg_aggregate; ANALYZE pg_catalog.pg_cast; ANALYZE pg_catalog.pg_ts_config_map; ANALYZE pg_catalog.pg_opfamily; ANALYZE pg_catalog.pg_init_privs; ANALYZE pg_catalog.pg_shdescription; ANALYZE pg_catalog.pg_ts_dict; ANALYZE pg_catalog.pg_ts_parser; ANALYZE pg_catalog.pg_ts_template; ANALYZE pg_catalog.pg_extension; ANALYZE information_schema.sql_implementation_info; ANALYZE pg_catalog.pg_am; ANALYZE pg_catalog.pg_range; ANALYZE pg_catalog.pg_language; ANALYZE information_schema.sql_packages; ANALYZE information_schema.sql_parts; ANALYZE information_schema.sql_sizing; ANALYZE information_schema.sql_languages; ANALYZE pg_catalog.pg_authid; ANALYZE pg_catalog.pg_namespace; ANALYZE pg_catalog.pg_database; ANALYZE pg_catalog.pg_constraint; ANALYZE pg_catalog.pg_tablespace; ANALYZE pg_catalog.pg_pltemplate; ANALYZE pg_catalog.pg_auth_members; ANALYZE pg_catalog.pg_ts_config; ANALYZE pg_catalog.pg_largeobject; ANALYZE pg_catalog.pg_foreign_table; ANALYZE pg_catalog.pg_user_mapping; ANALYZE pg_catalog.pg_subscription; ANALYZE pg_catalog.pg_sequence; ANALYZE pg_catalog.pg_publication; ANALYZE pg_catalog.pg_publication_rel; ANALYZE pg_catalog.pg_subscription_rel; ANALYZE pg_catalog.pg_largeobject_metadata; ANALYZE pg_catalog.pg_attrdef; ANALYZE pg_catalog.pg_inherits; ANALYZE pg_catalog.pg_statistic_ext; ANALYZE pg_catalog.pg_trigger; ANALYZE pg_catalog.pg_event_trigger; ANALYZE pg_catalog.pg_enum; ANALYZE pg_catalog.pg_db_role_setting; ANALYZE pg_catalog.pg_foreign_data_wrapper; ANALYZE pg_catalog.pg_foreign_server; ANALYZE pg_catalog.pg_policy; ANALYZE pg_catalog.pg_replication_origin; ANALYZE pg_catalog.pg_default_acl; ANALYZE pg_catalog.pg_seclabel; ANALYZE pg_catalog.pg_shseclabel; ANALYZE pg_catalog.pg_partitioned_table; ANALYZE pg_catalog.pg_transform; ANALYZE information_schema.sql_sizing_profiles; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "gitlabhq_production": Generating default (full) optimizer statistics SELECT c.relname, ns.nspname FROM pg_class c, pg_namespace ns WHERE relkind IN ('r', 'm') AND c.relnamespace = ns.oid ORDER BY c.relpages DESC; SELECT pg_catalog.set_config('search_path', '', false) RESET default_statistics_target; RESET default_statistics_target; ANALYZE pg_catalog.pg_attribute; ANALYZE public.audit_events; ANALYZE pg_catalog.pg_depend; ANALYZE pg_catalog.pg_statistic; ANALYZE pg_catalog.pg_proc; ANALYZE pg_catalog.pg_class; ANALYZE public.ci_builds; ANALYZE pg_catalog.pg_index; ANALYZE pg_catalog.pg_trigger; ANALYZE public.sent_notifications; ANALYZE pg_catalog.pg_type; ANALYZE pg_catalog.pg_description; ANALYZE pg_catalog.pg_attrdef; ANALYZE pg_catalog.pg_collation; ANALYZE public.web_hook_logs; ANALYZE pg_catalog.pg_constraint; ANALYZE public.oauth_access_grants; ANALYZE pg_catalog.pg_operator; ANALYZE public.ci_build_trace_sections; ANALYZE pg_catalog.pg_rewrite; ANALYZE public.schema_migrations; ANALYZE public.ci_runners; ANALYZE public.ci_pipelines; ANALYZE public.ci_stages; ANALYZE public.users; ANALYZE public.merge_request_diff_commits; ANALYZE public.ci_job_artifacts; ANALYZE public.appearances; ANALYZE public.user_agent_details; ANALYZE pg_catalog.pg_amop; ANALYZE information_schema.sql_features; ANALYZE public.notification_settings; ANALYZE public.system_note_metadata; ANALYZE public.notes; ANALYZE public.namespaces; ANALYZE public.events; ANALYZE public.projects; ANALYZE public.push_event_payloads; ANALYZE pg_catalog.pg_shdepend; ANALYZE public.routes; ANALYZE pg_catalog.pg_amproc; ANALYZE pg_catalog.pg_sequence; ANALYZE public.keys; ANALYZE public.members; ANALYZE public.application_settings; ANALYZE pg_catalog.pg_opclass; ANALYZE public.protected_branches; ANALYZE public.merge_request_diff_files; ANALYZE public.protected_branch_merge_access_levels; ANALYZE public.project_statistics; ANALYZE pg_catalog.pg_conversion; ANALYZE public.protected_branch_push_access_levels; ANALYZE public.identities; ANALYZE pg_catalog.pg_init_privs; ANALYZE pg_catalog.pg_cast; ANALYZE pg_catalog.pg_ts_config_map; ANALYZE public.oauth_access_tokens; ANALYZE public.merge_requests; ANALYZE public.user_highest_roles; ANALYZE public.broadcast_messages; ANALYZE public.issues; ANALYZE pg_catalog.pg_opfamily; ANALYZE pg_catalog.pg_aggregate; ANALYZE public.project_authorizations; ANALYZE public.services; ANALYZE public.merge_request_diffs; ANALYZE public.application_setting_terms; ANALYZE public.project_ci_cd_settings; ANALYZE public.personal_access_tokens; ANALYZE public.project_features; ANALYZE public.prometheus_metrics; ANALYZE public.resource_label_events; ANALYZE pg_catalog.pg_ts_config; ANALYZE pg_catalog.pg_shdescription; ANALYZE pg_catalog.pg_auth_members; ANALYZE public.ar_internal_metadata; ANALYZE public.ci_runner_projects; ANALYZE public.internal_ids; ANALYZE pg_catalog.pg_pltemplate; ANALYZE pg_catalog.pg_tablespace; ANALYZE pg_catalog.pg_database; ANALYZE public.ci_variables; ANALYZE public.ci_triggers; ANALYZE public.cluster_projects; ANALYZE public.shards; ANALYZE pg_catalog.pg_language; ANALYZE public.issue_assignees; ANALYZE public.issue_metrics; ANALYZE public.cluster_platforms_kubernetes; ANALYZE public.alerts_service_data; ANALYZE public.tags; ANALYZE public.trending_projects; ANALYZE public.timelogs; ANALYZE public.oauth_applications; ANALYZE public.taggings; ANALYZE public.term_agreements; ANALYZE public.deployments; ANALYZE public.clusters; ANALYZE public.todos; ANALYZE public.user_callouts; ANALYZE public.uploads; ANALYZE public.deployment_merge_requests; ANALYZE public.user_preferences; ANALYZE public.user_statuses; ANALYZE public.clusters_kubernetes_namespaces; ANALYZE public.user_details; ANALYZE public.user_interacted_projects; ANALYZE public.label_links; ANALYZE public.deploy_keys_projects; ANALYZE information_schema.sql_implementation_info; ANALYZE public.lfs_objects; ANALYZE public.namespace_root_storage_statistics; ANALYZE public.lfs_objects_projects; ANALYZE public.feature_gates; ANALYZE public.namespace_aggregation_schedules; ANALYZE public.labels; ANALYZE public.merge_request_assignees; ANALYZE public.container_expiration_policies; ANALYZE public.lists; ANALYZE pg_catalog.pg_namespace; ANALYZE information_schema.sql_languages; ANALYZE public.milestones; ANALYZE public.environments; ANALYZE public.ci_build_trace_section_names; ANALYZE public.container_repositories; ANALYZE pg_catalog.pg_ts_template; ANALYZE public.boards; ANALYZE public.project_auto_devops; ANALYZE public.features; ANALYZE pg_catalog.pg_extension; ANALYZE pg_catalog.pg_ts_parser; ANALYZE public.project_daily_statistics; ANALYZE public.fork_network_members; ANALYZE public.project_group_links; ANALYZE public.plan_limits; ANALYZE public.programming_languages; ANALYZE public.fork_networks; ANALYZE pg_catalog.pg_authid; ANALYZE public.plans; ANALYZE public.project_mirror_data; ANALYZE pg_catalog.pg_ts_dict; ANALYZE public.project_pages_metadata; ANALYZE public.ci_builds_metadata; ANALYZE public.project_settings; ANALYZE public.project_repositories; ANALYZE public.web_hooks; ANALYZE public.emails; ANALYZE public.repository_languages; ANALYZE public.redirect_routes; ANALYZE pg_catalog.pg_range; ANALYZE pg_catalog.pg_am; ANALYZE information_schema.sql_packages; ANALYZE public.merge_request_metrics; ANALYZE public.ci_pipelines_config; ANALYZE information_schema.sql_parts; ANALYZE public.ci_trigger_requests; ANALYZE information_schema.sql_sizing; ANALYZE public.open_project_tracker_data; ANALYZE public.operations_feature_flag_scopes; ANALYZE public.namespace_statistics; ANALYZE public.note_diff_files; ANALYZE public.oauth_openid_requests; ANALYZE public.operations_feature_flags_clients; ANALYZE public.operations_strategies; ANALYZE public.packages_conan_metadata; ANALYZE public.packages_build_infos; ANALYZE public.packages_dependencies; ANALYZE public.operations_user_lists; ANALYZE public.operations_feature_flags; ANALYZE public.operations_scopes; ANALYZE public.packages_conan_file_metadata; ANALYZE public.packages_maven_metadata; ANALYZE public.packages_dependency_links; ANALYZE public.pages_domains; ANALYZE public.packages_pypi_metadata; ANALYZE public.packages_tags; ANALYZE public.pool_repositories; ANALYZE public.pages_domain_acme_orders; ANALYZE public.packages_packages; ANALYZE public.path_locks; ANALYZE public.packages_package_files; ANALYZE public.project_incident_management_settings; ANALYZE public.project_feature_usages; ANALYZE public.project_alerting_settings; ANALYZE public.project_compliance_framework_settings; ANALYZE public.project_custom_attributes; ANALYZE public.project_error_tracking_settings; ANALYZE public.project_export_jobs; ANALYZE public.project_import_data; ANALYZE public.project_deploy_tokens; ANALYZE public.project_aliases; ANALYZE public.project_tracing_settings; ANALYZE public.protected_branch_unprotect_access_levels; ANALYZE public.prometheus_alerts; ANALYZE public.project_metrics_settings; ANALYZE public.project_repository_states; ANALYZE public.prometheus_alert_events; ANALYZE public.protected_tags; ANALYZE public.release_links; ANALYZE public.remote_mirrors; ANALYZE public.releases; ANALYZE public.protected_tag_create_access_levels; ANALYZE public.protected_environments; ANALYZE public.protected_environment_deploy_access_levels; ANALYZE public.push_rules; ANALYZE public.self_managed_prometheus_alert_events; ANALYZE public.resource_weight_events; ANALYZE public.scim_oauth_access_tokens; ANALYZE public.resource_milestone_events; ANALYZE public.saml_providers; ANALYZE public.requirements; ANALYZE public.security_scans; ANALYZE public.scim_identities; ANALYZE public.reviews; ANALYZE public.slack_integrations; ANALYZE public.serverless_domain_cluster; ANALYZE public.sentry_issues; ANALYZE public.snippet_user_mentions; ANALYZE public.snippets; ANALYZE public.software_licenses; ANALYZE public.smartcard_identities; ANALYZE public.service_desk_settings; ANALYZE public.snippet_repositories; ANALYZE public.software_license_policies; ANALYZE public.spam_logs; ANALYZE public.terraform_states; ANALYZE public.status_page_settings; ANALYZE public.subscriptions; ANALYZE public.suggestions; ANALYZE public.u2f_registrations; ANALYZE public.user_synced_attributes_metadata; ANALYZE public.user_canonical_emails; ANALYZE public.users_ops_dashboard_projects; ANALYZE public.user_custom_attributes; ANALYZE public.vulnerability_user_mentions; ANALYZE public.vulnerability_feedback; ANALYZE public.users_statistics; ANALYZE public.users_star_projects; ANALYZE public.users_security_dashboard_projects; ANALYZE public.vulnerability_occurrences; ANALYZE public.vulnerability_occurrence_identifiers; ANALYZE public.vulnerability_issue_links; ANALYZE public.vulnerability_exports; ANALYZE public.vulnerability_scanners; ANALYZE public.vulnerability_occurrence_pipelines; ANALYZE public.vulnerability_identifiers; ANALYZE public.vulnerabilities; ANALYZE public.zoom_meetings; ANALYZE public.x509_certificates; ANALYZE public.wiki_page_meta; ANALYZE public.x509_commit_signatures; ANALYZE public.x509_issuers; ANALYZE public.wiki_page_slugs; ANALYZE pg_catalog.pg_foreign_table; ANALYZE pg_catalog.pg_user_mapping; ANALYZE pg_catalog.pg_subscription; ANALYZE pg_catalog.pg_publication; ANALYZE pg_catalog.pg_publication_rel; ANALYZE pg_catalog.pg_subscription_rel; ANALYZE pg_catalog.pg_largeobject_metadata; ANALYZE pg_catalog.pg_inherits; ANALYZE pg_catalog.pg_statistic_ext; ANALYZE pg_catalog.pg_event_trigger; ANALYZE pg_catalog.pg_enum; ANALYZE pg_catalog.pg_db_role_setting; ANALYZE pg_catalog.pg_foreign_data_wrapper; ANALYZE pg_catalog.pg_foreign_server; ANALYZE pg_catalog.pg_policy; ANALYZE pg_catalog.pg_replication_origin; ANALYZE pg_catalog.pg_default_acl; ANALYZE pg_catalog.pg_seclabel; ANALYZE pg_catalog.pg_shseclabel; ANALYZE pg_catalog.pg_partitioned_table; ANALYZE pg_catalog.pg_transform; ANALYZE information_schema.sql_sizing_profiles; ANALYZE pg_catalog.pg_largeobject; ANALYZE public.abuse_reports; ANALYZE public.analytics_cycle_analytics_group_stages; ANALYZE public.approval_merge_request_rule_sources; ANALYZE public.allowed_email_domains; ANALYZE public.approval_merge_request_rules; ANALYZE public.analytics_language_trend_repository_languages; ANALYZE public.analytics_cycle_analytics_project_stages; ANALYZE public.approval_merge_request_rules_users; ANALYZE public.approval_project_rules_groups; ANALYZE public.approver_groups; ANALYZE public.approval_project_rules_users; ANALYZE public.approval_project_rules_protected_branches; ANALYZE public.aws_roles; ANALYZE public.approval_merge_request_rules_approved_approvers; ANALYZE public.approval_merge_request_rules_groups; ANALYZE public.approvers; ANALYZE public.award_emoji; ANALYZE public.approval_project_rules; ANALYZE public.approvals; ANALYZE public.board_group_recent_visits; ANALYZE public.board_labels; ANALYZE public.board_project_recent_visits; ANALYZE public.chat_teams; ANALYZE public.ci_build_needs; ANALYZE public.board_assignees; ANALYZE public.badges; ANALYZE public.ci_build_trace_chunks; ANALYZE public.chat_names; ANALYZE public.ci_pipeline_schedules; ANALYZE public.ci_job_variables; ANALYZE public.ci_daily_report_results; ANALYZE public.ci_pipeline_variables; ANALYZE public.ci_builds_runner_session; ANALYZE public.ci_pipeline_schedule_variables; ANALYZE public.ci_pipeline_chat_data; ANALYZE public.ci_group_variables; ANALYZE public.ci_sources_pipelines; ANALYZE public.ci_subscriptions_projects; ANALYZE public.ci_runner_namespaces; ANALYZE public.ci_resource_groups; ANALYZE public.ci_refs; ANALYZE public.ci_sources_projects; ANALYZE public.ci_resources; ANALYZE public.clusters_applications_elastic_stacks; ANALYZE public.cluster_groups; ANALYZE public.clusters_applications_fluentd; ANALYZE public.clusters_applications_crossplane; ANALYZE public.clusters_applications_cert_managers; ANALYZE public.cluster_providers_aws; ANALYZE public.cluster_providers_gcp; ANALYZE public.clusters_applications_prometheus; ANALYZE public.commit_user_mentions; ANALYZE public.clusters_applications_helm; ANALYZE public.clusters_applications_ingress; ANALYZE public.clusters_applications_knative; ANALYZE public.clusters_applications_jupyter; ANALYZE public.conversational_development_index_metrics; ANALYZE public.clusters_applications_runners; ANALYZE public.description_versions; ANALYZE public.dependency_proxy_group_settings; ANALYZE public.diff_note_positions; ANALYZE public.design_user_mentions; ANALYZE public.design_management_versions; ANALYZE public.deploy_tokens; ANALYZE public.dependency_proxy_blobs; ANALYZE public.deployment_clusters; ANALYZE public.design_management_designs; ANALYZE public.design_management_designs_versions; ANALYZE public.epic_issues; ANALYZE public.epic_metrics; ANALYZE public.elasticsearch_indexed_namespaces; ANALYZE public.epic_user_mentions; ANALYZE public.evidences; ANALYZE public.draft_notes; ANALYZE public.elasticsearch_indexed_projects; ANALYZE public.external_pull_requests; ANALYZE public.epics; ANALYZE public.geo_container_repository_updated_events; ANALYZE public.geo_lfs_object_deleted_events; ANALYZE public.geo_events; ANALYZE public.geo_hashed_storage_migrated_events; ANALYZE public.geo_node_statuses; ANALYZE public.geo_cache_invalidation_events; ANALYZE public.geo_node_namespace_links; ANALYZE public.geo_hashed_storage_attachments_events; ANALYZE public.geo_job_artifact_deleted_events; ANALYZE public.geo_event_log; ANALYZE public.gpg_key_subkeys; ANALYZE public.geo_repository_updated_events; ANALYZE public.geo_nodes; ANALYZE public.gitlab_subscriptions; ANALYZE public.geo_repository_created_events; ANALYZE public.geo_reset_checksum_events; ANALYZE public.geo_repository_renamed_events; ANALYZE public.gitlab_subscription_histories; ANALYZE public.geo_repository_deleted_events; ANALYZE public.geo_upload_deleted_events; ANALYZE public.gpg_keys; ANALYZE public.geo_repositories_changed_events; ANALYZE public.grafana_integrations; ANALYZE public.insights; ANALYZE public.group_custom_attributes; ANALYZE public.index_statuses; ANALYZE public.group_group_links; ANALYZE public.historical_data; ANALYZE public.gpg_signatures; ANALYZE public.import_export_uploads; ANALYZE public.group_deploy_tokens; ANALYZE public.import_failures; ANALYZE public.group_deletion_schedules; ANALYZE public.issue_user_mentions; ANALYZE public.jira_connect_subscriptions; ANALYZE public.jira_connect_installations; ANALYZE public.jira_imports; ANALYZE public.issues_self_managed_prometheus_alert_events; ANALYZE public.issue_tracker_data; ANALYZE public.jira_tracker_data; ANALYZE public.ip_restrictions; ANALYZE public.issue_links; ANALYZE public.issues_prometheus_alert_events; ANALYZE public.lfs_file_locks; ANALYZE public.ldap_group_links; ANALYZE public.licenses; ANALYZE public.merge_request_blocks; ANALYZE public.merge_request_context_commit_diff_files; ANALYZE public.list_user_preferences; ANALYZE public.label_priorities; ANALYZE public.merge_request_context_commits; ANALYZE public.metrics_dashboard_annotations; ANALYZE public.milestone_releases; ANALYZE public.merge_trains; ANALYZE public.merge_requests_closing_issues; ANALYZE public.merge_request_user_mentions; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "postgres": Generating default (full) optimizer statistics SELECT c.relname, ns.nspname FROM pg_class c, pg_namespace ns WHERE relkind IN ('r', 'm') AND c.relnamespace = ns.oid ORDER BY c.relpages DESC; SELECT pg_catalog.set_config('search_path', '', false) RESET default_statistics_target; RESET default_statistics_target; ANALYZE pg_catalog.pg_proc; ANALYZE pg_catalog.pg_depend; ANALYZE pg_catalog.pg_attribute; ANALYZE pg_catalog.pg_description; ANALYZE pg_catalog.pg_statistic; ANALYZE pg_catalog.pg_collation; ANALYZE pg_catalog.pg_operator; ANALYZE pg_catalog.pg_class; ANALYZE pg_catalog.pg_rewrite; ANALYZE pg_catalog.pg_type; ANALYZE pg_catalog.pg_amop; ANALYZE information_schema.sql_features; ANALYZE pg_catalog.pg_shdepend; ANALYZE pg_catalog.pg_amproc; ANALYZE pg_catalog.pg_opclass; ANALYZE pg_catalog.pg_index; ANALYZE pg_catalog.pg_conversion; ANALYZE pg_catalog.pg_aggregate; ANALYZE pg_catalog.pg_cast; ANALYZE pg_catalog.pg_ts_config_map; ANALYZE pg_catalog.pg_opfamily; ANALYZE pg_catalog.pg_init_privs; ANALYZE pg_catalog.pg_shdescription; ANALYZE pg_catalog.pg_ts_dict; ANALYZE pg_catalog.pg_ts_parser; ANALYZE pg_catalog.pg_ts_template; ANALYZE pg_catalog.pg_extension; ANALYZE information_schema.sql_implementation_info; ANALYZE pg_catalog.pg_am; ANALYZE pg_catalog.pg_range; ANALYZE pg_catalog.pg_language; ANALYZE information_schema.sql_packages; ANALYZE information_schema.sql_parts; ANALYZE information_schema.sql_sizing; ANALYZE information_schema.sql_languages; ANALYZE pg_catalog.pg_authid; ANALYZE pg_catalog.pg_namespace; ANALYZE pg_catalog.pg_database; ANALYZE pg_catalog.pg_constraint; ANALYZE pg_catalog.pg_tablespace; ANALYZE pg_catalog.pg_pltemplate; ANALYZE pg_catalog.pg_auth_members; ANALYZE pg_catalog.pg_ts_config; ANALYZE pg_catalog.pg_largeobject; ANALYZE pg_catalog.pg_foreign_table; ANALYZE pg_catalog.pg_user_mapping; ANALYZE pg_catalog.pg_subscription; ANALYZE pg_catalog.pg_sequence; ANALYZE pg_catalog.pg_publication; ANALYZE pg_catalog.pg_publication_rel; ANALYZE pg_catalog.pg_subscription_rel; ANALYZE pg_catalog.pg_largeobject_metadata; ANALYZE pg_catalog.pg_attrdef; ANALYZE pg_catalog.pg_inherits; ANALYZE pg_catalog.pg_statistic_ext; ANALYZE pg_catalog.pg_trigger; ANALYZE pg_catalog.pg_event_trigger; ANALYZE pg_catalog.pg_enum; ANALYZE pg_catalog.pg_db_role_setting; ANALYZE pg_catalog.pg_foreign_data_wrapper; ANALYZE pg_catalog.pg_foreign_server; ANALYZE pg_catalog.pg_policy; ANALYZE pg_catalog.pg_replication_origin; ANALYZE pg_catalog.pg_default_acl; ANALYZE pg_catalog.pg_seclabel; ANALYZE pg_catalog.pg_shseclabel; ANALYZE pg_catalog.pg_partitioned_table; ANALYZE pg_catalog.pg_transform; ANALYZE information_schema.sql_sizing_profiles; SELECT pg_catalog.set_config('search_path', '', false) vacuumdb: processing database "template1": Generating default (full) optimizer statistics SELECT c.relname, ns.nspname FROM pg_class c, pg_namespace ns WHERE relkind IN ('r', 'm') AND c.relnamespace = ns.oid ORDER BY c.relpages DESC; SELECT pg_catalog.set_config('search_path', '', false) RESET default_statistics_target; RESET default_statistics_target; ANALYZE pg_catalog.pg_proc; ANALYZE pg_catalog.pg_depend; ANALYZE pg_catalog.pg_attribute; ANALYZE pg_catalog.pg_description; ANALYZE pg_catalog.pg_statistic; ANALYZE pg_catalog.pg_collation; ANALYZE pg_catalog.pg_operator; ANALYZE pg_catalog.pg_class; ANALYZE pg_catalog.pg_rewrite; ANALYZE pg_catalog.pg_type; ANALYZE pg_catalog.pg_amop; ANALYZE information_schema.sql_features; ANALYZE pg_catalog.pg_shdepend; ANALYZE pg_catalog.pg_amproc; ANALYZE pg_catalog.pg_opclass; ANALYZE pg_catalog.pg_index; ANALYZE pg_catalog.pg_conversion; ANALYZE pg_catalog.pg_aggregate; ANALYZE pg_catalog.pg_cast; ANALYZE pg_catalog.pg_ts_config_map; ANALYZE pg_catalog.pg_opfamily; ANALYZE pg_catalog.pg_init_privs; ANALYZE pg_catalog.pg_shdescription; ANALYZE pg_catalog.pg_ts_dict; ANALYZE pg_catalog.pg_ts_parser; ANALYZE pg_catalog.pg_ts_template; ANALYZE pg_catalog.pg_extension; ANALYZE information_schema.sql_implementation_info; ANALYZE pg_catalog.pg_am; ANALYZE pg_catalog.pg_range; ANALYZE pg_catalog.pg_language; ANALYZE information_schema.sql_packages; ANALYZE information_schema.sql_parts; ANALYZE information_schema.sql_sizing; ANALYZE information_schema.sql_languages; ANALYZE pg_catalog.pg_authid; ANALYZE pg_catalog.pg_namespace; ANALYZE pg_catalog.pg_database; ANALYZE pg_catalog.pg_constraint; ANALYZE pg_catalog.pg_tablespace; ANALYZE pg_catalog.pg_pltemplate; ANALYZE pg_catalog.pg_auth_members; ANALYZE pg_catalog.pg_ts_config; ANALYZE pg_catalog.pg_largeobject; ANALYZE pg_catalog.pg_foreign_table; ANALYZE pg_catalog.pg_user_mapping; ANALYZE pg_catalog.pg_subscription; ANALYZE pg_catalog.pg_sequence; ANALYZE pg_catalog.pg_publication; ANALYZE pg_catalog.pg_publication_rel; ANALYZE pg_catalog.pg_subscription_rel; ANALYZE pg_catalog.pg_largeobject_metadata; ANALYZE pg_catalog.pg_attrdef; ANALYZE pg_catalog.pg_inherits; ANALYZE pg_catalog.pg_statistic_ext; ANALYZE pg_catalog.pg_trigger; ANALYZE pg_catalog.pg_event_trigger; ANALYZE pg_catalog.pg_enum; ANALYZE pg_catalog.pg_db_role_setting; ANALYZE pg_catalog.pg_foreign_data_wrapper; ANALYZE pg_catalog.pg_foreign_server; ANALYZE pg_catalog.pg_policy; ANALYZE pg_catalog.pg_replication_origin; ANALYZE pg_catalog.pg_default_acl; ANALYZE pg_catalog.pg_seclabel; ANALYZE pg_catalog.pg_shseclabel; ANALYZE pg_catalog.pg_partitioned_table; ANALYZE pg_catalog.pg_transform; ANALYZE information_schema.sql_sizing_profiles;
Related issues
Fix #5456 (closed)
Help #5363 (closed)
Checklist
See Definition of done.
-
Changelog entry created. Not applicable for Documentation changes and minor changes. - [-] Documentation created/updated
-
Tests added -
Integration tests added to GitLab QA, if applicable -
MR targeting master
branch -
MR has a green pipeline on GitLab.com -
Equivalent MR/issue for CNG opened if applicable -
trigger-package
has a green pipeline running against latest commit
Reviewer Checklist
In addition to above, reviewer must:
-
Pipeline is green on dev.gitlab.org if the change is not touching documentation or internal cookbooks