PgHero
No long running queries
Connections healthy 11
Vacuuming healthy
No columns near integer overflow
No invalid indexes or constraints
2 duplicate indexes
Query stats must be enabled for slow queries

Duplicate Indexes

These indexes exist, but aren’t needed. Remove them for faster writes.

rails generate migration remove_unneeded_indexes

And paste

remove_index :cipher_card_tokens, name: "idx_cipher_card_tokens_4", column: :cipher_token
remove_index :cipher_transaction_tokens, name: "idx_cipher_transaction_tokens_4", column: :cipher_token
Details
On cipher_card_tokens
idx_cipher_card_tokens_4 (cipher_token)
is covered by
idx_cipher_card_tokens_3 (cipher_token, card_token)
On cipher_transaction_tokens
idx_cipher_transaction_tokens_4 (cipher_token)
is covered by
uq_cipher_transaction_tokens (cipher_token)

Query Stats

Query stats are available but not enabled.