Overview

I used to think more indexes always meant faster queries.

Production taught me about write amplification and table bloat instead.

We had three indexes that nothing queried, slowing every insert.

EXPLAIN ANALYZE finally showed which plans actually used which indexes.

After dropping the dead ones, writes got healthier without hurting reads.

Now I review unused indexes in the same ritual as reviewing slow queries.