Duplicate Indexes
These indexes exist, but aren’t needed. Remove them for faster writes.
rails generate migration remove_unneeded_indexes
And paste
remove_index :chunk, name: "chunk_hypertable_id_idx", column: :hypertable_id remove_index :custom_field_connections, name: "idx_cf_connections_custom_field_id", column: :customFieldId
| Details |
|---|
On chunk
chunk_hypertable_id_idx (hypertable_id)is covered by chunk_hypertable_id_creation_time_idx (hypertable_id, creation_time) |
On custom_field_connections
idx_cf_connections_custom_field_id (customFieldId)is covered by unique_cf_connections_field_connection (customFieldId, connectionId) |