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 |