Run vacuumdb with 2 commands simultaneously (!4373) · Merge requests · GitLab.org / omnibus-gitlab

Ben Bodenmiller requested to merge patch-9 into master Jun 30, 2020

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

Edited Jul 02, 2020 by DJ Mountney

Run vacuumdb with 2 commands simultaneously

What does this MR do?

Related issues

Checklist

Reviewer Checklist

Merge request reports