Decrease bloated Indexes using pg_repack
C1
Production Change - Criticality 1Change Objective | Describe the objective of the change |
---|---|
Change Type | Operation |
Services Impacted | ~"Service:Postgres" |
Change Team Members | @sergio.ostapowicz |
Change Severity | C1 |
Change Reviewer | @gerardo.herzig |
Tested in staging | None |
Dry-run output | |
Due Date | Milestone in GL issue |
Time tracking | ~30hs |
Downtime Component | No Downtime |
Summary
A high Index bloat level was reported at gitlab issue, requiring a maintenance work for removing bloated blocks from the corresponding list of indexes.
Requirements
On the patroni leader, install RVM (for a local user, not root) and setup gitlab-pgrepack
project
- Clone gitalb-pgrepack project into home directory
- Download the keys and install
RVM
gpg --keyserver hkp://pool.sks-keyservers.net --recv-keys 409B6B1796C275462A1703113804BB82D39DC0E3 7D2BAF1CF37B13E2069D6956105BD0E739499BDB
\curl -sSL https://get.rvm.io | bash -s stable --ruby
- Run RVM
source /home/user/.rvm/scripts/rvm
- Install dependencies for the environment
bundle install
- Edit the configuration file in
config/gitlab-repack.yml
general: env: local database: adapter: postgresql host: [PostgreSQL Master server] user: gitlab-superuser password: ------- database: gitlabhq_production estimate: ratio_threshold: 0 # bloat ratio threshold in % (set to 0 for testing) real_size_threshold: 0 # real size of object in bytes (set to 0 for testing) objects_per_repack: 1 repack: - command: PGPASSWORD=---- /usr/lib/postgresql/9.6/bin/pg_repack -h [PostgreSQL Master server] -p 5432 -U gitlab-superuser -d gitlabhq_production --no-kill-backend # Optional: Grafana annotations grafana: auth_key: false # put API key here to enable base_url: https://dashboards.gitlab.net
Plan
This maintenance is going to run for a maximum of 3 hours and we will run one maintenance task per day/index. The task will be performed in the Master PostgreSQL Server.
Any scripts should be run in a
tmux
session on the patroni leader.
- Run
gitlab-pgrepack estimate
to generate list of relevant objects for repacking. - Get and backup the current
max_wal_size
andmaintenance_work_mem
value to be restored after the repack operation.sudo gitlab-psql -c 'SHOW max_wal_size' -o /var/tmp/max_wal_size.ori
sudo gitlab-psql -c 'SHOW maintenance_work_mem' -o /var/tmp/maintenance_work_mem.ori
- Change
max_wal_size
andmaintenance_work_mem
to temporal sizes.ALTER SYSTEM SET max_wal_size TO '30GB'; SELECT pg_reload_conf();
ALTER SYSTEM SET maintenance_work_mem TO '20GB'; SELECT pg_reload_conf();
- Repack indexes:
- Start with repacking a single index and check the repacking is reflected in Grafana.
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_repository_storage
- Start with repacking a single index and check the repacking is reflected in Grafana.
- Restore
max_wal_size
andmaintenance_work_mem
to original value. - Monitor the replication lag with the Graphana Panel
Initial Index List to rebuild:
Click me to collapse/fold Index List.
These details will remain hidden until expanded.
INDEX bloat:
563.65 GiB of bloat (40.4 % ratio of total size)
Recommended repacking for index bloat:
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_commit_id_and_type_and_name_and_ref
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_commit_id_and_type_and_ref
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_auto_canceled_by_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_token
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_diff_commits_on_sha
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_protected
gitlab-pgrepack repack --type=btrees --objects=public.tmp_build_stage_position_index
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_runner_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_commit_id_and_stage_idx_and_created_at
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_queued_at
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_commit_id_and_status_and_type
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_updated_at
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_job_artifacts_on_expire_at_and_job_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_token_encrypted
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_project_id_and_id
gitlab-pgrepack repack --type=btrees --objects=public.ci_builds_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_build_trace_sections_on_build_id_and_section_name_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_build_trace_sections_on_section_name_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_diff_files_on_mr_diff_id_and_order
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_stage_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_build_trace_sections_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_repository_storage
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_diff_commits_on_mr_diff_id_and_order
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_status_and_type_and_runner_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_job_artifacts_on_job_id_and_file_type
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_last_activity_at
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_runners_token
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_pending_delete
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_last_repository_check_failed
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_mirror_last_successful_update_at
gitlab-pgrepack repack --type=btrees --objects=public.taggings_idx
gitlab-pgrepack repack --type=btrees --objects=public.ci_job_artifacts_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_milestone_id
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_star_count
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_auto_canceled_by_id
gitlab-pgrepack repack --type=btrees --objects=public.index_events_on_project_id_and_created_at
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_assignee_id
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_last_repository_updated_at
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_target_branch
gitlab-pgrepack repack --type=btrees --objects=public.index_events_on_target_type_and_target_id
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_mirror_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_job_artifacts_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_head_pipeline_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_pipeline_schedule_id
gitlab-pgrepack repack --type=btrees --objects=public.index_notes_on_discussion_id
gitlab-pgrepack repack --type=btrees --objects=public.index_notes_on_review_id
gitlab-pgrepack repack --type=btrees --objects=public.index_notes_on_project_id_and_noteable_type
gitlab-pgrepack repack --type=btrees --objects=public.index_notes_on_noteable_id_and_noteable_type
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_latest_merge_request_diff_id
gitlab-pgrepack repack --type=btrees --objects=public.index_notes_on_line_code
gitlab-pgrepack repack --type=btrees --objects=public.index_project_mirror_data_on_status
gitlab-pgrepack repack --type=btrees --objects=public.index_notes_on_commit_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_project_id_and_sha
gitlab-pgrepack repack --type=btrees --objects=public.index_events_on_author_id_and_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_created_at
gitlab-pgrepack repack --type=btrees --objects=public.ci_builds_gitlab_monitor_metrics
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_group_view
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_ghost
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_managing_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_admin
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_state
gitlab-pgrepack repack --type=btrees --objects=public.users_reset_password_token_key
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_job_artifacts_on_file_store
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_accepted_term_id
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_bot_type
gitlab-pgrepack repack --type=btrees --objects=public.index_events_on_project_id_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_project_id_and_ref_and_status_and_id
gitlab-pgrepack repack --type=btrees --objects=public.ci_pipelines_pkey
gitlab-pgrepack repack --type=btrees --objects=public.merge_requests_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_tp_id_and_merge_commit_sha_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_notes_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_state
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_confidential
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_project_idandrefandiddesc
gitlab-pgrepack repack --type=btrees --objects=public.index_sent_notifications_on_reply_key
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_metadata_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_events_on_action
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_deployable_type_and_deployable_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_source_project_id_and_source_branch
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_source_branch
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_closed_by_id
gitlab-pgrepack repack --type=btrees --objects=public.index_audit_events_on_entity_id_and_entity_type
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_project_id_and_updated_at_and_id_and_state
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_milestone_id
gitlab-pgrepack repack --type=btrees --objects=public.index_taggings_on_taggable_id_and_taggable_type
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_runners_token_encrypted
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_title
gitlab-pgrepack repack --type=btrees --objects=public.index_mirror_data_on_next_execution_and_retry_count
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_stages_on_pipeline_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_project_id_and_created_at_and_id_and_state
gitlab-pgrepack repack --type=btrees --objects=public.ci_builds_metadata_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_metadata_on_build_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_project_id_and_status_and_config_source
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_updated_at
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_metrics_on_first_deployed_to_production_at
gitlab-pgrepack repack --type=btrees --objects=public.index_project_mirror_data_on_last_update_at_and_retry_count
gitlab-pgrepack repack --type=btrees --objects=public.idx_project_repository_check_partial
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_metrics_on_latest_closed_by_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_mirror_data_on_jid
gitlab-pgrepack repack --type=btrees --objects=public.index_notes_on_created_at
gitlab-pgrepack repack --type=btrees --objects=public.idx_projects_on_repository_storage_last_repository_updated_at
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_status
gitlab-pgrepack repack --type=btrees --objects=public.index_resource_label_events_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runners_on_is_shared
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_project_id_and_source
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runners_on_locked
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runners_on_runner_type
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_state_and_internal
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_state_and_internal_ee
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_metrics_on_pipeline_id
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_created_at
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_stages_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_project_id_and_iid
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runners_on_contacted_at
gitlab-pgrepack repack --type=btrees --objects=public.index_resource_label_events_on_epic_id
gitlab-pgrepack repack --type=btrees --objects=public.index_todos_on_commit_id
gitlab-pgrepack repack --type=btrees --objects=public.index_todos_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipeline_variables_on_pipeline_id_and_key
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_mirror_data_on_last_successful_update_at
gitlab-pgrepack repack --type=btrees --objects=public.index_project_authorizations_on_user_id_project_id_access_level
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runners_on_token
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_stages_on_pipeline_id_and_position
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_static_object_token
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_environment_id_and_iid_and_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_todos_on_note_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_stages_on_pipeline_id
gitlab-pgrepack repack --type=btrees --objects=public.deployments_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_project_id_and_status_and_created_at
gitlab-pgrepack repack --type=btrees --objects=public.users_confirmation_token_key
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_metrics_on_merged_by_id
gitlab-pgrepack repack --type=btrees --objects=public.index_internal_ids_on_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.index_todos_on_target_type_and_target_id
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_cluster_id_and_status
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_target_project_id_and_iid
gitlab-pgrepack repack --type=btrees --objects=public.index_project_repositories_on_disk_path
gitlab-pgrepack repack --type=btrees --objects=public.index_uploads_on_uploader_and_path
gitlab-pgrepack repack --type=btrees --objects=public.todos_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_project_id_and_iid
gitlab-pgrepack repack --type=btrees --objects=public.index_web_hook_logs_on_web_hook_id
gitlab-pgrepack repack --type=btrees --objects=public.issues_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_environment_id_and_id
gitlab-pgrepack repack --type=btrees --objects=public.ci_stages_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_taggings_on_tag_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_state_and_merge_status
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_relative_position
gitlab-pgrepack repack --type=btrees --objects=public.merge_request_metrics_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_project_mirror_data_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.project_mirror_data_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_lfs_objects_on_oid
gitlab-pgrepack repack --type=btrees --objects=public.index_notes_on_project_id_and_id_and_system_false
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_metrics
gitlab-pgrepack repack --type=btrees --objects=public.project_ci_cd_settings_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_project_ci_cd_settings_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_authorizations_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_label_links_on_target_id_and_target_type
gitlab-pgrepack repack --type=btrees --objects=public.project_statistics_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.analytics_index_events_on_created_at_and_author_id
gitlab-pgrepack repack --type=btrees --objects=public.protected_branches_pkey
gitlab-pgrepack repack --type=btrees --objects=public.ci_pipeline_variables_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_diffs_on_merge_request_id_and_id_partial
gitlab-pgrepack repack --type=btrees --objects=public.index_on_routes_lower_path
gitlab-pgrepack repack --type=btrees --objects=public.index_routes_on_path
gitlab-pgrepack repack --type=btrees --objects=public.index_routes_on_path_text_pattern_ops
gitlab-pgrepack repack --type=btrees --objects=public.notes_pkey
gitlab-pgrepack repack --type=btrees --objects=public.events_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_project_statistics_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branches_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_project_id_and_iid
gitlab-pgrepack repack --type=btrees --objects=public.index_resource_label_events_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_resource_label_events_on_issue_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_target_project_id_created_at
gitlab-pgrepack repack --type=btrees --objects=public.index_resource_label_events_on_label_id
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_project_id_and_rel_position_and_state_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_todos_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_environment_id_and_status
gitlab-pgrepack repack --type=btrees --objects=public.index_on_projects_lower_path
gitlab-pgrepack repack --type=btrees --objects=public.index_todos_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_project_id_and_status
gitlab-pgrepack repack --type=btrees --objects=public.index_todos_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.routes_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_on_projects_path
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_name_and_parent_id
gitlab-pgrepack repack --type=btrees --objects=public.idx_issues_on_state_id
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_visibility_level_and_created_at_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_taggings_on_taggable_id_and_taggable_type_and_context
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_diffs_on_merge_request_id_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_todos_on_user_id_and_id_done
gitlab-pgrepack repack --type=btrees --objects=public.resource_label_events_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_routes_on_source_type_and_source_id
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_file_template_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_owner_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_statistics_on_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_feed_token
gitlab-pgrepack repack --type=btrees --objects=public.vulnerability_occurrence_pipelines_on_unique_keys
gitlab-pgrepack repack --type=btrees --objects=public.index_push_event_payloads_on_event_id
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_created_at
gitlab-pgrepack repack --type=btrees --objects=public.index_members_on_requested_at
gitlab-pgrepack repack --type=btrees --objects=public.index_project_pages_metadata_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.merge_request_diffs_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_project_id_and_status_for_live_jobs_partial2
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_parent_id_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_source_project_and_branch_state_opened
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_project_id_and_status_and_updated_at
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_lower_name
gitlab-pgrepack repack --type=btrees --objects=public.idx_issues_on_project_id_and_created_at_and_id_and_state_id
gitlab-pgrepack repack --type=btrees --objects=public.index_notifications_on_user_id_and_source_id_and_source_type
gitlab-pgrepack repack --type=btrees --objects=public.index_issue_metrics_on_issue_id_and_timestamps
gitlab-pgrepack repack --type=btrees --objects=public.idx_issues_on_project_id_and_updated_at_and_id_and_state_id
gitlab-pgrepack repack --type=btrees --objects=public.idx_merge_requests_on_state_id_and_merge_status
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_updated_by_id
gitlab-pgrepack repack --type=btrees --objects=public.idx_issues_on_project_id_and_rel_position_and_state_id_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_lists_on_board_id_and_label_id
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_runners_token_encrypted
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_ldap_sync_last_successful_update_at
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_ldap_sync_last_update_at
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_require_two_factor_authentication
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_shared_and_extra_runners_minutes_limit
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_runners_token
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_plan_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_daily_statistics_on_project_id_and_date
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_creator_id
gitlab-pgrepack repack --type=btrees --objects=public.approval_merge_request_rules_pkey
gitlab-pgrepack repack --type=btrees --objects=public.label_links_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_on_namespaces_lower_name
gitlab-pgrepack repack --type=btrees --objects=public.index_user_interacted_projects_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_signatures_on_gpg_key_subkey_id
gitlab-pgrepack repack --type=btrees --objects=public.index_oauth_access_tokens_on_refresh_token
gitlab-pgrepack repack --type=btrees --objects=public.index_label_links_on_label_id
gitlab-pgrepack repack --type=btrees --objects=public.projects_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_uploads_on_checksum
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.index_members_on_expires_at
gitlab-pgrepack repack --type=btrees --objects=public.lfs_objects_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_occurrence_pipelines_on_pipeline_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branch_push_access_levels_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branch_merge_access_levels_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_labels_on_group_id_and_project_id_and_title
gitlab-pgrepack repack --type=btrees --objects=public.index_labels_on_type_and_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branch_push_access_levels_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branch_merge_access_levels_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runners_on_token_encrypted
gitlab-pgrepack repack --type=btrees --objects=public.index_members_on_invite_token
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_created_at_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_oauth_access_tokens_on_token
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_incoming_email_token
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_commit_id_and_artifacts_expireatandidpartial
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_name_for_security_products_values
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_assignees_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_members_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_lists_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.lists_pkey
gitlab-pgrepack repack --type=btrees --objects=public.project_features_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_metrics_on_merge_request_id_and_merged_at
gitlab-pgrepack repack --type=btrees --objects=public.index_lists_on_milestone_id
gitlab-pgrepack repack --type=btrees --objects=public.users_email_key
gitlab-pgrepack repack --type=btrees --objects=public.project_daily_statistics_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_services_on_type
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_assignees_on_merge_request_id_and_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_notification_settings_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_created_at
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_updated_by_id
gitlab-pgrepack repack --type=btrees --objects=public.index_lists_on_label_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_features_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.namespaces_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_deployments_on_project_id_and_updated_at
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_metrics_on_merged_at
gitlab-pgrepack repack --type=btrees --objects=public.system_note_metadata_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_system_note_metadata_on_note_id
gitlab-pgrepack repack --type=btrees --objects=public.taggings_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_members_on_invite_email
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_target_project_id_and_iid_opened
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_merge_request_rules_users_1
gitlab-pgrepack repack --type=btrees --objects=public.users_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_on_users_name_lower
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_signatures_on_gpg_key_primary_keyid
gitlab-pgrepack repack --type=btrees --objects=public.index_personal_access_tokens_on_token_digest
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_name
gitlab-pgrepack repack --type=btrees --objects=public.index_keys_on_fingerprint
gitlab-pgrepack repack --type=btrees --objects=public.index_notification_settings_on_source_id_and_source_type
gitlab-pgrepack repack --type=btrees --objects=public.idx_merge_requests_on_source_project_and_branch_state_opened
gitlab-pgrepack repack --type=btrees --objects=public.index_lists_on_list_type
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_signatures_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_lfs_objects_projects_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_members_on_source_id_and_source_type
gitlab-pgrepack repack --type=btrees --objects=public.index_members_on_access_level
gitlab-pgrepack repack --type=btrees --objects=public.services_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_lfs_objects_projects_on_lfs_object_id
gitlab-pgrepack repack --type=btrees --objects=public.index_repository_languages_on_project_and_languages_id
gitlab-pgrepack repack --type=btrees --objects=public.index_on_users_lower_email
gitlab-pgrepack repack --type=btrees --objects=public.index_todos_on_user_id_and_id_pending
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_trigger_requests_on_commit_id
gitlab-pgrepack repack --type=btrees --objects=public.user_preferences_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_uploads_on_model_id_and_model_type
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_artifacts_expire_at
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_signatures_on_gpg_key_id
gitlab-pgrepack repack --type=btrees --objects=public.internal_ids_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_assignees_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_on_namespaces_lower_path
gitlab-pgrepack repack --type=btrees --objects=public.index_internal_ids_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_path
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_merge_request_rules_users_2
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_build_trace_section_names_on_project_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.index_issue_assignees_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_merge_request_rules_1
gitlab-pgrepack repack --type=btrees --objects=public.index_uploads_on_store
gitlab-pgrepack repack --type=btrees --objects=public.index_services_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_lfs_objects_on_file_store
gitlab-pgrepack repack --type=btrees --objects=public.index_on_users_lower_username
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_username
gitlab-pgrepack repack --type=btrees --objects=public.ci_trigger_requests_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_user_preferences_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_web_hook_logs_on_created_at_and_web_hook_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.merge_requests_closing_issues_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_services_on_template
gitlab-pgrepack repack --type=btrees --objects=public.index_user_interacted_projects_on_project_id_and_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_labels_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_build_needs_on_build_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_signatures_on_commit_sha
gitlab-pgrepack repack --type=btrees --objects=public.idx_issues_on_project_id_and_due_date_and_id_and_state_partial
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_variables_on_project_id_and_key_and_environment_scope
gitlab-pgrepack repack --type=btrees --objects=public.index_issue_assignees_on_issue_id_and_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_issue_metrics
gitlab-pgrepack repack --type=btrees --objects=public.lfs_objects_projects_pkey
gitlab-pgrepack repack --type=btrees --objects=public.members_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_project_repositories_on_shard_id
gitlab-pgrepack repack --type=btrees --objects=public.index_remote_mirrors_on_last_successful_update_at
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_id_partial_for_visibility
gitlab-pgrepack repack --type=btrees --objects=public.issue_metrics_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_keys_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.web_hook_logs_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_on_identities_lower_extern_uid_and_provider
gitlab-pgrepack repack --type=btrees --objects=public.uploads_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_internal_ids_on_usage_and_project_id
gitlab-pgrepack repack --type=btrees --objects=public.protected_branch_push_access_levels_pkey
gitlab-pgrepack repack --type=btrees --objects=public.protected_branch_merge_access_levels_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branch_merge_access
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branch_push_access
gitlab-pgrepack repack --type=btrees --objects=public.ci_runners_pkey
gitlab-pgrepack repack --type=btrees --objects=public.idx_merge_requests_on_target_project_id_and_iid_opened
gitlab-pgrepack repack --type=btrees --objects=public.index_web_hooks_on_type
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_occurrences_on_unique_keys
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_merge_user_id
gitlab-pgrepack repack --type=btrees --objects=public.project_repositories_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_user_agent_details_on_subject_id_and_subject_type
gitlab-pgrepack repack --type=btrees --objects=public.notification_settings_pkey
gitlab-pgrepack repack --type=btrees --objects=public.ci_variables_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_approvers_on_target_id_and_target_type
gitlab-pgrepack repack --type=btrees --objects=public.index_oauth_access_grants_on_token
gitlab-pgrepack repack --type=btrees --objects=public.index_award_emoji_on_user_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.index_index_statuses_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_releases_on_project_id_and_tag
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipeline_schedules_on_next_run_at_and_active
gitlab-pgrepack repack --type=btrees --objects=public.index_approvals_on_user_id_and_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_award_emoji_on_awardable_type_and_awardable_id
gitlab-pgrepack repack --type=btrees --objects=public.index_oauth_access_tokens_on_resource_owner_id
gitlab-pgrepack repack --type=btrees --objects=public.index_timelogs_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.releases_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_boards_on_milestone_id
gitlab-pgrepack repack --type=btrees --objects=public.index_gitlab_subscriptions_on_hosted_plan_id
gitlab-pgrepack repack --type=btrees --objects=public.index_boards_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_repositories_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_closing_issues_on_issue_id
gitlab-pgrepack repack --type=btrees --objects=public.index_statuses_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_term_agreements_on_term_id
gitlab-pgrepack repack --type=btrees --objects=public.ci_runner_projects_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_environments_on_name_varchar_pattern_ops
gitlab-pgrepack repack --type=btrees --objects=public.index_releases_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.gpg_signatures_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_closing_issues_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_occurrences_on_uuid
gitlab-pgrepack repack --type=btrees --objects=public.web_hooks_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_environments_on_project_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.index_personal_access_tokens_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_approvals_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_environments_on_project_id_and_slug
gitlab-pgrepack repack --type=btrees --objects=public.ci_build_trace_chunks_pkey
gitlab-pgrepack repack --type=btrees --objects=public.user_agent_details_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_labels_on_title
gitlab-pgrepack repack --type=btrees --objects=public.ci_build_trace_section_names_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_redirect_routes_on_path
gitlab-pgrepack repack --type=btrees --objects=public.keys_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_redirect_routes_on_path_unique_text_pattern_ops
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_metrics_on_latest_closed_at
gitlab-pgrepack repack --type=btrees --objects=public.index_packages_package_files_on_package_id_and_file_name
gitlab-pgrepack repack --type=btrees --objects=public.labels_pkey
gitlab-pgrepack repack --type=btrees --objects=public.idx_repository_states_on_last_repository_verification_ran_at
gitlab-pgrepack repack --type=btrees --objects=public.merge_request_assignees_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_milestones_on_title
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runner_projects_on_runner_id
gitlab-pgrepack repack --type=btrees --objects=public.namespace_aggregation_schedules_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_namespace_aggregation_schedules_on_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.index_redirect_routes_on_source_type_and_source_id
gitlab-pgrepack repack --type=btrees --objects=public.index_milestones_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_note_diff_files_on_diff_note_id
gitlab-pgrepack repack --type=btrees --objects=public.namespace_root_storage_statistics_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_namespace_root_storage_statistics_on_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_type_partial
gitlab-pgrepack repack --type=btrees --objects=public.idx_proj_feat_usg_on_jira_dvcs_server_last_sync_at_and_proj_id
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_merge_request_rule_sources_2
gitlab-pgrepack repack --type=btrees --objects=public.redirect_routes_pkey
gitlab-pgrepack repack --type=btrees --objects=public.namespace_statistics_pkey
gitlab-pgrepack repack --type=btrees --objects=public.note_diff_files_pkey
gitlab-pgrepack repack --type=btrees --objects=public.approvals_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_occurrences_on_primary_identifier_id
gitlab-pgrepack repack --type=btrees --objects=public.deploy_keys_projects_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_container_repositories_on_project_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_occurrences_on_scanner_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_build_trace_chunks_on_build_id_and_chunk_index
gitlab-pgrepack repack --type=btrees --objects=public.index_timelogs_on_issue_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_trigger_requests_on_trigger_id_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_feature_usages_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.project_feature_usages_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_id_and_merge_jid
gitlab-pgrepack repack --type=btrees --objects=public.index_deploy_keys_projects_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.idx_merge_requests_on_id_and_merge_jid
gitlab-pgrepack repack --type=btrees --objects=public.idx_issues_on_project_id_and_due_date_and_id_and_state_id
gitlab-pgrepack repack --type=btrees --objects=public.project_import_data_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_merge_request_rules_approved_approvers_2
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_merge_request_rules_approved_approvers_1
gitlab-pgrepack repack --type=btrees --objects=public.index_timelogs_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_boards_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.idx_repository_states_on_last_wiki_verification_ran_at
gitlab-pgrepack repack --type=btrees --objects=public.index_deploy_tokens_on_token_and_expires_at_and_id
gitlab-pgrepack repack --type=btrees --objects=public.environments_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_occurrence_identifiers_on_identifier_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_job_artifacts_on_project_id_for_security_reports
gitlab-pgrepack repack --type=btrees --objects=public.push_rules_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_term_agreements_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.term_agreements_unique_index
gitlab-pgrepack repack --type=btrees --objects=public.index_snippets_on_project_id_and_visibility_level
gitlab-pgrepack repack --type=btrees --objects=public.index_project_import_data_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_on_project_id_for_successfull_pages_deploy
gitlab-pgrepack repack --type=btrees --objects=public.index_push_rules_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_namespace_statistics_on_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.index_oauth_access_tokens_on_application_id
gitlab-pgrepack repack --type=btrees --objects=public.vulnerability_occurrences_pkey
gitlab-pgrepack repack --type=btrees --objects=public.approval_merge_request_rules_users_pkey
gitlab-pgrepack repack --type=btrees --objects=public.oauth_access_tokens_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_sources_pipelines_on_source_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_sources_pipelines_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.idx_repository_states_outdated_checksums
gitlab-pgrepack repack --type=btrees --objects=public.index_deploy_tokens_on_token
gitlab-pgrepack repack --type=btrees --objects=public.index_snippets_on_updated_at
gitlab-pgrepack repack --type=btrees --objects=public.index_web_hooks_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.project_group_links_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_subscriptions_on_subscribable_and_user_id_and_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_milestones_on_project_id_and_iid
gitlab-pgrepack repack --type=btrees --objects=public.index_milestones_on_due_date
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_identifiers_on_project_id_and_fingerprint
gitlab-pgrepack repack --type=btrees --objects=public.snippets_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_pages_domains_on_verified_at_and_enabled_until
gitlab-pgrepack repack --type=btrees --objects=public.pages_domains_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_project_repository_states_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.project_repository_states_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_import_export_uploads_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_container_repositories_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.import_export_uploads_pkey
gitlab-pgrepack repack --type=btrees --objects=public.oauth_access_grants_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_import_export_uploads_on_updated_at
gitlab-pgrepack repack --type=btrees --objects=public.ci_runner_namespaces_pkey
gitlab-pgrepack repack --type=btrees --objects=public.container_repositories_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_pages_domains_on_project_id_and_enabled_until
gitlab-pgrepack repack --type=btrees --objects=public.index_fork_network_members_on_fork_network_id
gitlab-pgrepack repack --type=btrees --objects=public.any_approver_merge_request_rule_type_unique_index
gitlab-pgrepack repack --type=btrees --objects=public.index_fork_network_members_on_forked_from_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runner_projects_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.deploy_tokens_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_pages_domains_on_verified_at
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_merge_request_rules_groups_2
gitlab-pgrepack repack --type=btrees --objects=public.index_pages_domains_on_domain
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runner_namespaces_on_runner_id_and_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.ci_build_needs_pkey
gitlab-pgrepack repack --type=btrees --objects=public.project_auto_devops_pkey
gitlab-pgrepack repack --type=btrees --objects=public.boards_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_snippets_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_public_email
gitlab-pgrepack repack --type=btrees --objects=public.index_deploy_tokens_on_token_encrypted
gitlab-pgrepack repack --type=btrees --objects=public.users_star_projects_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_group_variables_on_group_id_and_key
gitlab-pgrepack repack --type=btrees --objects=public.index_fork_network_members_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_pages_domains_on_remove_at
gitlab-pgrepack repack --type=btrees --objects=public.index_user_callouts_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_occurrences_on_vulnerability_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_auto_devops_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_user_callouts_on_user_id_and_feature_name
gitlab-pgrepack repack --type=btrees --objects=public.index_pages_domains_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_gitlab_subscriptions_on_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.fork_network_members_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_moved_to_id
gitlab-pgrepack repack --type=btrees --objects=public.approval_rule_name_index_for_code_owners
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_mirror_and_mirror_trigger_builds_both_true
gitlab-pgrepack repack --type=btrees --objects=public.index_users_star_projects_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_emails_on_confirmation_token
gitlab-pgrepack repack --type=btrees --objects=public.index_users_star_projects_on_user_id_and_project_id
gitlab-pgrepack repack --type=btrees --objects=public.idx_proj_feat_usg_on_jira_dvcs_cloud_last_sync_at_and_proj_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipeline_schedules_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.ci_pipeline_schedules_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipeline_schedules_on_owner_id
gitlab-pgrepack repack --type=btrees --objects=public.index_approver_groups_on_target_id_and_target_type
gitlab-pgrepack repack --type=btrees --objects=public.timelogs_pkey
gitlab-pgrepack repack --type=btrees --objects=public.approval_project_rules_pkey
gitlab-pgrepack repack --type=btrees --objects=public.emails_email_key
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branch_unprotect_access_levels_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branch_unprotect_access_levels_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_issue_links_on_target_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_branch_unprotect_access
gitlab-pgrepack repack --type=btrees --objects=public.protected_branch_unprotect_access_levels_pkey
gitlab-pgrepack repack --type=btrees --objects=public.ci_group_variables_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_issue_links_on_source_id
gitlab-pgrepack repack --type=btrees --objects=public.idx_deployment_merge_requests_unique_index
gitlab-pgrepack repack --type=btrees --objects=public.index_issue_links_on_source_id_and_target_id
gitlab-pgrepack repack --type=btrees --objects=public.remote_mirrors_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_sources_pipelines_on_source_pipeline_id
gitlab-pgrepack repack --type=btrees --objects=public.approval_merge_request_rule_sources_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_merge_request_rule_sources_1
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_sources_pipelines_on_source_job_id
gitlab-pgrepack repack --type=btrees --objects=public.index_environments_on_project_id_state_environment_type
gitlab-pgrepack repack --type=btrees --objects=public.index_subscriptions_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.award_emoji_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_deployment_merge_requests_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_on_enabled
gitlab-pgrepack repack --type=btrees --objects=public.index_approver_groups_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_pages_metadata_on_project_id_and_deployed_is_true
gitlab-pgrepack repack --type=btrees --objects=public.index_remote_mirrors_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.subscriptions_pkey
gitlab-pgrepack repack --type=btrees --objects=public.identities_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_occurrence_identifiers_on_unique_keys
gitlab-pgrepack repack --type=btrees --objects=public.milestones_pkey
gitlab-pgrepack repack --type=btrees --objects=public.kubernetes_namespaces_cluster_and_namespace
gitlab-pgrepack repack --type=btrees --objects=public.index_milestone
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_rule_name_for_code_owners_rule_type
gitlab-pgrepack repack --type=btrees --objects=public.forked_project_links_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_fork_networks_on_root_project_id
gitlab-pgrepack repack --type=btrees --objects=public.gitlab_subscriptions_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_tags_on_name
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_kubernetes_namespaces_on_cluster_project_id
gitlab-pgrepack repack --type=btrees --objects=public.term_agreements_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_label_priorities_on_priority
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_closed_by_id
gitlab-pgrepack repack --type=btrees --objects=public.suggestions_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_project_rules_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_assignee_id
gitlab-pgrepack repack --type=btrees --objects=public.label_priorities_pkey
gitlab-pgrepack repack --type=btrees --objects=public.emails_pkey
gitlab-pgrepack repack --type=btrees --objects=public.packages_package_files_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_project_group_links_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_board_project_recent_visits_on_user_project_and_board
gitlab-pgrepack repack --type=btrees --objects=public.index_projects_on_pool_repository_id
gitlab-pgrepack repack --type=btrees --objects=public.index_reviews_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.clusters_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_reviews_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.vulnerability_occurrence_identifiers_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_project_rules_users_2
gitlab-pgrepack repack --type=btrees --objects=public.index_list_user_preferences_on_user_id_and_list_id
gitlab-pgrepack repack --type=btrees --objects=public.index_project_group_links_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipelines_on_external_pull_request_id
gitlab-pgrepack repack --type=btrees --objects=public.forked_project_links_forked_to_project_id_key
gitlab-pgrepack repack --type=btrees --objects=public.index_reviews_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_parent_id
gitlab-pgrepack repack --type=btrees --objects=public.index_oauth_applications_on_uid
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_project_rules_users_1
gitlab-pgrepack repack --type=btrees --objects=public.index_badges_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_runner_namespaces_on_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.index_suggestions_on_note_id_and_relative_order
gitlab-pgrepack repack --type=btrees --objects=public.index_board_project_recent_visits_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_emails_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_users_on_unconfirmed_email
gitlab-pgrepack repack --type=btrees --objects=public.issue_links_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_feature_flags_clients_on_project_id_and_token_encrypted
gitlab-pgrepack repack --type=btrees --objects=public.index_board_project_recent_visits_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_metadata_on_build_id_and_interruptible
gitlab-pgrepack repack --type=btrees --objects=public.index_list_user_preferences_on_list_id
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_rules_code_owners_rule_type
gitlab-pgrepack repack --type=btrees --objects=public.index_list_user_preferences_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_board_project_recent_visits_on_board_id
gitlab-pgrepack repack --type=btrees --objects=public.approval_project_rules_users_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_operations_feature_flags_clients_on_project_id_and_token
gitlab-pgrepack repack --type=btrees --objects=public.spam_logs_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_project_rules_on_rule_type
gitlab-pgrepack repack --type=btrees --objects=public.index_label_priorities_on_project_id_and_label_id
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_end_date
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_requests_on_target_project_id_and_target_branch
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_start_date
gitlab-pgrepack repack --type=btrees --objects=public.board_project_recent_visits_pkey
gitlab-pgrepack repack --type=btrees --objects=public.clusters_kubernetes_namespaces_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_user_statuses_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_lfs_file_locks_on_project_id_and_path
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_trial_ends_on
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_draft_notes_on_discussion_id
gitlab-pgrepack repack --type=btrees --objects=public.index_release_links_on_release_id_and_url
gitlab-pgrepack repack --type=btrees --objects=public.vulnerability_identifiers_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_kubernetes_namespaces_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_triggers_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_u2f_registrations_on_key_handle
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_tag_create_access_levels_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.user_statuses_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_merge_request_rules_groups_1
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_kubernetes_namespaces_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.draft_notes_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_key_subkeys_on_fingerprint
gitlab-pgrepack repack --type=btrees --objects=public.personal_access_tokens_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_slack_integrations_on_team_id_and_alias
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipeline_schedule_variables_on_schedule_id_and_key
gitlab-pgrepack repack --type=btrees --objects=public.index_epic_issues_on_issue_id
gitlab-pgrepack repack --type=btrees --objects=public.list_user_preferences_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_board_group_recent_visits_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.epics_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_cluster_providers_gcp_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_keys_on_fingerprint
gitlab-pgrepack repack --type=btrees --objects=public.index_project_deploy_tokens_on_project_id_and_deploy_token_id
gitlab-pgrepack repack --type=btrees --objects=public.cluster_providers_gcp_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_packages_maven_metadata_on_package_id_and_path
gitlab-pgrepack repack --type=btrees --objects=public.index_pool_repositories_on_disk_path
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_tag_create_access_levels_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.tags_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_external_pull_requests_on_project_and_branches
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_key_subkeys_on_keyid
gitlab-pgrepack repack --type=btrees --objects=public.oauth_applications_pkey
gitlab-pgrepack repack --type=btrees --objects=public.operations_feature_flags_clients_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_pages_domains_need_auto_ssl_renewal
gitlab-pgrepack repack --type=btrees --objects=public.any_approver_project_rule_type_unique_index
gitlab-pgrepack repack --type=btrees --objects=public.index_draft_notes_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_packages_packages_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.ci_pipeline_schedule_variables_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_triggers_on_owner_id
gitlab-pgrepack repack --type=btrees --objects=public.approval_merge_request_rules_groups_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_kubernetes_namespaces_on_environment_id
gitlab-pgrepack repack --type=btrees --objects=public.cluster_projects_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_epic_issues_on_epic_id
gitlab-pgrepack repack --type=btrees --objects=public.cluster_platforms_kubernetes_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_identities_on_saml_provider_id
gitlab-pgrepack repack --type=btrees --objects=public.index_board_group_recent_visits_on_user_group_and_board
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_applications_runners_on_runner_id
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_iid
gitlab-pgrepack repack --type=btrees --objects=public.index_oauth_applications_on_owner_id_and_owner_type
gitlab-pgrepack repack --type=btrees --objects=public.badges_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_cluster_platforms_kubernetes_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.approver_groups_pkey
gitlab-pgrepack repack --type=btrees --objects=public.gpg_key_subkeys_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_key_subkeys_on_gpg_key_id
gitlab-pgrepack repack --type=btrees --objects=public.index_label_priorities_on_label_id
gitlab-pgrepack repack --type=btrees --objects=public.ci_sources_pipelines_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_sources_pipelines_on_pipeline_id
gitlab-pgrepack repack --type=btrees --objects=public.ci_triggers_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_cluster_projects_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.project_deploy_tokens_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_board_group_recent_visits_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_cluster_projects_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.gpg_keys_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_badges_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_chat_names_on_user_id_and_service_id
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_keys_on_primary_keyid
gitlab-pgrepack repack --type=btrees --objects=public.index_board_group_recent_visits_on_board_id
gitlab-pgrepack repack --type=btrees --objects=public.index_gpg_keys_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_path_locks_on_path
gitlab-pgrepack repack --type=btrees --objects=public.index_project_deploy_tokens_on_deploy_token_id
gitlab-pgrepack repack --type=btrees --objects=public.index_kubernetes_namespaces_on_cluster_project_environment_id
gitlab-pgrepack repack --type=btrees --objects=public.index_draft_notes_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.packages_packages_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_tag_create_access
gitlab-pgrepack repack --type=btrees --objects=public.protected_tag_create_access_levels_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_release_links_on_release_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.protected_tags_pkey
gitlab-pgrepack repack --type=btrees --objects=public.user_callouts_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_project_rules_groups_2
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_builds_runner_session_on_build_id
gitlab-pgrepack repack --type=btrees --objects=public.board_group_recent_visits_pkey
gitlab-pgrepack repack --type=btrees --objects=public.ci_builds_runner_session_pkey
gitlab-pgrepack repack --type=btrees --objects=public.clusters_applications_helm_pkey
gitlab-pgrepack repack --type=btrees --objects=public.epic_issues_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_events_on_group_id_partial
gitlab-pgrepack repack --type=btrees --objects=public.fork_networks_pkey
gitlab-pgrepack repack --type=btrees --objects=public.evidences_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_evidences_on_release_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_tags_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.slack_integrations_pkey
gitlab-pgrepack repack --type=btrees --objects=public.u2f_registrations_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_slack_integrations_on_service_id
gitlab-pgrepack repack --type=btrees --objects=public.vulnerability_feedback_unique_idx
gitlab-pgrepack repack --type=btrees --objects=public.board_labels_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_applications_helm_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.index_path_locks_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.clusters_applications_prometheus_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_feature_gates_on_feature_key_and_key_and_value
gitlab-pgrepack repack --type=btrees --objects=public.index_lfs_file_locks_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_tags_on_project_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.index_u2f_registrations_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_applications_prometheus_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.index_path_locks_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.path_locks_pkey
gitlab-pgrepack repack --type=btrees --objects=public.packages_maven_metadata_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_pool_repositories_on_source_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_snippets_on_visibility_level_and_secret
gitlab-pgrepack repack --type=btrees --objects=public.index_untracked_files_for_uploads_on_path
gitlab-pgrepack repack --type=btrees --objects=public.index_users_ops_dashboard_projects_on_user_id_and_project_id
gitlab-pgrepack repack --type=btrees --objects=public.approval_project_rules_groups_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_approval_project_rules_groups_1
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_job_variables_on_key_and_job_id
gitlab-pgrepack repack --type=btrees --objects=public.index_pool_repositories_on_shard_id
gitlab-pgrepack repack --type=btrees --objects=public.pages_domain_acme_orders_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_users_ops_dashboard_projects_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.abuse_reports_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_board_labels_on_label_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipeline_chat_data_on_chat_name_id
gitlab-pgrepack repack --type=btrees --objects=public.clusters_applications_runners_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_design_management_versions_on_sha_and_issue_id
gitlab-pgrepack repack --type=btrees --objects=public.external_pull_requests_pkey
gitlab-pgrepack repack --type=btrees --objects=public.lfs_file_locks_pkey
gitlab-pgrepack repack --type=btrees --objects=public.code_owner_approval_required
gitlab-pgrepack repack --type=btrees --objects=public.index_snippets_on_created_at
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_feedback_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_scanners_on_project_id_and_external_id
gitlab-pgrepack repack --type=btrees --objects=public.appearances_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_board_labels_on_board_id_and_label_id
gitlab-pgrepack repack --type=btrees --objects=public.index_chat_names_on_service_id_and_team_id_and_chat_id
gitlab-pgrepack repack --type=btrees --objects=public.clusters_applications_ingress_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_applications_runners_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.design_management_versions_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_internal_ids_on_usage_and_namespace_id
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_environment_deploy_access_levels_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_design_management_designs_on_issue_id_and_filename
gitlab-pgrepack repack --type=btrees --objects=public.index_feature_flag_scopes_on_flag_id_and_environment_scope
gitlab-pgrepack repack --type=btrees --objects=public.index_prometheus_alert_event_scoped_payload_key
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_feedback_on_issue_id
gitlab-pgrepack repack --type=btrees --objects=public.index_broadcast_messages_on_starts_at_and_ends_at_and_id
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_applications_ingress_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.index_design_management_versions_on_issue_id
gitlab-pgrepack repack --type=btrees --objects=public.release_links_pkey
gitlab-pgrepack repack --type=btrees --objects=public.reviews_pkey
gitlab-pgrepack repack --type=btrees --objects=public.users_ops_dashboard_projects_pkey
gitlab-pgrepack repack --type=btrees --objects=public.chat_names_pkey
gitlab-pgrepack repack --type=btrees --objects=public.ci_pipeline_chat_data_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_pipeline_chat_data_on_pipeline_id
gitlab-pgrepack repack --type=btrees --objects=public.feature_gates_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_environment_deploy_access_levels_on_user_id
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_feedback_on_pipeline_id
gitlab-pgrepack repack --type=btrees --objects=public.index_board_assignees_on_assignee_id
gitlab-pgrepack repack --type=btrees --objects=public.partial_index_ci_builds_on_scheduled_at_with_scheduled_jobs
gitlab-pgrepack repack --type=btrees --objects=public.cluster_groups_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_cluster_groups_on_cluster_id_and_group_id
gitlab-pgrepack repack --type=btrees --objects=public.clusters_applications_cert_managers_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_applications_cert_managers_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.index_design_management_designs_versions_on_event
gitlab-pgrepack repack --type=btrees --objects=public.jira_tracker_data_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_pages_domain_acme_orders_on_challenge_token
gitlab-pgrepack repack --type=btrees --objects=public.index_prometheus_alert_events_on_project_id_and_status
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_environments_on_project_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.index_software_license_policies_unique_per_project
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_feedback_on_author_id
gitlab-pgrepack repack --type=btrees --objects=public.index_vulnerability_feedback_on_comment_author_id
gitlab-pgrepack repack --type=btrees --objects=public.index_cluster_groups_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.index_description_versions_on_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.index_design_management_designs_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_features_on_key
gitlab-pgrepack repack --type=btrees --objects=public.index_issues_on_duplicated_to_id
gitlab-pgrepack repack --type=btrees --objects=public.index_mr_blocks_on_blocking_and_blocked_mr_ids
gitlab-pgrepack repack --type=btrees --objects=public.operations_feature_flag_scopes_pkey
gitlab-pgrepack repack --type=btrees --objects=public.project_error_tracking_settings_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_prometheus_metrics_on_identifier
gitlab-pgrepack repack --type=btrees --objects=public.index_protected_environments_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.index_software_license_policies_on_software_license_id
gitlab-pgrepack repack --type=btrees --objects=public.index_software_licenses_on_spdx_identifier
gitlab-pgrepack repack --type=btrees --objects=public.vulnerability_scanners_pkey
gitlab-pgrepack repack --type=btrees --objects=public.board_assignees_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_cluster_providers_gcp_on_cloud_run
gitlab-pgrepack repack --type=btrees --objects=public.index_description_versions_on_issue_id
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_due_date_sourcing_epic_id
gitlab-pgrepack repack --type=btrees --objects=public.index_epics_on_start_date_sourcing_epic_id
gitlab-pgrepack repack --type=btrees --objects=public.index_ip_restrictions_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.ip_restrictions_pkey
gitlab-pgrepack repack --type=btrees --objects=public.issue_id_issues_prometheus_alert_events_index
gitlab-pgrepack repack --type=btrees --objects=public.index_jira_connect_installations_on_client_key
gitlab-pgrepack repack --type=btrees --objects=public.index_jira_tracker_data_on_service_id
gitlab-pgrepack repack --type=btrees --objects=public.index_operations_feature_flags_on_project_id_and_name
gitlab-pgrepack repack --type=btrees --objects=public.index_pages_domain_acme_orders_on_pages_domain_id
gitlab-pgrepack repack --type=btrees --objects=public.pool_repositories_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_prometheus_metrics_on_common
gitlab-pgrepack repack --type=btrees --objects=public.index_prometheus_metrics_on_project_id
gitlab-pgrepack repack --type=btrees --objects=public.prometheus_metrics_pkey
gitlab-pgrepack repack --type=btrees --objects=public.protected_environments_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_software_licenses_on_name
gitlab-pgrepack repack --type=btrees --objects=public.index_system_note_metadata_on_description_version_id
gitlab-pgrepack repack --type=btrees --objects=public.vulnerability_feedback_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_board_assignees_on_board_id_and_assignee_id
gitlab-pgrepack repack --type=btrees --objects=public.broadcast_messages_pkey
gitlab-pgrepack repack --type=btrees --objects=public.ci_job_variables_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_ci_job_variables_on_job_id
gitlab-pgrepack repack --type=btrees --objects=public.clusters_applications_jupyter_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_applications_jupyter_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_applications_jupyter_on_oauth_application_id
gitlab-pgrepack repack --type=btrees --objects=public.clusters_applications_knative_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_clusters_applications_knative_on_cluster_id
gitlab-pgrepack repack --type=btrees --objects=public.description_versions_pkey
gitlab-pgrepack repack --type=btrees --objects=public.design_management_designs_pkey
gitlab-pgrepack repack --type=btrees --objects=public.design_management_designs_versions_uniqueness
gitlab-pgrepack repack --type=btrees --objects=public.index_design_management_designs_versions_on_version_id
gitlab-pgrepack repack --type=btrees --objects=public.geo_node_statuses_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_geo_node_statuses_on_geo_node_id
gitlab-pgrepack repack --type=btrees --objects=public.historical_data_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_issue_tracker_data_on_service_id
gitlab-pgrepack repack --type=btrees --objects=public.issue_tracker_data_pkey
gitlab-pgrepack repack --type=btrees --objects=public.issue_id_prometheus_alert_event_id_index
gitlab-pgrepack repack --type=btrees --objects=public.jira_connect_installations_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_merge_request_blocks_on_blocked_merge_request_id
gitlab-pgrepack repack --type=btrees --objects=public.merge_request_blocks_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_namespaces_on_custom_project_templates_group_id_and_type
gitlab-pgrepack repack --type=btrees --objects=public.index_oauth_openid_requests_on_access_grant_id
gitlab-pgrepack repack --type=btrees --objects=public.oauth_openid_requests_pkey
gitlab-pgrepack repack --type=btrees --objects=public.operations_feature_flags_pkey
gitlab-pgrepack repack --type=btrees --objects=public.prometheus_alert_events_pkey
gitlab-pgrepack repack --type=btrees --objects=public.protected_environment_deploy_access_levels_pkey
gitlab-pgrepack repack --type=btrees --objects=public.index_saml_providers_on_group_id
gitlab-pgrepack repack --type=btrees --objects=public.saml_providers_pkey
gitlab-pgrepack repack --type=btrees --objects=public.schema_migrations_version_key
gitlab-pgrepack repack --type=btrees --objects=public.index_scim_oauth_access_tokens_on_group_id_and_token_encrypted
gitlab-pgrepack repack --type=btrees --objects=public.software_license_policies_pkey
gitlab-pgrepack repack --type=btrees --objects=public.software_licenses_pkey
gitlab-pgrepack repack --type=btrees --objects=public.untracked_files_for_uploads_pkey
Expected cleanup of 563.56 GiB of bloat.
Rollback
No rollback is needed for this maintenance, as rebuilding indexes can be done over again in the case of failures. As a palliative measure, the repack operation can be canceled during its execution safely. If that's the case, a new schedule should be put in place for the remaining objects.
\cc @Finotto