Space

Database Size: 22.5 GB

24 unused indices. Remove them for faster writes.

rails generate migration remove_unused_indexes

And paste

remove_index :data_json_202508, name: "idx_data_json_202508_ip_time"
remove_index :data_snmp_202511, name: "idx_snmp_202511_ten_latest"
remove_index :data_json_202507, name: "idx_data_json_202507_ip_time"
remove_index :data_json_202506, name: "idx_data_json_202506_ip_time"
remove_index :data_snmp_202510, name: "idx_data_snmp_202510_type_lower"
remove_index :data_json_202509, name: "idx_data_json_202509_ip_time"
remove_index :data_json_202511, name: "data_json_202511_time_unix"
remove_index :data_json_202511, name: "data_json_202511_type"
remove_index :data_json_202512, name: "data_json_202512_time_unix"
remove_index :data_json_202512, name: "data_json_202512_type"
remove_index :data_json_202505, name: "idx_data_json_202505_ip_time"
remove_index :assets, name: "assets_host_name"
remove_index :corelink_node, name: "idx_corelink_node_ip_inet"
remove_index :onboarding_transactions, name: "idx_ot_tlm_latest"
remove_index :part_numbers, name: "idx_pn_cat_subcat"
remove_index :part_number_classifications, name: "idx_pnc_level_parent"
remove_index :sites, name: "idx_sites_name"
remove_index :sites, name: "idx_sites_name_lower"
remove_index :telemetrylink_module, name: "idx_tlm_t1"
remove_index :telemetrylink_module, name: "idx_tlm_t2"
remove_index :telemetrylink_module, name: "idx_tlm_t3"
remove_index :jobs, name: "jobs_queue_index"
remove_index :sessions, name: "sessions_last_activity_index"
remove_index :sessions, name: "sessions_user_id_index"

