Space

Database Size: 17.1 GB

29 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 :ticket_archive, name: "ticket_archive_space_id_created_at_idx"
remove_index :tickets, name: "tickets_space_id_id_code_label_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_counter_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_session_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_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_space_id_type_idx"
remove_index :jobs, name: "jobs_runner_next_idx"
remove_index :notifications, name: "notifications_created_at_undelivered_not_terminal"
remove_index :flight_airline, name: "flight_airline_space_id_iata_code_idx"
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_branch_session_id_idx"
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	9.66 GB
ticket_history	2.55 GB
ticket_archive	1.77 GB
tickets	1.32 GB
flight_airport	823 MB
ticket_archive_searchable_idx UNUSED	118 MB
ticket_history_tstzrange UNUSED	104 MB
tickets_searchable_idx	91.6 MB
jobs	75.5 MB
flight_schedule	60.3 MB
ticket_archive_space_id_created_at_idx UNUSED	38.4 MB
ticket_history_space_id_branch_session_id_service_id_serial_idx	37.7 MB
ticket_stats	32.9 MB
flight_airport_space_id_provider	32.5 MB
incidents	31.7 MB
ticket_history_pkey	31.4 MB
ticket_stats_keys_index	29.7 MB
slot	29.4 MB
ticket_history_ticket_id	23.2 MB
tickets_space_id_id_code_label_idx UNUSED	18.6 MB
tickets_serial_branch_session_id_service_id_space_id_unique	18 MB
flight_airport_pkey	17.9 MB
tickets_space_id_created_at_idx	12.3 MB
ticket_archive_pkey	11.8 MB
ticket_history_branch_session_id_counter_id_idx UNUSED	10.3 MB
ticket_history_branch_session_id_user_id_idx UNUSED	10.3 MB
ticket_history_branch_session_id_session_id_idx UNUSED	10.3 MB
ticket_history_branch_session_id_service_id_idx UNUSED	10.3 MB
ticket_history_branch_session_id_state_idx UNUSED	10.2 MB
ticket_history_space_id UNUSED	10.1 MB
ticket_history_state UNUSED	9.96 MB
flight_airline	9.7 MB
flight_schedule_space_id_provider	9.6 MB
tickets_pkey	8.3 MB
tickets_space_id_branch_id_service_id_slot_start_time_ts_idx	7.82 MB
flight_airport_space_id_iata_code_idx	5.84 MB
flight_schedule_flight_iata_dep_time_ts_idx	5.66 MB
tickets_space_id_data_slot_start_time_ts_idx UNUSED	5.55 MB
slot_id_space_id_branch_id_unique	5.03 MB
ticket_stats_space_id_tr_idx UNUSED	4.73 MB
flight_pkey	3.84 MB
slot_start_time_ts_idx	3.4 MB
tickets_space_id_service_id_branch_session_id_idx	2.76 MB
tickets_counter_id_idx UNUSED	2.63 MB
tickets_service_id_state_waiting_idx	2.34 MB
jobs_pkey	1.85 MB
notifications_pkey	1.8 MB
request	1.69 MB
incidents_status_pending_slug_space_id_unique	1.35 MB
jobs_space_command_dashboard_idx	1.22 MB
jobs_dashboard_id_idx	1.07 MB
foobar UNUSED	728 KB
tickets_data_email_empty_idx UNUSED	728 KB
notifications_space_id_type_idx UNUSED	696 KB
flight_airline_space_id_provider	664 KB
datasets	400 KB
jobs_runner_next_idx UNUSED	352 KB
flight_airline_pkey	344 KB
notifications_created_at_undelivered_not_terminal UNUSED	328 KB
incidents_pkey	320 KB
flight_airline_space_id_icao_code_idx	304 KB
request_ts_idx	248 KB
tickets_sessions	168 KB
flight_airline_space_id_iata_code_idx UNUSED	160 KB
applications	144 KB
contents	144 KB
sessions	144 KB
integrations	120 KB
request_status_idx	112 KB
device_profiles	104 KB
devices	96 KB
branch_sessions	88 KB
session_history	80 KB
migrations_20190722110054	72 KB
users	72 KB
templates	64 KB
tickets_sessions_sessions_id_created_at UNUSED	64 KB
tickets_sessions_ticket_id_session_id_unique	64 KB
assets	56 KB
entities	56 KB
tickets_sessions_pkey	56 KB
account_recoveries	48 KB
activations	48 KB
branches	48 KB
connectors	48 KB
counter_profiles	48 KB
counters	48 KB
counters_services	48 KB
dashboards	48 KB
devices_services	48 KB
licenses	48 KB
queue	48 KB
relations	48 KB
roles	48 KB
service_history	48 KB
service_profiles	48 KB
services	48 KB
spaces	48 KB
users_branches	48 KB
users_roles	48 KB
users_service_profiles	48 KB
migrations_20190722110054_lock	40 KB
migrations_20190722110054_pkey	32 KB
sessions_token_unique	32 KB
account_recoveries_pkey	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_code_space_id_unique	16 KB
branches_entity_id_space_id_unique	16 KB
branches_pkey	16 KB
charts_pkey	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_code_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
counters_pkey	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_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_code_space_id_unique	16 KB
licenses_pkey	16 KB
migrations_20190722110054_lock_pkey	16 KB
queue_pkey	16 KB
relations_pkey	16 KB
roles_is_admin_true_space_id_unique	16 KB
roles_pkey	16 KB
service_history_pkey	16 KB
service_history_service_id_next_created_at_null_idx UNUSED	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_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 UNUSED	16 KB
sessions_pkey	16 KB
sessions_space_id_status_idx UNUSED	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_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_pkey	16 KB
users_roles_user_id_idx UNUSED	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