Space
Database Size: 9.22 MB
9 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :users, name: "idx_users_settings" remove_index :active_inspections, name: "idx_active_inspections_status" remove_index :active_inspections, name: "idx_active_inspections_tool_barcode" remove_index :inspection_history, name: "idx_inspection_history_completed_at" remove_index :inspection_history, name: "idx_inspection_history_tool_barcode" remove_index :tool_statuses, name: "idx_tool_statuses_tool_id" remove_index :tools, name: "idx_tools_barcode_id" remove_index :workflow_executions, name: "idx_workflow_executions_status" remove_index :workflow_executions, name: "idx_workflow_executions_tool_barcode"
| Relation | Size |
|---|---|
| idx_users_settings UNUSED | 168 KB |
| workflow_executions | 144 KB |
| users | 88 KB |
| tool_statuses | 64 KB |
| active_inspections | 48 KB |
| inspection_history | 48 KB |
| active_inspections_pkey | 16 KB |
| active_inspections_tool_barcode_id_key | 16 KB |
| idx_active_inspections_status UNUSED | 16 KB |
| idx_active_inspections_tool_barcode UNUSED | 16 KB |
| idx_inspection_history_completed_at UNUSED | 16 KB |
| idx_inspection_history_tool_barcode UNUSED | 16 KB |
| idx_tool_statuses_tool_id UNUSED | 16 KB |
| idx_tools_barcode_id UNUSED | 16 KB |
| idx_workflow_executions_status UNUSED | 16 KB |
| idx_workflow_executions_tool_barcode UNUSED | 16 KB |
| inspection_history_pkey | 16 KB |
| tool_statuses_pkey | 16 KB |
| tool_statuses_tool_id_status_type_key | 16 KB |
| tools | 16 KB |
| tools_barcode_id_key | 16 KB |
| tools_pkey | 16 KB |
| users_email_key | 16 KB |
| users_pkey | 16 KB |
| users_username_key | 16 KB |
| workflow_executions_pkey | 16 KB |