Space
Database Size: 8.04 MB
13 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :cipher_transaction_tokens, name: "idx_cipher_transaction_tokens_1" remove_index :cipher_transaction_tokens, name: "idx_cipher_transaction_tokens_3" remove_index :cipher_transaction_tokens, name: "idx_cipher_transaction_tokens_5" remove_index :cipher_transaction_tokens, name: "idx_cipher_transaction_tokens_2" remove_index :flyway_schema_history, name: "flyway_schema_history_s_idx" remove_index :cipher_card_tokens, name: "idx_cipher_card_tokens_1" remove_index :cipher_card_tokens, name: "idx_cipher_card_tokens_2" remove_index :cipher_card_tokens, name: "idx_cipher_card_tokens_3" remove_index :cipher_card_tokens, name: "idx_cipher_card_tokens_4" remove_index :cipher_card_tokens, name: "idx_cipher_card_tokens_5" remove_index :cipher_card_tokens, name: "idx_cipher_card_tokens_public_route" remove_index :cipher_transaction_tokens, name: "idx_cipher_transaction_tokens_4" remove_index :cipher_transaction_tokens, name: "idx_cipher_transaction_tokens_public_route"
| Relation | Size |
|---|---|
| cipher_transaction_tokens | 64 KB |
| idx_cipher_transaction_tokens_1 UNUSED | 40 KB |
| idx_cipher_transaction_tokens_3 UNUSED | 40 KB |
| idx_cipher_transaction_tokens_5 UNUSED | 40 KB |
| idx_cipher_transaction_tokens_2 UNUSED | 32 KB |
| flyway_schema_history | 16 KB |
| flyway_schema_history_pk | 16 KB |
| flyway_schema_history_s_idx UNUSED | 16 KB |
| idx_cipher_card_tokens_1 UNUSED | 16 KB |
| idx_cipher_card_tokens_2 UNUSED | 16 KB |
| idx_cipher_card_tokens_3 UNUSED | 16 KB |
| idx_cipher_card_tokens_4 UNUSED | 16 KB |
| idx_cipher_card_tokens_5 UNUSED | 16 KB |
| idx_cipher_card_tokens_public_route UNUSED | 16 KB |
| idx_cipher_transaction_tokens_4 UNUSED | 16 KB |
| idx_cipher_transaction_tokens_public_route UNUSED | 16 KB |
| pk_cipher_card_tokens | 16 KB |
| pk_cipher_transaction_tokens | 16 KB |
| uq_cipher_card_tokens | 16 KB |
| uq_cipher_transaction_tokens | 16 KB |
| cipher_card_tokens | 8 KB |
| cipher_token_events | 8 KB |
| pk_cipher_token_events | 8 KB |