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