PostgreSQL Unused Indexes and Index Bloat: A Safe Cleanup Checklist
Find PostgreSQL unused indexes and bloat with catalog queries, then drop or rebuild them safely by checking stats history, constraints, replicas, and locks.
15 min read
Tag
Find PostgreSQL unused indexes and bloat with catalog queries, then drop or rebuild them safely by checking stats history, constraints, replicas, and locks.
15 min read
Audit a monolith's PostgreSQL indexes per module: find unused, redundant and missing indexes, check replicas and stats age, and drop or add them safely.
15 min read