PgHero

Space

Database Size: 1.14 GB

12 unused indices. Remove them for faster writes. Check they aren’t used on replicas.

rails generate migration remove_unused_indexes

And paste

remove_index :playback_reports_p20250701, name: "playback_reports_p20250701_cpl_id_inferred_screen_id_start__idx"
remove_index :playback_reports_p20250701, name: "playback_reports_p20250701_cpl_id_start_time_idx"
remove_index :playback_reports_p20251001, name: "playback_reports_p20251001_cpl_id_inferred_screen_id_start__idx"
remove_index :playback_reports_p20250401, name: "playback_reports_p20250401_cpl_id_inferred_screen_id_start__idx"
remove_index :dolby_sms_log_playout_events_p20241001, name: "dolby_sms_log_playout_events_p20241001_playback_report_id_idx"
remove_index :part_config, name: "part_config_type_idx"
remove_index :playback_reports_p20240401, name: "playback_reports_p20240401_inferred_screen_id_start_time_idx"
remove_index :playback_reports_p20250401, name: "playback_reports_p20250401_cpl_id_start_time_idx"
remove_index :playback_reports_p20260401, name: "playback_reports_p20260401_cpl_id_inferred_screen_id_start__idx"
remove_index :playback_reports_p20260401, name: "playback_reports_p20260401_cpl_id_start_time_idx"
remove_index :playback_reports_p20260701, name: "playback_reports_p20260701_cpl_id_inferred_screen_id_start__idx"
remove_index :playback_reports_p20260701, name: "playback_reports_p20260701_cpl_id_start_time_idx"
Relation Size
smlog_events_p20260101 233 MB
dolby_sms_log_events_p20251001 112 MB
smlog_events_p20260101_event_id_device_identifier_device_id_idx 88.8 MB
smlog_events_p20251001 67.8 MB
smlog_events_p20250701 55.1 MB
smlog_events_p20260101_device_identifier_event_time_sequenc_idx 47.1 MB
dolby_sms_log_events_old 44.9 MB
dolby_sms_log_events_p20241001 42.3 MB
cities 34.4 MB
dolby_sms_log_events_p20251001_uidx_evtid_devid_devtype 28.8 MB
dolby_sms_log_events_p20260101 27 MB
smlog_events_p20251001_event_id_device_identifier_device_id_idx 22.7 MB
dolby_sms_log_events_p2025100_device_identifier_event_time__idx 22.3 MB
smlog_events_p20251001_device_identifier_event_time_sequenc_idx 19.7 MB
smlog_events_p20260101_event_time_sequence_idx 19.7 MB
idx_smlog_events_p20250701_event_id_device_id_device_id_type 18.6 MB
smlog_events_p20250701_device_identifier_event_time_sequenc_idx 17.7 MB
smlog_events_p20240401 14.8 MB
idx_dolby_sms_log_events_event_id_device_id_device_id_type 12.1 MB
dolby_sms_log_events_p20250701 11.4 MB
dolby_sms_log_events_p20241001_uidx_evtid_devid_devtype 11 MB
device_changes 10.5 MB
dolby_sms_log_events_p2024100_device_identifier_event_time__idx 7.56 MB
smlog_playout_events_p20250101 7.45 MB
smlog_events_p20251001_event_time_sequence_idx 6.96 MB
dolby_sms_log_events_p2026010_event_id_device_identifier_de_idx 6.91 MB
device_changes_device_id_cert_thumbprint 6.72 MB
smlog_events_p20241001 6.54 MB
smlog_devices 6.23 MB
smlog_events_p20250701_event_time_sequence_idx 5.93 MB
unique_costraint_filename_bucket_name_version_id 5.7 MB
cities_pkey 5.38 MB
smlog_requests 5.2 MB
smlog_playout_events_p20251001 4.86 MB
dolby_sms_log_events_p2026010_device_identifier_event_time__idx 4.72 MB
dolby_sms_log_events_p20250701_uidx_evtid_devid_devtype 3.58 MB
devices 3.28 MB
smlog_playout_events_p20260101 3.2 MB
smlog_playout_events_p20250701 2.79 MB
dolby_sms_log_events_p20250101 2.63 MB
sms_log_events_p20250101 2.55 MB
dolby_sms_log_events_p2025070_device_identifier_event_time__idx 2.45 MB
smlog_playout_events_p20240701 2.42 MB
idx_smlog_events_p20240401_event_id_device_id_device_id_type 2.35 MB
idx_smlog_events_p20241001_event_id_device_id_device_id_type 2.21 MB
idx_smlog_devices 1.95 MB
smlog_events_p20250101 1.84 MB
idx_smlog_playout_events_p20250101_event_id_device_id_device_id 1.79 MB
smlog_playout_events_p20250401 1.66 MB
smlog_events_p20240401_device_identifier_event_time_sequenc_idx 1.63 MB
playback_reports_p20250101 1.61 MB
sms_log_events_old 1.59 MB
playback_reports_p20250701 1.53 MB
smlog_events_p20241001_device_identifier_event_time_sequenc_idx 1.53 MB
dolby_sms_log_playout_events_p20250701 1.41 MB
smlog_playout_events_p2025010_device_identifier_event_time__idx 1.41 MB
smlog_events_p20250401 1.28 MB
dolby_sms_log_events_p20250401_uidx_evtid_devid_devtype 1.16 MB
smlog_playout_events_p2025100_device_identifier_event_time__idx 1.16 MB
smlog_playout_events_p2025100_event_id_device_identifier_de_idx 1.13 MB
smlog_requests_pkey 1.1 MB
playback_reports_p20240701 1.07 MB
assets 1.06 MB
dolby_sms_log_events_p20250401 1.06 MB
playback_reports_p20251001 1.05 MB
playback_reports_p20260101 944 KB
sms_log_events_p20250101_device_id_event_time_event_type_idx 936 KB
playback_reports_p20250401_inferred_screen_id_start_time_idx 880 KB
smlog_playout_events_p2026010_event_id_device_identifier_de_idx 864 KB
playback_reports_p20241001 816 KB
idx_smlog_playout_events_p20240701_event_id_device_id_device_id 800 KB
idx_smlog_playout_events_p20250701_event_id_device_id_device_id 792 KB
screens 768 KB
smlog_playout_events_p2025070_device_identifier_event_time__idx 768 KB
dolby_sms_log_events_p20250101_uidx_evtid_devid_devtype 704 KB
idx_smlog_events_p20250101_event_id_device_id_device_id_type 664 KB
dolby_sms_log_playout_events_p20250401 648 KB
smlog_playout_events_p20250101_event_time_sequence_idx 648 KB
smlog_events_p20240401_event_time_sequence_idx 640 KB
smlog_playout_events_p2026010_device_identifier_event_time__idx 640 KB
device_mappings_3 632 KB
provinces 624 KB
dolby_sms_log_playout_events_p20250401_uidx_evtid_devid_devtype 616 KB
smlog_events_p20241001_event_time_sequence_idx 608 KB
device_mappings_0 576 KB
smlog_playout_events_p2024070_device_identifier_event_time__idx 552 KB
device_mappings_48 544 KB
idx_smlog_playout_events_p20250401_event_id_device_id_device_id 544 KB
smlog_events_p20240701 504 KB
sms_log_events_device_id_event_time_event_type_key 496 KB
dolby_sms_log_events_p2025010_device_identifier_event_time__idx 488 KB
playback_reports_p20250401_pkey 488 KB
idx_assets 472 KB
device_mappings_23 464 KB
device_mappings_32 464 KB
device_mappings_46 464 KB
device_mappings_37 448 KB
idx_smlog_events_p20250401_event_id_device_id_device_id_type 448 KB
device_mappings_30 440 KB
smlog_playout_events_p2025040_device_identifier_event_time__idx 440 KB
cpls 432 KB
device_mappings_31 432 KB
dolby_sms_log_playout_events_old 432 KB
dolby_sms_log_playout_events_p20250101 432 KB
device_mappings_35 424 KB
device_mappings_42 424 KB
device_mappings_13 408 KB
device_mappings_41 408 KB
device_mappings_17 400 KB
device_mappings_8 400 KB
smlog_events_p20250101_device_identifier_event_time_sequenc_idx 400 KB
device_mappings_2 392 KB
device_mappings_24 392 KB
device_mappings_9 392 KB
dolby_sms_log_playout_events_p20251001 392 KB
device_mappings_10 384 KB
device_mappings_47 384 KB
device_mappings_5 384 KB
device_mappings_14 376 KB
device_mappings_19 376 KB
device_mappings_21 376 KB
device_mappings_45 376 KB
device_mappings_49 376 KB
smlog_playout_events_p20241001 376 KB
device_mappings_15 368 KB
device_mappings_16 368 KB
device_mappings_18 368 KB
device_mappings_20 368 KB
device_mappings_22 368 KB
device_mappings_25 368 KB
device_mappings_26 368 KB
device_mappings_27 368 KB
device_mappings_29 368 KB
device_mappings_33 368 KB
device_mappings_36 368 KB
device_mappings_7 368 KB
smlog_playout_events_p20250101_playback_report_id_idx 368 KB
device_mappings_28 360 KB
device_mappings_39 360 KB
device_mappings_4 360 KB
device_mappings_40 360 KB
device_mappings_43 360 KB
device_mappings_6 360 KB
device_mappings_1 352 KB
device_mappings_11 352 KB
device_mappings_12 352 KB
device_mappings_38 352 KB
device_mappings_44 352 KB
smlog_playout_events_p20260101_event_time_sequence_idx 352 KB
device_mappings_34 344 KB
dolby_sms_log_playout_events_p20250701_uidx_evtid_devid_devtype 344 KB
dolby_sms_log_playout_events_p20251001_uidx_evtid_devid_devtype 336 KB
theatres 336 KB
smlog_events_p20250401_device_identifier_event_time_sequenc_idx 320 KB
playback_reports_p20250701_inferred_screen_id_start_time_idx 312 KB
smlog_playout_events_p20250701_event_time_sequence_idx 304 KB
smlog_playout_events_p20251001_event_time_sequence_idx 288 KB
dolby_sms_log_events_p2025040_device_identifier_event_time__idx 280 KB
playback_reports_p20250701_pkey 248 KB
smlog_playout_events_p20250401_event_time_sequence_idx 248 KB
smlog_playout_events_p20251001_playback_report_id_idx 248 KB
dolby_sms_log_playout_events__device_identifier_event_time_idx5 240 KB
smlog_playout_events_p20260101_playback_report_id_idx 240 KB
smlog_playout_events_p20240701_event_time_sequence_idx 224 KB
movies 216 KB
playback_reports_p20250701_device_identifier_start_time_idx 216 KB
playback_reports_p20251001_inferred_screen_id_start_time_idx 216 KB
smlog_playout_events_p20250701_playback_report_id_idx 216 KB
dolby_sms_log_playout_events__device_identifier_event_time_idx6 208 KB
playback_reports_p20250701_cpl_id_inferred_screen_id_start__idx UNUSED 200 KB
playback_reports_p20260101_device_identifier_start_time_idx 200 KB
smlog_playout_events_p20240401 200 KB
smlog_playout_events_p20240701_playback_report_id_idx 200 KB
playback_reports_p20260101_cpl_id_inferred_screen_id_start__idx 176 KB
countries 168 KB
device_mappings_0_pkey 168 KB
device_mappings_3_pkey 168 KB
device_mappings_48_pkey 168 KB
dolby_sms_log_playout_events_p20260101 168 KB
playback_reports_p20250101_inferred_screen_id_start_time_idx 168 KB
playback_reports_p20250101_pkey 168 KB
provinces_pkey 168 KB
smlog_events_p20250101_event_time_sequence_idx 168 KB
device_mappings_23_pkey 152 KB
idx_smlog_events_p20240701_event_id_device_id_device_id_type 152 KB
playback_reports_p20240701_pkey 152 KB
playback_reports_p20250701_cpl_id_start_time_idx UNUSED 152 KB
playback_reports_p20260101_inferred_screen_id_start_time_idx 152 KB
device_mappings_46_pkey 144 KB
chains 136 KB
device_mappings_31_pkey 136 KB
playback_reports_p20250401 136 KB
playback_reports_p20251001_cpl_id_inferred_screen_id_start__idx UNUSED 136 KB
playback_reports_p20251001_device_identifier_start_time_idx 136 KB
smlog_events_p20250401_event_time_sequence_idx 136 KB
currencies 128 KB
device_mappings_32_pkey 128 KB
device_mappings_37_pkey 128 KB
dolby_sms_log_playout_events__event_id_device_identifier_de_idx 128 KB
playback_reports_p20260101_cpl_id_start_time_idx 128 KB
smlog_playout_events_p20250401_playback_report_id_idx 128 KB
device_mappings_35_pkey 120 KB
device_mappings_8_pkey 120 KB
playback_reports_p20240701_inferred_screen_id_start_time_idx 120 KB
playback_reports_p20251001_pkey 120 KB
cpls_pkey 112 KB
device_mappings_18_pkey 112 KB
device_mappings_41_pkey 112 KB
dolby_sms_log_playout_events__device_identifier_event_time_idx7 112 KB
idx_smlog_playout_events_p20241001_event_id_device_id_device_id 112 KB
playback_reports_p20260101_pkey 112 KB
smlog_events_p20240701_device_identifier_event_time_sequenc_idx 112 KB
device_mappings_21_pkey 104 KB
device_mappings_28_pkey 104 KB
device_mappings_36_pkey 104 KB
device_mappings_42_pkey 104 KB
device_mappings_9_pkey 104 KB
dolby_sms_log_playout_events__device_identifier_event_time_idx4 104 KB
playback_reports_p20240401 104 KB
playback_reports_p20241001_pkey 104 KB
playback_reports_p20251001_cpl_id_start_time_idx 104 KB
device_mappings_10_pkey 96 KB
device_mappings_13_pkey 96 KB
device_mappings_16_pkey 96 KB
device_mappings_17_pkey 96 KB
device_mappings_24_pkey 96 KB
device_mappings_26_pkey 96 KB
device_mappings_2_pkey 96 KB
device_mappings_33_pkey 96 KB
device_mappings_38_pkey 96 KB
device_mappings_39_pkey 96 KB
device_mappings_47_pkey 96 KB
dolby_sms_log_playout_events_p20251001_playback_report_id_idx 96 KB
sms_log_events_p20241001 96 KB
device_mappings_11_pkey 88 KB
device_mappings_12_pkey 88 KB
device_mappings_14_pkey 88 KB
device_mappings_15_pkey 88 KB
device_mappings_19_pkey 88 KB
device_mappings_1_pkey 88 KB
device_mappings_20_pkey 88 KB
device_mappings_22_pkey 88 KB
device_mappings_25_pkey 88 KB
device_mappings_27_pkey 88 KB
device_mappings_29_pkey 88 KB
device_mappings_30_pkey 88 KB
device_mappings_34_pkey 88 KB
device_mappings_40_pkey 88 KB
device_mappings_43_pkey 88 KB
device_mappings_44_pkey 88 KB
device_mappings_45_pkey 88 KB
device_mappings_49_pkey 88 KB
device_mappings_4_pkey 88 KB
device_mappings_5_pkey 88 KB
device_mappings_6_pkey 88 KB
device_mappings_7_pkey 88 KB
dolby_sms_log_playout_events_p20250701_playback_report_id_idx 88 KB
idx_smlog_playout_events_p20240401_event_id_device_id_device_id 80 KB
smlog_playout_events_p2024100_device_identifier_event_time__idx 80 KB
sms_log_events_p20250401 80 KB
dolby_sms_log_playout_events_p20250101_uidx_evtid_devid_devtype 72 KB
idx_dolby_sms_log_playout_events_event_id_device_id_device_id_t 72 KB
dolby_sms_log_playout_events_p20250401_playback_report_id_idx 64 KB
languages 64 KB
dolby_sms_log_playout_events__device_identifier_event_time_idx3 56 KB
movie_cpl_mappings 56 KB
smlog_events_p20240701_event_time_sequence_idx 56 KB
smlog_playout_events_p2024040_device_identifier_event_time__idx 56 KB
device_last_played_time 48 KB
smlog_playout_events_p20241001_event_time_sequence_idx 48 KB
devices_pkey 40 KB
languages_pkey 40 KB
screens_pkey 40 KB
smlog_playout_events_p20240401_event_time_sequence_idx 40 KB
smlog_playout_events_p20241001_playback_report_id_idx 40 KB
sms_log_events_p20241001_device_id_event_time_event_type_idx 40 KB
playback_reports_p20241001_inferred_screen_id_start_time_idx 32 KB
playback_reports_p20250401_cpl_id_inferred_screen_id_start__idx UNUSED 32 KB
playback_reports_p20250401_device_identifier_start_time_idx 32 KB
sms_log_events_p20250401_device_id_event_time_event_type_idx 32 KB
chains_pkey 16 KB
countries_pkey 16 KB
currencies_country_id_key 16 KB
device_last_played_time_pkey 16 KB
dolby_sms_log_playout_events__device_identifier_event_time_idx2 16 KB
dolby_sms_log_playout_events_p20241001 16 KB
dolby_sms_log_playout_events_p20241001_playback_report_id_idx UNUSED 16 KB
dolby_sms_log_playout_events_p20241001_uidx_evtid_devid_devtype 16 KB
dolby_sms_log_playout_events_p20250101_playback_report_id_idx 16 KB
dolby_sms_log_playout_events_p20260101_playback_report_id_idx 16 KB
idx_ratings 16 KB
movie_cpl_mappings_cpl_id_key 16 KB
movies_pkey 16 KB
part_config partman 16 KB
part_config_parent_table_pkey partman 16 KB
part_config_type_idx partman UNUSED 16 KB
playback_reports_p20240401_inferred_screen_id_start_time_idx UNUSED 16 KB
playback_reports_p20240401_pkey 16 KB
playback_reports_p20250401_cpl_id_start_time_idx UNUSED 16 KB
ratings 16 KB
ratings_pkey 16 KB
schema_migrations_pkey 16 KB
smlog_playout_events_p20240401_playback_report_id_idx 16 KB
theatres_pkey 16 KB
dolby_sms_log_events_p20240401 8 KB
dolby_sms_log_events_p20240401_uidx_evtid_devid_devtype 8 KB
dolby_sms_log_events_p2024040_device_identifier_event_time__idx 8 KB
dolby_sms_log_events_p20240701 8 KB
dolby_sms_log_events_p20240701_uidx_evtid_devid_devtype 8 KB
dolby_sms_log_events_p2024070_device_identifier_event_time__idx 8 KB
dolby_sms_log_events_p20260401 8 KB
dolby_sms_log_events_p2026040_device_identifier_event_time__idx 8 KB
dolby_sms_log_events_p2026040_event_id_device_identifier_de_idx 8 KB
dolby_sms_log_events_p20260701 8 KB
dolby_sms_log_events_p2026070_device_identifier_event_time__idx 8 KB
dolby_sms_log_events_p2026070_event_id_device_identifier_de_idx 8 KB
dolby_sms_log_events_uidx_eventid_deviceid_devicetype partman 8 KB
dolby_sms_log_playout_events__device_identifier_event_time__idx 8 KB
dolby_sms_log_playout_events__device_identifier_event_time_idx1 8 KB
dolby_sms_log_playout_events__device_identifier_event_time_idx8 8 KB
dolby_sms_log_playout_events__device_identifier_event_time_idx9 8 KB
dolby_sms_log_playout_events__event_id_device_identifier_d_idx1 8 KB
dolby_sms_log_playout_events__event_id_device_identifier_d_idx2 8 KB
dolby_sms_log_playout_events_p20240401 8 KB
dolby_sms_log_playout_events_p20240401_playback_report_id_idx 8 KB
dolby_sms_log_playout_events_p20240401_uidx_evtid_devid_devtype 8 KB
dolby_sms_log_playout_events_p20240701 8 KB
dolby_sms_log_playout_events_p20240701_playback_report_id_idx 8 KB
dolby_sms_log_playout_events_p20240701_uidx_evtid_devid_devtype 8 KB
dolby_sms_log_playout_events_p20260401 8 KB
dolby_sms_log_playout_events_p20260401_playback_report_id_idx 8 KB
dolby_sms_log_playout_events_p20260701 8 KB
dolby_sms_log_playout_events_p20260701_playback_report_id_idx 8 KB
dolby_sms_log_playout_events_uidx_eventid_deviceid_devicetype partman 8 KB
idx_smlog_events_event_id_device_id_device_id_type partman 8 KB
idx_smlog_playout_events_event_id_device_id_device_id_type partman 8 KB
part_config_sub partman 8 KB
part_config_sub_pkey partman 8 KB
playback_reports_p20260401 8 KB
playback_reports_p20260401_cpl_id_inferred_screen_id_start__idx UNUSED 8 KB
playback_reports_p20260401_cpl_id_start_time_idx UNUSED 8 KB
playback_reports_p20260401_device_identifier_start_time_idx 8 KB
playback_reports_p20260401_inferred_screen_id_start_time_idx 8 KB
playback_reports_p20260401_pkey 8 KB
playback_reports_p20260701 8 KB
playback_reports_p20260701_cpl_id_inferred_screen_id_start__idx UNUSED 8 KB
playback_reports_p20260701_cpl_id_start_time_idx UNUSED 8 KB
playback_reports_p20260701_device_identifier_start_time_idx 8 KB
playback_reports_p20260701_inferred_screen_id_start_time_idx 8 KB
playback_reports_p20260701_pkey 8 KB
schema_migrations 8 KB
smlog_events_p20260401 8 KB
smlog_events_p20260401_device_identifier_event_time_sequenc_idx 8 KB
smlog_events_p20260401_event_id_device_identifier_device_id_idx 8 KB
smlog_events_p20260401_event_time_sequence_idx 8 KB
smlog_events_p20260701 8 KB
smlog_events_p20260701_device_identifier_event_time_sequenc_idx 8 KB
smlog_events_p20260701_event_id_device_identifier_device_id_idx 8 KB
smlog_events_p20260701_event_time_sequence_idx 8 KB
smlog_playout_events_p20260401 8 KB
smlog_playout_events_p20260401_event_time_sequence_idx 8 KB
smlog_playout_events_p20260401_playback_report_id_idx 8 KB
smlog_playout_events_p2026040_device_identifier_event_time__idx 8 KB
smlog_playout_events_p2026040_event_id_device_identifier_de_idx 8 KB
smlog_playout_events_p20260701 8 KB
smlog_playout_events_p20260701_event_time_sequence_idx 8 KB
smlog_playout_events_p20260701_playback_report_id_idx 8 KB
smlog_playout_events_p2026070_device_identifier_event_time__idx 8 KB
smlog_playout_events_p2026070_event_id_device_identifier_de_idx 8 KB
sms_log_events_p20240401 8 KB
sms_log_events_p20240401_device_id_event_time_event_type_idx 8 KB
sms_log_events_p20240701 8 KB
sms_log_events_p20240701_device_id_event_time_event_type_idx 8 KB
sms_log_events_p20250701 8 KB
sms_log_events_p20250701_device_id_event_time_event_type_idx 8 KB
sms_log_events_p20251001 8 KB
sms_log_events_p20251001_device_id_event_time_event_type_idx 8 KB
sms_log_events_p20260101 8 KB
sms_log_events_p20260101_device_id_event_time_event_type_idx 8 KB
sms_log_events_p20260401 8 KB
sms_log_events_p20260401_device_id_event_time_event_type_idx 8 KB
sms_log_events_p20260701 8 KB
sms_log_events_p20260701_device_id_event_time_event_type_idx 8 KB
template_dolby_sms_log_events partman 8 KB
template_dolby_sms_log_playout_events partman 8 KB
template_playback_reports partman 8 KB
template_playback_reports_pkey partman 8 KB
template_smlog_events partman 8 KB
template_smlog_playout_events partman 8 KB
template_sms_log_events partman 8 KB