Relation	Size
data_json_202508	2.74 GB
data_json_202507	2.72 GB
data_snmp_202511	2.63 GB
data_json_202511	2.25 GB
data_json_202506	1.69 GB
data_json_202509	1.5 GB
data_snmp_202510	1.46 GB
data_json_202510	1.32 GB
data_snmp_202512	1010 MB
idx_data_snmp_202511_rtu_type_time_seq	817 MB
data_snmp_202511_rtu_id_type_time_index	670 MB
data_json_202512	446 MB
idx_data_snmp_202512_rtu_type_time_seq	363 MB
idx_data_snmp_202510_rtu_type_time_seq	320 MB
data_snmp_202512_rtu_id_type_time_index	298 MB
data_snmp_202511_pkey	265 MB
data_snmp_202510_rtu_id_type_time_index	262 MB
data_snmp_202509	192 MB
data_snmp_202510_pkey	145 MB
idx_snmp_202511_unix_time	127 MB
data_snmp_202512_pkey	92.1 MB
idx_data_json_202511_ip_time	85.6 MB
idx_data_snmp_202511_type_lower	79.6 MB
idx_data_snmp_ip_inet	79.3 MB
idx_data_json_202508_ip_time UNUSED	77.6 MB
idx_snmp_202511_ten_latest UNUSED	77.5 MB
idx_data_json_202507_ip_time UNUSED	76.6 MB
idx_snmp_202512_unix_time	68.6 MB
data_json_202511_ip_time_unix	67.5 MB
data_json_202508_pkey	55.3 MB
data_json_202507_pkey	54.5 MB
idx_snmp_202512_ten_latest	51.6 MB
idx_data_json_202506_ip_time UNUSED	49.2 MB
data_json_202511_pkey	48.1 MB
idx_data_snmp_202510_type_lower UNUSED	44.8 MB
idx_data_json_202509_ip_time UNUSED	43.6 MB
idx_data_json_202510_ip_time	37.8 MB
data_json_202506_pkey	35.6 MB
data_json_202509_pkey	31.1 MB
data_snmp_202509_rtu_id_type_time_index	29.7 MB
data_json_202510_pkey	26.9 MB
idx_data_snmp_202512_type_lower	26.7 MB
data_json_202511_time_unix UNUSED	19.6 MB
data_json_202512_ip_time_unix	19.5 MB
idx_data_json_202512_ip_time	18.4 MB
data_snmp_202509_pkey	16.6 MB
data_json_202511_ip	14.9 MB
data_json_202511_type UNUSED	14.9 MB
data_json_202505	14.7 MB
data_json_202512_pkey	9.29 MB
data_json_202512_time_unix UNUSED	3.89 MB
data_json_202504	2.88 MB
data_json_202512_type UNUSED	2.79 MB
data_json_202504_pkey	528 KB
data_json_202505_pkey	352 KB
idx_data_json_202505_ip_time UNUSED	288 KB
configuration_pushes	216 KB
part_number_data_points	112 KB
ac_ct	80 KB
onboarding_transactions	80 KB
assets	72 KB
trh_sensor	56 KB
part_number_data_points_pkey	32 KB
ac_ct_pkey	16 KB
asset_images	16 KB
asset_images_pkey	16 KB
assets_host_name UNUSED	16 KB
assets_pkey	16 KB
clusters	16 KB
clusters_name_unique	16 KB
clusters_pkey	16 KB
clusters_short_name_unique	16 KB
configuration_pushes_pkey	16 KB
corelink_node	16 KB
corelink_node_pkey	16 KB
etu_ip_list	16 KB
etu_ip_list_pkey	16 KB
idx_assets_site_pn	16 KB
idx_corelink_node_ip	16 KB
idx_corelink_node_ip_inet UNUSED	16 KB
idx_ot_tlm_latest UNUSED	16 KB
idx_pn_cat_subcat UNUSED	16 KB
idx_pnc_level_parent UNUSED	16 KB
idx_sites_name UNUSED	16 KB
idx_sites_name_lower UNUSED	16 KB
idx_tenant_dsid	16 KB
idx_tlm_t1 UNUSED	16 KB
idx_tlm_t2 UNUSED	16 KB
idx_tlm_t3 UNUSED	16 KB
migrations_pkey	16 KB
onboarding_transactions_pkey	16 KB
part_number_attachments	16 KB
part_number_attachments_pkey	16 KB
part_number_classifications	16 KB
part_number_classifications_parent_id_short_name_unique	16 KB
part_number_classifications_pkey	16 KB
part_number_classifications_title_parent_id_unique	16 KB
part_numbers	16 KB
part_numbers_name_unique	16 KB
part_numbers_pkey	16 KB
part_numbers_short_name_unique	16 KB
sites	16 KB
sites_name_unique	16 KB
sites_pkey	16 KB
telemetrylink_module	16 KB
telemetrylink_module_pkey	16 KB
tenant	16 KB
tenant_pkey	16 KB
trh_sensor_asset_qr_key	16 KB
trh_sensor_pkey	16 KB
trh_sensor_unique_address_per_module	16 KB
users	16 KB
users_email_unique	16 KB
users_pkey	16 KB
asset_additional_data	8 KB
asset_additional_data_pics	8 KB
asset_additional_data_pics_pkey	8 KB
asset_additional_data_pkey	8 KB
cache	8 KB
cache_locks	8 KB
cache_locks_pkey	8 KB
cache_pkey	8 KB
failed_jobs	8 KB
failed_jobs_pkey	8 KB
failed_jobs_uuid_unique	8 KB
job_batches	8 KB
job_batches_pkey	8 KB
jobs	8 KB
jobs_pkey	8 KB
jobs_queue_index UNUSED	8 KB
migrations	8 KB
password_reset_tokens	8 KB
password_reset_tokens_pkey	8 KB
performance_curve	8 KB
sessions	8 KB
sessions_last_activity_index UNUSED	8 KB
sessions_pkey	8 KB
sessions_user_id_index UNUSED	8 KB