Space
Database Size: 27.3 MB
8 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :gateway_pix, name: "idx_gateway_pix_token" remove_index :gateway_pix, name: "idx_gateway_merchant_payment_id" remove_index :flyway_schema_history, name: "flyway_schema_history_s_idx" remove_index :tokenized_pix_account_events, name: "idx_pix_events_account_id" remove_index :tokenized_pix_account_events, name: "idx_pix_events_created_at" remove_index :tokenized_pix_accounts, name: "idx_tokenized_pix_accounts_created_at" remove_index :tokenized_pix_accounts, name: "idx_tokenized_pix_accounts_status" remove_index :tokenized_pix_accounts, name: "idx_tokenized_pix_accounts_tax_number"
| Relation | Size |
|---|---|
| gateway_pix | 6.31 MB |
| pix_events | 5.3 MB |
| idx_gateway_pix_token UNUSED | 1.53 MB |
| idx_gateway_transaction_token | 1.48 MB |
| gateway_pix_transaction_token_key | 1.1 MB |
| pix_events_pkey | 1.06 MB |
| gateway_pix_pix_token_key | 1.03 MB |
| idx_gateway_merchant_payment_id UNUSED | 864 KB |
| gateway_pix_pkey | 536 KB |
| flyway_schema_history | 16 KB |
| flyway_schema_history_pk | 16 KB |
| flyway_schema_history_s_idx UNUSED | 16 KB |
| disputes | 8 KB |
| disputes_events | 8 KB |
| disputes_events_pkey | 8 KB |
| disputes_pkey | 8 KB |
| idx_pix_events_account_id UNUSED | 8 KB |
| idx_pix_events_created_at UNUSED | 8 KB |
| idx_tokenized_pix_accounts_created_at UNUSED | 8 KB |
| idx_tokenized_pix_accounts_status UNUSED | 8 KB |
| idx_tokenized_pix_accounts_tax_number UNUSED | 8 KB |
| pk_tokenized_pix_account_events | 8 KB |
| pk_tokenized_pix_accounts | 8 KB |
| tokenized_pix_account_events | 8 KB |
| tokenized_pix_accounts | 8 KB |
| uq_tokenized_pix_accounts_account | 8 KB |
| uq_tokenized_pix_accounts_token | 8 KB |