Space

Database Size: 36.2 GB

14 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_session_id_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_state_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_user_id_idx"
remove_index :notifications, name: "notifications_created_at_undelivered_not_terminal"
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	28.7 GB
ticket_history	2.33 GB
ticket_archive	1.69 GB
tickets	1.22 GB
flight_airport	828 MB
tickets_backup	506 MB
ticket_archive_searchable_idx UNUSED	114 MB
ticket_history_tstzrange UNUSED	104 MB
tickets_searchable_idx	85.5 MB
jobs	71 MB
flight_schedule	48.1 MB
ticket_history_space_id_branch_session_id_service_id_serial_idx	38.7 MB
ticket_archive_space_id_created_at_idx	37.7 MB
ticket_stats	32 MB
ticket_history_pkey	31.8 MB
incidents	31.7 MB
ticket_stats_keys_index	31.7 MB
slot	26.8 MB
ticket_history_ticket_id	23.4 MB
tickets_space_id_id_code_label_idx UNUSED	20.9 MB
tickets_serial_branch_session_id_service_id_space_id_unique	18.7 MB
flight_airport_pkey	17.9 MB
tickets_space_id_created_at_idx	15 MB
ticket_archive_pkey	12.9 MB
flight_schedule_space_id_provider	11.3 MB
ticket_history_branch_session_id_session_id_idx UNUSED	11 MB
ticket_history_branch_session_id_service_id_idx	10.9 MB
ticket_history_branch_session_id_state_idx UNUSED	10.9 MB
ticket_history_branch_session_id_counter_id_idx	10.8 MB
ticket_history_branch_session_id_user_id_idx UNUSED	10.8 MB
flight_airline	10.8 MB
ticket_history_space_id	10.7 MB
ticket_history_state	10.6 MB
tickets_pkey	9.18 MB
tickets_space_id_branch_id_service_id_slot_start_time_ts_idx	8.8 MB
tickets_space_id_data_slot_start_time_ts_idx	6.61 MB
flight_airport_space_id_provider	6.55 MB
notifications_pkey	6.05 MB
flight_airport_space_id_iata_code_idx	5.83 MB
flight_schedule_flight_iata_dep_time_ts_idx	5.75 MB
ticket_stats_space_id_tr_idx	5.2 MB
slot_id_space_id_branch_id_unique	5.19 MB
flight_pkey	4.82 MB
incidents_status_pending_slug_space_id_unique	3.98 MB
slot_start_time_ts_idx	3.73 MB
request_ts_idx	3.06 MB
request	2.95 MB
tickets_space_id_service_id_branch_session_id_idx	2.93 MB
tickets_counter_id_idx	2.82 MB
notifications_space_id_type_idx	2.4 MB
tickets_service_id_state_waiting_idx	2.39 MB
jobs_pkey	2.09 MB
jobs_space_command_dashboard_idx	1.35 MB
jobs_dashboard_id_idx	1.2 MB
datasets	1.15 MB
request_status_idx	1.1 MB
incidents_pkey	872 KB
notifications_created_at_undelivered_not_terminal UNUSED	848 KB
foobar	664 KB
tickets_data_email_empty_idx	664 KB
flight_airline_space_id_provider	656 KB
jobs_runner_next_idx	416 KB
flight_airline_pkey	328 KB
flight_airline_space_id_icao_code_idx	328 KB
contents	200 KB
applications	168 KB
tickets_sessions	168 KB
flight_airline_space_id_iata_code_idx	152 KB
integrations	144 KB
sessions	128 KB
users	120 KB
device_profiles	104 KB
devices	96 KB
branch_sessions	88 KB
session_history	80 KB
migrations_20190722110054	72 KB
roles	72 KB
templates	72 KB
dashboards	64 KB
tickets_sessions_sessions_id_created_at	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
devices_services	48 KB
licenses	48 KB
queue	48 KB
relations	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
calendar	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
calendar_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
migrations_20190722110054_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	16 KB
sessions_pkey	16 KB
sessions_space_id_status_idx UNUSED	16 KB
sessions_token_unique	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_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