PgHero

Space

Database Size: 163 GB

17 unused indices. Remove them for faster writes. Check they aren’t used on replicas.

Relation Size
ticket_history 51.5 GB
ticket_archive 27.9 GB
notifications 26.8 GB
ticket_archive_pre_2024 8.28 GB
ticket_history_pre_2024 7.88 GB
ticket_archive_searchable_idx 4.5 GB
tickets_searchable_idx 4.47 GB
ticket_stats_keys_index 3.58 GB
ticket_history_2022 2.73 GB
ticket_history_space_id_state_branch_id_created_at_user_id_idx UNUSED 2.56 GB
ticket_stats 2.54 GB
jobs 2.52 GB
jobs_status_next_run_updated_at_rrule_idx UNUSED 1.51 GB
ticket_history_pkey 1.29 GB
request_ts_idx UNUSED 1.1 GB
ticket_history_20220430 1.04 GB
tickets_sessions 966 MB
jobs_runner_next_idx 749 MB
ticket_history_ticket_id 635 MB
ticket_history_20220715 564 MB
ticket_archive_space_id_created_at_idx 489 MB
ticket_history_branch_session_id_session_id_idx UNUSED 488 MB
ticket_history_branch_session_id_user_id_idx 487 MB
ticket_history_branch_session_id_counter_id_idx 485 MB
ticket_history_branch_session_id_service_id_idx 478 MB
branch_sessions 478 MB
ticket_history_branch_session_id_state_idx 468 MB
ticket_archive_pkey 442 MB
ticket_stats_tr_idx 434 MB
ticket_archive_space_id_branch_id_created_at_idx 410 MB
ticket_history_state UNUSED 409 MB
tickets_sessions_sessions_id_created_at 394 MB
jobs_pkey 392 MB
tickets_sessions_ticket_id_session_id_unique 353 MB
session_history 345 MB
incidents 320 MB
jobs_space_command_dashboard_idx 316 MB
ticket_history_space_id_idx 312 MB
notifications_pkey 278 MB
tickets_sessions_pkey 252 MB
request_status_idx UNUSED 196 MB
incidents_status_pending_slug_space_id_unique 188 MB
ticket_stats_pkey 148 MB
action_log 126 MB
ticket_history_state_channel_idx 124 MB
user_statuses 119 MB
forms_question_answers 102 MB
datasets 101 MB
notifications_space_id_type_idx UNUSED 101 MB
sessions 97.5 MB
session_history_pkey 57.6 MB
audit_logs audit 53.5 MB
incidents_pkey 40.8 MB
tickets 35.9 MB
request 30.8 MB
tickets_serial_branch_session_id_service_id_space_id_unique 26.2 MB
tickets_space_id_created_at_idx 23.1 MB
ticket_history_branch_id_created_at UNUSED 22.4 MB
forms_question_answers_ticket_id_idx 21.6 MB
spaces 21.5 MB
user_statuses_pkey 21.1 MB
branch_sessions_pkey 19.5 MB
sessions_pkey 18.5 MB
forms_question_answers_pkey 15.7 MB
sessions_token_unique 13.9 MB
devices 12.7 MB
tickets_pkey 11.9 MB
sessions_branch_session_id_idx 9.11 MB
user_statuses_user_id_space_id_idx 9.05 MB
service_history 7 MB
sessions auth 6.59 MB
spaces_users 6.43 MB
ticket_meetings 6.36 MB
charts_pkey 6.32 MB
applications 6.04 MB
assets 4.86 MB
branch_sessions_space_id 4.86 MB
tickets_counter_id_idx 3.61 MB
sessions_space_id_status_idx 3.3 MB
device_profiles 3.27 MB
users 3.2 MB
notifications_created_at_undelivered_not_terminal UNUSED 3.02 MB
audit_logs_pkey audit 2.84 MB
entities 2.07 MB
settings 1.7 MB
dashboards 1.5 MB
users_services 1.47 MB
services 1.4 MB
contents 1.34 MB
counters_services 1.3 MB
datasets_dashboard_id_idx 1.13 MB
sessions_uuid_key auth 1.08 MB
devices_services 1.01 MB
action_log_pkey 856 KB
counters 848 KB
service_profiles 848 KB
sessions_pkey auth 760 KB
activations 728 KB
service_history_pkey 728 KB
users_service_profiles 664 KB
counters_services_counter_id_service_id_unique 632 KB
users_services_user_id_service_id_unique 616 KB
roles 600 KB
dashboards_pkey 584 KB
templates 544 KB
counters_services_pkey 528 KB
devices_services_device_id_service_id_unique 528 KB
users_services_pkey 528 KB
devices_services_priority_code_case_insensitive_space_id_unique 504 KB
branches 496 KB
devices_services_code_case_insensitive_space_id_unique 472 KB
devices_services_pkey 424 KB
entities_pkey 408 KB
users_branches 368 KB
spaces_name_unique 344 KB
connectors 336 KB
spaces_pkey 312 KB
assets_entity_id_space_id_unique 304 KB
users_email_space_id_unique 304 KB
users_service_profiles_user_id_service_profile_id_unique 304 KB
users_roles 264 KB
appointments 256 KB
counter_profiles 248 KB
service_history_service_id_next_created_at_null_idx 248 KB
licenses 240 KB
relations 232 KB
users_service_profiles_pkey 224 KB
users_username_space_id_unique 224 KB
assets_pkey 216 KB
services_space_id_entity_id_unique 216 KB
users_branches_branch_id_user_id_space_id_unique 208 KB
users_entity_id_space_id_unique 192 KB
spaces_users_user_id_space_id_index 184 KB
devices_pkey 176 KB
event 152 KB
forms 152 KB
spaces_users_pkey 152 KB
ticket_meetings_pkey 152 KB
tickets_service_id_state_waiting_idx 144 KB
devices_connection_key_space_id_unique 136 KB
services_service_profile_id_branch_id_unique 136 KB
users_pkey 136 KB
forms_rules 128 KB
branch_sessions_current_unique 120 KB
service_profiles_space_id_entity_id_unique 120 KB
services_pkey 120 KB
users_branches_pkey 112 KB
applications_name_space_id_unique 104 KB
licenses_code_space_id_unique 104 KB
customer_alerts 96 KB
form_questions 96 KB
integrations 96 KB
calendar 88 KB
users_roles_pkey 88 KB
alerts 80 KB
auth_providers 80 KB
connectors_pkey 80 KB
service_profiles_pkey 80 KB
users_roles_user_id_idx 80 KB
forms_forms_questions 72 KB
licenses_pkey 72 KB
migrations_20190722110054 72 KB
user_identities auth 72 KB
account_recoveries 64 KB
applications_pkey 64 KB
applications_space_id_code_unique 64 KB
users_code_space_id_unique 64 KB
account_confirmations 56 KB
activations_license_id__space_id_unique 56 KB
counters_pkey 56 KB
dashboard_starred_space_unique 56 KB
services_space_id UNUSED 56 KB
actions 48 KB
activations_pkey 48 KB
applications_api_key_unique 48 KB
applications_referer_unique 48 KB
calendar_rules 48 KB
connectors_branches 48 KB
device_profiles_pkey 48 KB
devices_counters 48 KB
groups 48 KB
sso_providers auth 48 KB
ticket_pass 48 KB
typeorm_migrations 48 KB
user_status_auto_update_rules 48 KB
user_status_settings 48 KB
audit_settings audit 40 KB
event_pkey 40 KB
forms_forms_questions_form_id_staging_forms_question_id_unique 40 KB
forms_rules_pkey 40 KB
migrations_20190722110054_lock 40 KB
relations_pkey 40 KB
roles_pkey 40 KB
service_profiles_code_space_id_unique 40 KB
templates_pkey 40 KB
users_groups 40 KB
branches_entity_id_space_id_unique 32 KB
branches_pkey 32 KB
connectors_is_default_type_space_id_unique_idx 32 KB
content_pkey 32 KB
migrations_20190722110054_pkey 32 KB
queues 24 KB
PK_bb2f075707dd300ba86d0208923 16 KB
account_confirmations_pkey 16 KB
account_recoveries_pkey 16 KB
actions_pkey 16 KB
alerts_pkey 16 KB
appointments_code_unique 16 KB
appointments_pkey 16 KB
audit_settings_pkey audit 16 KB
audit_settings_space_id_unique audit 16 KB
auth_providers_pkey 16 KB
branches_code_space_id_unique 16 KB
calendar_pkey 16 KB
calendar_rules_pkey 16 KB
calendar_rules_unique_calendar_branch 16 KB
calendar_rules_unique_calendar_service 16 KB
connectors_branches_pkey 16 KB
counter_profiles_code_space_id_unique 16 KB
counter_profiles_is_default_true_space_id_unique 16 KB
counter_profiles_pkey 16 KB
counters_code_branch_id_space_id_unique 16 KB
counters_code_space_id_unique 16 KB
customer_alerts_pkey 16 KB
device_profiles_vendor_type_is_default_true_space_id_unique 16 KB
devices_counters_device_id_counter_id_unique 16 KB
devices_counters_pkey 16 KB
devices_data_type_people_count_sensor_space_id_unique 16 KB
form_questions_pkey 16 KB
forms_forms_questions_pkey 16 KB
forms_pkey 16 KB
groups_pkey 16 KB
groups_space_id_name_unique 16 KB
integrations_pkey 16 KB
migrations_20190722110054_lock_pkey 16 KB
queues_pkey 16 KB
queues_space_id_order_unique 16 KB
roles_is_admin_true_space_id_unique 16 KB
services_branch_id_code_unique 16 KB
sso_providers_pkey auth 16 KB
sso_providers_uuid_key auth 16 KB
ticket_pass_pkey 16 KB
user_identities_pkey auth 16 KB
user_status_auto_update_rules_pkey 16 KB
user_status_auto_update_rules_scope_group_group_id_unique 16 KB
user_status_auto_update_rules_scope_space_space_id_unique 16 KB
user_status_auto_update_rules_scope_user_space_id_user_id_uniqu 16 KB
user_status_settings_pkey 16 KB
user_status_settings_space_id_unique 16 KB
users_groups_pkey 16 KB
users_groups_user_id_group_id_unique 16 KB
calendar_rules_unique_calendar_counter 8 KB
calendar_rules_unique_calendar_device 8 KB
custom_time_partitions partman 8 KB
custom_time_partitions_partition_range_idx partman UNUSED 8 KB
custom_time_partitions_pkey partman 8 KB
customers 8 KB
customers_data_space_id_unique 8 KB
customers_pkey 8 KB
dashboards statistics 8 KB
dashboards_pkey statistics 8 KB
dashboards_users_pkey statistics 8 KB
device 8 KB
device_link 8 KB
device_link_confirmation_code_unique 8 KB
device_link_pkey 8 KB
device_pkey 8 KB
device_setup_key_unique 8 KB
device_uuid_unique 8 KB
features 8 KB
features_pkey 8 KB
flight_airline 8 KB
flight_airline_pkey 8 KB
flight_airline_space_id_iata_code_idx UNUSED 8 KB
flight_airline_space_id_icao_code_idx UNUSED 8 KB
flight_airline_space_id_provider 8 KB
flight_airport 8 KB
flight_airport_pkey 8 KB
flight_airport_space_id_iata_code_idx UNUSED 8 KB
flight_airport_space_id_provider 8 KB
flight_pkey 8 KB
flight_schedule 8 KB
flight_schedule_flight_iata_dep_time_ts_idx UNUSED 8 KB
flight_schedule_space_id_provider 8 KB
flow 8 KB
flow_code_space_id_unique 8 KB
flow_pkey 8 KB
one_time_tokens auth 8 KB
one_time_tokens_pkey auth 8 KB
one_time_tokens_token_key auth 8 KB
part_config partman 8 KB
part_config_parent_table_pkey partman 8 KB
part_config_sub partman 8 KB
part_config_sub_pkey partman 8 KB
part_config_type_idx partman UNUSED 8 KB
policy 8 KB
policy_pkey 8 KB
queues_users_pkey 8 KB
reports statistics 8 KB
reports_pkey statistics 8 KB
reports_users_pkey statistics 8 KB
scopes auth 8 KB
scopes_name_key auth 8 KB
scopes_pkey auth 8 KB
slot 8 KB
slot_id_space_id_branch_id_unique 8 KB
ticket_auto_assign_rules 8 KB
ticket_auto_assign_rules_pkey 8 KB
ticket_auto_assign_rules_scope_group_group_id_unique 8 KB
ticket_auto_assign_rules_scope_space_space_id_unique 8 KB
ticket_auto_assign_rules_scope_user_space_id_user_id_unique 8 KB
tickets_data_email_empty_idx 8 KB
tickets_metadata_boarding_pass_encoded_unique 8 KB
tickets_space_id_data_slot_start_time_ts_idx UNUSED 8 KB
widget_runs statistics 8 KB
widget_runs_pkey statistics 8 KB
widgets statistics 8 KB
widgets_pkey statistics 8 KB
dashboards_users statistics 0 Bytes
queues_users 0 Bytes
reports_users statistics 0 Bytes