Duplicate Indexes
These indexes exist, but aren’t needed. Remove them for faster writes.
rails generate migration remove_unneeded_indexes
And paste
remove_index :active_inspections, name: "idx_active_inspections_tool_barcode", column: :tool_barcode_id remove_index :tool_statuses, name: "idx_tool_statuses_tool_id", column: :tool_id remove_index :tools, name: "idx_tools_barcode_id", column: :barcode_id
| Details |
|---|
On active_inspections
idx_active_inspections_tool_barcode (tool_barcode_id)is covered by active_inspections_tool_barcode_id_key (tool_barcode_id) |
On tool_statuses
idx_tool_statuses_tool_id (tool_id)is covered by tool_statuses_tool_id_status_type_key (tool_id, status_type) |
On tools
idx_tools_barcode_id (barcode_id)is covered by tools_barcode_id_key (barcode_id) |