Space

Database Size: 12.6 GB

24 unused indices. Remove them for faster writes.

rails generate migration remove_unused_indexes

And paste

remove_index :ticket_archive, name: "ticket_archive_searchable_idx"
remove_index :ticket_history, name: "ticket_history_tstzrange"
remove_index :tickets, name: "tickets_space_id_id_code_label_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_state_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_counter_id_idx"
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_service_id_idx"
remove_index :ticket_history, name: "ticket_history_space_id"
remove_index :ticket_history, name: "ticket_history_state"
remove_index :tickets, name: "tickets_space_id_data_slot_start_time_ts_idx"
remove_index :ticket_stats, name: "ticket_stats_space_id_tr_idx"
remove_index :tickets, name: "tickets_counter_id_idx"
remove_index :tickets, name: "foobar"
remove_index :tickets, name: "tickets_data_email_empty_idx"
remove_index :notifications, name: "notifications_created_at_undelivered_not_terminal"
remove_index :tickets_sessions, name: "tickets_sessions_sessions_id_created_at"
remove_index :service_history, name: "service_history_service_id_next_created_at_null_idx"
remove_index :services, name: "services_space_id"
remove_index :sessions, name: "sessions_space_id_status_idx"
remove_index :branch_sessions, name: "ticket_history_branch_id_created_at"
remove_index :users_roles, name: "users_roles_user_id_idx"
remove_index :forms_question_answers, name: "forms_question_answers_ticket_id_idx"
remove_index :ticket_log, name: "ticket_log_space_id_id_idx"

