Duplicate Indexes
These indexes exist, but aren’t needed. Remove them for faster writes.
rails generate migration remove_unneeded_indexes
And paste
remove_index :corelink_node, name: "idx_corelink_node_ip_inet", column: :ip remove_index :data_json_202511, name: "data_json_202511_ip", column: :ip remove_index :sites, name: "idx_sites_name", column: :name
| Details |
|---|
On corelink_node
idx_corelink_node_ip_inet (ip)is covered by idx_corelink_node_ip (ip) |
On data_json_202511
data_json_202511_ip (ip)is covered by data_json_202511_ip_time_unix (ip, time_unix) |
On sites
idx_sites_name (name)is covered by sites_name_unique (name) |