Space
Database Size: 1.67 GB
7 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :business_reconciliation, name: "idx_business_recon_mailable" remove_index :business_audit_log, name: "idx_business_audit_log_applied_at" remove_index :business_audit_log, name: "idx_business_audit_log_business_id" remove_index :business_audit_log, name: "idx_business_audit_log_field_name" remove_index :staging_business, name: "staging_business_address_city_address_state_address_zip_idx" remove_index :staging_business, name: "staging_business_src_agb_id_idx" remove_index :staging_business, name: "staging_business_website_normalized_idx"
| Relation | Size |
|---|---|
| id_lookup | 810 MB |
| id_lookup_pkey | 528 MB |
| business_reconciliation | 235 MB |
| business_reconciliation_agb_doc_id_key | 41.5 MB |
| business_id_idx | 40.1 MB |
| business_reconciliation_pkey | 19.7 MB |
| idx_business_recon_audit_has_changes | 8.42 MB |
| idx_business_recon_mailable UNUSED | 8.08 MB |
| idx_business_recon_validation_state | 6.8 MB |
| idx_business_recon_mailable_reason | 5.7 MB |
| business_audit_log | 8 KB |
| business_audit_log_pkey | 8 KB |
| idx_business_audit_log_applied_at UNUSED | 8 KB |
| idx_business_audit_log_business_id UNUSED | 8 KB |
| idx_business_audit_log_field_name UNUSED | 8 KB |
| staging_business | 8 KB |
| staging_business_address_city_address_state_address_zip_idx UNUSED | 8 KB |
| staging_business_pkey | 8 KB |
| staging_business_src_agb_id_idx UNUSED | 8 KB |
| staging_business_website_normalized_idx UNUSED | 8 KB |
| validator_log | 8 KB |
| validator_log_pkey | 8 KB |