Relation	Size
notifications	5.52 GB
ticket_history	2.45 GB
ticket_archive	1.71 GB
tickets	1.26 GB
flight_airport	823 MB
ticket_archive_searchable_idx UNUSED	118 MB
ticket_history_tstzrange UNUSED	99 MB
tickets_searchable_idx	91.6 MB
flight_schedule	53 MB
jobs	52.9 MB
ticket_archive_space_id_created_at_idx	36.8 MB
ticket_history_space_id_branch_session_id_service_id_serial_idx	35.9 MB
ticket_stats	32.6 MB
flight_airport_space_id_provider	32.4 MB
ticket_history_pkey	30 MB
ticket_stats_keys_index	28.8 MB
slot	28.8 MB
ticket_history_ticket_id	22.3 MB
incidents	20 MB
flight_airport_pkey	17.8 MB
tickets_space_id_id_code_label_idx UNUSED	17 MB
tickets_serial_branch_session_id_service_id_space_id_unique	16.8 MB
ticket_archive_pkey	11.3 MB
tickets_space_id_created_at_idx	11 MB
ticket_history_branch_session_id_state_idx UNUSED	9.66 MB
ticket_history_branch_session_id_counter_id_idx UNUSED	9.64 MB
ticket_history_branch_session_id_session_id_idx UNUSED	9.63 MB
ticket_history_branch_session_id_user_id_idx UNUSED	9.63 MB
ticket_history_branch_session_id_service_id_idx UNUSED	9.63 MB
ticket_history_space_id UNUSED	9.46 MB
ticket_history_state UNUSED	9.45 MB
flight_airline	9.33 MB
flight_schedule_space_id_provider	8.79 MB
tickets_pkey	7.67 MB
tickets_space_id_branch_id_service_id_slot_start_time_ts_idx	7.13 MB
flight_airport_space_id_iata_code_idx	5.78 MB
flight_schedule_flight_iata_dep_time_ts_idx	5.2 MB
tickets_space_id_data_slot_start_time_ts_idx UNUSED	4.99 MB
slot_id_space_id_branch_id_unique	4.84 MB
ticket_stats_space_id_tr_idx UNUSED	4.58 MB
flight_pkey	3.39 MB
slot_start_time_ts_idx	3.26 MB
tickets_space_id_service_id_branch_session_id_idx	2.47 MB
tickets_counter_id_idx UNUSED	2.4 MB
tickets_service_id_state_waiting_idx	2.13 MB
jobs_pkey	1000 KB
notifications_pkey	944 KB
incidents_status_pending_slug_space_id_unique	920 KB
request	760 KB
flight_airline_space_id_provider	648 KB
jobs_space_command_dashboard_idx	624 KB
jobs_dashboard_id_idx	600 KB
notifications_space_id_type_idx	392 KB
foobar UNUSED	328 KB
tickets_data_email_empty_idx UNUSED	328 KB
flight_airline_pkey	320 KB
datasets	296 KB
flight_airline_space_id_icao_code_idx	296 KB
incidents_pkey	248 KB
jobs_runner_next_idx	224 KB
request_ts_idx	224 KB
notifications_created_at_undelivered_not_terminal UNUSED	216 KB
tickets_sessions	168 KB
flight_airline_space_id_iata_code_idx	152 KB
sessions	144 KB
applications	128 KB
contents	104 KB
request_status_idx	96 KB
branch_sessions	88 KB
integrations	80 KB
session_history	72 KB
device_profiles	64 KB
migrations_20190722110054	64 KB
tickets_sessions_sessions_id_created_at UNUSED	64 KB
tickets_sessions_ticket_id_session_id_unique	64 KB
users	64 KB
assets	56 KB
templates	56 KB
tickets_sessions_pkey	56 KB
dashboards	48 KB
entities	48 KB
migrations_20190722110054_lock	40 KB
devices	32 KB
migrations_20190722110054_pkey	32 KB
sessions_token_unique	32 KB
account_recoveries	16 KB
account_recoveries_pkey	16 KB
activations	16 KB
activations_license_id__space_id_unique	16 KB
activations_pkey	16 KB
applications_api_key_unique	16 KB
applications_name_space_id_unique	16 KB
applications_pkey	16 KB
applications_referer_unique	16 KB
applications_space_id_code_unique	16 KB
assets_entity_id_space_id_unique	16 KB
assets_pkey	16 KB
branch_sessions_current_unique	16 KB
branch_sessions_pkey	16 KB
branches	16 KB
branches_code_space_id_unique	16 KB
branches_entity_id_space_id_unique	16 KB
branches_pkey	16 KB
charts_pkey	16 KB
connectors	16 KB
connectors_only_one_enabled_provider_per_type_space_id_unique_i	16 KB
connectors_pkey	16 KB
connectors_provider_space_id_unique_idx	16 KB
content_pkey	16 KB
counter_profiles	16 KB
counter_profiles_code_space_id_unique	16 KB
counter_profiles_pkey	16 KB
counters	16 KB
counters_code_branch_id_space_id_unique	16 KB
counters_code_space_id_unique	16 KB
counters_pkey	16 KB
counters_services	16 KB
counters_services_counter_id_service_id_unique	16 KB
counters_services_pkey	16 KB
dashboards_pkey	16 KB
datasets_dashboard_id_idx	16 KB
device_profiles_pkey	16 KB
devices_connection_key_space_id_unique	16 KB
devices_pkey	16 KB
devices_services	16 KB
devices_services_code_case_insensitive_space_id_unique	16 KB
devices_services_device_id_service_id_unique	16 KB
devices_services_pkey	16 KB
devices_services_priority_code_case_insensitive_space_id_unique	16 KB
entities_pkey	16 KB
integrations_pkey	16 KB
licenses	16 KB
licenses_code_space_id_unique	16 KB
licenses_pkey	16 KB
migrations_20190722110054_lock_pkey	16 KB
queue	16 KB
queue_pkey	16 KB
relations	16 KB
relations_pkey	16 KB
roles	16 KB
roles_is_admin_true_space_id_unique	16 KB
roles_pkey	16 KB
service_history	16 KB
service_history_pkey	16 KB
service_history_service_id_next_created_at_null_idx UNUSED	16 KB
service_profiles	16 KB
service_profiles_code_space_id_unique	16 KB
service_profiles_pkey	16 KB
service_profiles_space_id_entity_id_unique	16 KB
services	16 KB
services_branch_id_code_unique	16 KB
services_pkey	16 KB
services_service_profile_id_branch_id_unique	16 KB
services_space_id UNUSED	16 KB
services_space_id_entity_id_unique	16 KB
session_history_pkey	16 KB
sessions_branch_session_id_idx	16 KB
sessions_pkey	16 KB
sessions_space_id_status_idx UNUSED	16 KB
spaces	16 KB
spaces_name_unique	16 KB
spaces_pkey	16 KB
templates_pkey	16 KB
ticket_history_branch_id_created_at UNUSED	16 KB
users_branches	16 KB
users_branches_branch_id_user_id_space_id_unique	16 KB
users_branches_pkey	16 KB
users_code_space_id_unique	16 KB
users_email_space_id_unique	16 KB
users_entity_id_space_id_unique	16 KB
users_pkey	16 KB
users_roles	16 KB
users_roles_pkey	16 KB
users_roles_user_id_idx UNUSED	16 KB
users_service_profiles	16 KB
users_service_profiles_pkey	16 KB
users_service_profiles_user_id_service_profile_id_unique	16 KB
users_username_space_id_unique	16 KB
account_confirmations	8 KB
account_confirmations_pkey	8 KB
action_log	8 KB
action_log_pkey	8 KB
actions	8 KB
actions_pkey	8 KB
alerts	8 KB
alerts_pkey	8 KB
appointments	8 KB
appointments_code_unique	8 KB
appointments_pkey	8 KB
auth_providers	8 KB
auth_providers_pkey	8 KB
calendar	8 KB
calendar_pkey	8 KB
calendar_rules	8 KB
calendar_rules_pkey	8 KB
calendar_rules_unique_calendar_branch	8 KB
calendar_rules_unique_calendar_counter	8 KB
calendar_rules_unique_calendar_device	8 KB
calendar_rules_unique_calendar_service	8 KB
counter_profiles_is_default_true_space_id_unique	8 KB
customer_alerts	8 KB
customer_alerts_pkey	8 KB
customers	8 KB
customers_data_space_id_unique	8 KB
customers_pkey	8 KB
dashboard_starred_space_unique	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_profiles_vendor_type_is_default_true_space_id_unique	8 KB
device_setup_key_unique	8 KB
device_uuid_unique	8 KB
devices_counters	8 KB
devices_counters_device_id_counter_id_unique	8 KB
devices_counters_pkey	8 KB
devices_data_type_people_count_sensor_space_id_unique	8 KB
event	8 KB
event_pkey	8 KB
flow	8 KB
flow_code_space_id_unique	8 KB
flow_pkey	8 KB
form_questions	8 KB
form_questions_pkey	8 KB
forms	8 KB
forms_forms_questions	8 KB
forms_forms_questions_form_id_staging_forms_question_id_unique	8 KB
forms_forms_questions_pkey	8 KB
forms_pkey	8 KB
forms_question_answers	8 KB
forms_question_answers_pkey	8 KB
forms_question_answers_ticket_id_idx UNUSED	8 KB
forms_rules	8 KB
forms_rules_pkey	8 KB
policy	8 KB
policy_pkey	8 KB
queue_code_space_id_unique	8 KB
spaces_users	8 KB
spaces_users_pkey	8 KB
ticket_log	8 KB
ticket_log_pkey	8 KB
ticket_log_space_id_id_idx UNUSED	8 KB
ticket_pass	8 KB
ticket_pass_pkey	8 KB
tickets_metadata_boarding_pass_encoded_unique	8 KB