Duplicate Indexes
These indexes exist, but aren’t needed. Remove them for faster writes.
rails generate migration remove_unneeded_indexes
And paste
remove_index :services, name: "services_space_id", column: :space_id remove_index :ticket_history, name: "ticket_history_space_id", column: :space_id
| Details |
|---|
On services
services_space_id (space_id)is covered by services_space_id_entity_id_unique (space_id, entity_id) |
On ticket_history
ticket_history_space_id (space_id)is covered by ticket_history_space_id_state_branch_id_created_at_user_id_idx (space_id, state, branch_id, created_at, user_id) |