Space

Database Size: 165 GB

35 unused indices. Remove them for faster writes.

rails generate migration remove_unused_indexes

And paste

remove_index :jobs, name: "jobs_status_next_run_updated_at_rrule_idx"
remove_index :request, name: "request_ts_idx"
remove_index :jobs, name: "jobs_runner_next_idx"
remove_index :ticket_history, name: "ticket_history_ticket_id"
remove_index :ticket_history, name: "ticket_history_branch_session_id_session_id_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_user_id_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_counter_id_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_service_id_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_state_idx"
remove_index :ticket_history, name: "ticket_history_state"
remove_index :tickets_sessions, name: "tickets_sessions_sessions_id_created_at"
remove_index :jobs, name: "jobs_space_command_dashboard_idx"
remove_index :request, name: "request_status_idx"
remove_index :ticket_history, name: "ticket_history_state_channel_idx"
remove_index :notifications, name: "notifications_space_id_type_idx"
remove_index :branch_sessions, name: "ticket_history_branch_id_created_at"
remove_index :forms_question_answers, name: "forms_question_answers_ticket_id_idx"
remove_index :user_statuses, name: "user_statuses_user_id_space_id_idx"
remove_index :sessions, name: "sessions_branch_session_id_idx"
remove_index :branch_sessions, name: "branch_sessions_space_id"
remove_index :tickets, name: "tickets_counter_id_idx"
remove_index :notifications, name: "notifications_created_at_undelivered_not_terminal"
remove_index :datasets, name: "datasets_dashboard_id_idx"
remove_index :service_history, name: "service_history_service_id_next_created_at_null_idx"
remove_index :tickets, name: "tickets_service_id_state_waiting_idx"
remove_index :users_roles, name: "users_roles_user_id_idx"
remove_index :services, name: "services_space_id"
remove_index :custom_time_partitions, name: "custom_time_partitions_partition_range_idx"
remove_index :flight_airline, name: "flight_airline_space_id_iata_code_idx"
remove_index :flight_airline, name: "flight_airline_space_id_icao_code_idx"
remove_index :flight_airport, name: "flight_airport_space_id_iata_code_idx"
remove_index :flight_schedule, name: "flight_schedule_flight_iata_dep_time_ts_idx"
remove_index :part_config, name: "part_config_type_idx"
remove_index :tickets, name: "tickets_data_email_empty_idx"
remove_index :tickets, name: "tickets_space_id_data_slot_start_time_ts_idx"

Relation	Size
ticket_history	52.9 GB
ticket_archive	28.4 GB
notifications	26.8 GB
ticket_archive_pre_2024	8.28 GB
ticket_history_pre_2024	7.88 GB
ticket_archive_searchable_idx	4.59 GB
tickets_searchable_idx	4.54 GB
ticket_stats_keys_index	3.62 GB
ticket_history_2022	2.73 GB
ticket_history_space_id_state_branch_id_created_at_user_id_idx	2.64 GB
ticket_stats	2.57 GB
jobs	2.52 GB
jobs_status_next_run_updated_at_rrule_idx UNUSED	1.74 GB
ticket_history_pkey	1.32 GB
request_ts_idx UNUSED	1.1 GB
ticket_history_20220430	1.04 GB
tickets_sessions	966 MB
jobs_runner_next_idx UNUSED	749 MB
ticket_history_ticket_id UNUSED	646 MB
ticket_history_20220715	564 MB
ticket_archive_space_id_created_at_idx	501 MB
ticket_history_branch_session_id_session_id_idx UNUSED	498 MB
ticket_history_branch_session_id_user_id_idx UNUSED	497 MB
ticket_history_branch_session_id_counter_id_idx UNUSED	494 MB
ticket_history_branch_session_id_service_id_idx UNUSED	487 MB
branch_sessions	478 MB
ticket_history_branch_session_id_state_idx UNUSED	477 MB
ticket_archive_pkey	450 MB
ticket_stats_tr_idx	439 MB
ticket_archive_space_id_branch_id_created_at_idx	425 MB
ticket_history_state UNUSED	415 MB
tickets_sessions_sessions_id_created_at UNUSED	399 MB
jobs_pkey	392 MB
session_history	359 MB
tickets_sessions_ticket_id_session_id_unique	358 MB
ticket_history_space_id_idx	318 MB
jobs_space_command_dashboard_idx UNUSED	316 MB
notifications_pkey	279 MB
tickets_sessions_pkey	255 MB
incidents	199 MB
request_status_idx UNUSED	196 MB
incidents_status_pending_slug_space_id_unique	188 MB
ticket_stats_pkey	150 MB
user_statuses	140 MB
ticket_history_state_channel_idx UNUSED	128 MB
action_log	126 MB
forms_question_answers	102 MB
notifications_space_id_type_idx UNUSED	101 MB
datasets	101 MB
sessions	99.9 MB
session_history_pkey	59.1 MB
audit_logs audit	54 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
user_statuses_pkey	22.3 MB
forms_question_answers_ticket_id_idx UNUSED	21.6 MB
spaces	21.5 MB
branch_sessions_pkey	19.7 MB
sessions_pkey	18.7 MB
forms_question_answers_pkey	15.8 MB
sessions_token_unique	14 MB
devices	12.7 MB
tickets_pkey	11.9 MB
user_statuses_user_id_space_id_idx UNUSED	9.48 MB
sessions_branch_session_id_idx UNUSED	9.3 MB
service_history	7.01 MB
sessions auth	6.91 MB
ticket_meetings	6.88 MB
spaces_users	6.43 MB
charts_pkey	6.32 MB
applications	6.04 MB
branch_sessions_space_id UNUSED	4.88 MB
assets	4.86 MB
tickets_counter_id_idx UNUSED	3.61 MB
sessions_space_id_status_idx	3.36 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.86 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
sessions_uuid_key auth	1.13 MB
datasets_dashboard_id_idx UNUSED	1.13 MB
devices_services	1.01 MB
action_log_pkey	864 KB
counters	848 KB
service_profiles	848 KB
sessions_pkey auth	792 KB
service_history_pkey	736 KB
activations	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	432 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 UNUSED	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
ticket_meetings_pkey	160 KB
event	152 KB
forms	152 KB
spaces_users_pkey	152 KB
tickets_service_id_state_waiting_idx UNUSED	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 UNUSED	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 UNUSED	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