Space

Database Size: 46.9 GB

10 unused indices. Remove them for faster writes.

rails generate migration remove_unused_indexes

And paste

remove_index :ticket_history, name: "ticket_history_tstzrange"
remove_index :ticket_history, name: "ticket_history_space_id_state_branch_id_created_at_user_id_idx"
remove_index :ticket_history, name: "ticket_history_branch_session_id_session_id_idx"
remove_index :ticket_history, name: "ticket_history_state"
remove_index :jobs, name: "jobs_runner_next_idx"
remove_index :flight_airline, name: "flight_airline_space_id_icao_code_idx"
remove_index :flight_airline, name: "flight_airline_space_id_iata_code_idx"
remove_index :notifications, name: "notifications_created_at_undelivered_not_terminal"
remove_index :services, name: "services_space_id"
remove_index :tickets_sessions, name: "tickets_sessions_sessions_id_created_at"

Relation	Size
ticket_history	20.7 GB
ticket_history_3000000	8 GB
ticket_archive	6.55 GB
flight_schedule	3.79 GB
flight_airport	1.2 GB
ticket_archive_searchable_idx	1.03 GB
tickets_searchable_idx	1010 MB
ticket_history_tstzrange UNUSED	731 MB
ticket_stats_keys_index	539 MB
ticket_history_space_id_state_branch_id_created_at_user_id_idx UNUSED	472 MB
forms_question_answers	466 MB
ticket_stats	453 MB
ticket_history_pkey	172 MB
flight_schedule_space_id_provider	172 MB
ticket_history_ticket_id	116 MB
ticket_history_branch_session_id_service_id_idx	101 MB
ticket_archive_space_id_created_at_idx	97 MB
flight_schedule_flight_iata_dep_time_ts_idx	92.6 MB
ticket_history_branch_session_id_counter_id_idx	92.2 MB
ticket_history_branch_session_id_session_id_idx UNUSED	89.6 MB
ticket_history_branch_session_id_state_idx	88.6 MB
tickets	84 MB
forms_question_answers_pkey	76.3 MB
ticket_history_branch_session_id_user_id_idx	75.9 MB
ticket_stats_tr_idx	74.3 MB
flight_pkey	68 MB
jobs	64.9 MB
ticket_history_space_id	62.9 MB
session_history	58.1 MB
ticket_history_state UNUSED	55.4 MB
ticket_archive_space_id_branch_id_created_at_idx	51.4 MB
ticket_archive_pkey	50.4 MB
forms_question_answers_2261490	47 MB
incidents	43.7 MB
request	38.6 MB
forms_question_answers_ticket_id_idx	38.6 MB
flight_airport_space_id_provider	31.6 MB
flight_airport_pkey	26.3 MB
ticket_stats_pkey	23.7 MB
flight_airline	19.7 MB
sessions	17 MB
flight_airport_space_id_iata_code_idx	13.4 MB
incidents_status_pending_slug_space_id_unique	10.7 MB
session_history_pkey	10.4 MB
tickets_pkey	6.3 MB
jobs_pkey	5.34 MB
tickets_space_id_created_at_idx	4.83 MB
incidents_pkey	3.83 MB
branch_sessions	3.41 MB
sessions_pkey	3.13 MB
sessions_token_unique	2.39 MB
datasets	2.13 MB
flight_airline_space_id_provider	1.72 MB
request_ts_idx	1.59 MB
notifications	1.13 MB
flight_airline_pkey	1 MB
jobs_runner_next_idx UNUSED	776 KB
request_status_idx	744 KB
sessions_branch_session_id_idx	688 KB
sessions_space_id_status_idx	616 KB
flight_airline_space_id_icao_code_idx UNUSED	584 KB
flight_airline_space_id_iata_code_idx UNUSED	456 KB
devices	376 KB
ticket_history_branch_id_created_at	376 KB
service_history	344 KB
users	336 KB
branch_sessions_pkey	248 KB
users_service_profiles	240 KB
device_profiles	200 KB
services	184 KB
applications	168 KB
jobs_space_command_dashboard_idx	168 KB
tickets_counter_id_idx	168 KB
counters_services	160 KB
integrations	152 KB
spaces_users	152 KB
assets	128 KB
contents	120 KB
spaces	120 KB
counters	96 KB
users_service_profiles_user_id_service_profile_id_unique	96 KB
entities	88 KB
service_profiles	80 KB
counters_services_counter_id_service_id_unique	72 KB
dashboards	72 KB
devices_services	72 KB
forms_rules	72 KB
migrations_20190722110054	72 KB
notifications_pkey	72 KB
users_branches	64 KB
users_service_profiles_pkey	64 KB
branches	56 KB
roles	56 KB
users_roles	56 KB
account_recoveries	48 KB
activations	48 KB
connectors	48 KB
counter_profiles	48 KB
counters_services_pkey	48 KB
form_questions	48 KB
forms	48 KB
forms_forms_questions	48 KB
licenses	48 KB
relations	48 KB
service_history_pkey	48 KB
templates	48 KB
tickets_sessions	48 KB
charts_pkey	40 KB
devices_services_code_case_insensitive_space_id_unique	40 KB
devices_services_priority_code_case_insensitive_space_id_unique	40 KB
migrations_20190722110054_lock	40 KB
users_email_space_id_unique	40 KB
users_username_space_id_unique	40 KB
datasets_dashboard_id_idx	32 KB
devices_services_device_id_service_id_unique	32 KB
entities_pkey	32 KB
service_history_service_id_next_created_at_null_idx	32 KB
users_branches_branch_id_user_id_space_id_unique	32 KB
account_confirmations	16 KB
account_confirmations_pkey	16 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
branches_code_space_id_unique	16 KB
branches_entity_id_space_id_unique	16 KB
branches_pkey	16 KB
connectors_is_default_type_space_id_unique_idx	16 KB
connectors_pkey	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
dashboard_starred_space_unique	16 KB
dashboards_pkey	16 KB
device_profiles_pkey	16 KB
devices_connection_key_space_id_unique	16 KB
devices_pkey	16 KB
devices_services_pkey	16 KB
form_questions_pkey	16 KB
forms_forms_questions_form_id_staging_forms_question_id_unique	16 KB
forms_forms_questions_pkey	16 KB
forms_pkey	16 KB
forms_rules_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
notifications_created_at_undelivered_not_terminal UNUSED	16 KB
notifications_space_id_type_idx	16 KB
relations_pkey	16 KB
roles_is_admin_true_space_id_unique	16 KB
roles_pkey	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
spaces_name_unique	16 KB
spaces_pkey	16 KB
spaces_users_pkey	16 KB
spaces_users_user_id_space_id_index	16 KB
templates_pkey	16 KB
tickets_service_id_state_waiting_idx	16 KB
tickets_sessions_pkey	16 KB
tickets_sessions_sessions_id_created_at UNUSED	16 KB
tickets_sessions_ticket_id_session_id_unique	16 KB
users_branches_pkey	16 KB
users_code_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	16 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
connectors_branches	8 KB
connectors_branches_pkey	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
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
policy	8 KB
policy_pkey	8 KB
queues	8 KB
queues_pkey	8 KB
queues_space_id_order_unique	8 KB
queues_users_pkey	8 KB
slot	8 KB
slot_id_space_id_branch_id_unique	8 KB
ticket_meetings	8 KB
ticket_meetings_pkey	8 KB
ticket_pass	8 KB
ticket_pass_pkey	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	8 KB
user_statuses	8 KB
user_statuses_pkey	8 KB
users_services_pkey	8 KB
users_services_user_id_service_id_unique	8 KB
queues_users	0 Bytes
users_services	0 Bytes