Postgres Unused Indexes: How to Find and Drop Them Safely
Postgres unused indexes slow every write and bloat storage. Here is the SQL to find them, the traps that make idx_scan = 0 misleading, and how to drop them safely.
Fintel Analytics blog
Expert perspectives on data analytics, AI agents, internal tools, and business intelligence from the Fintel Analytics team.
2 of 234 posts
Postgres unused indexes slow every write and bloat storage. Here is the SQL to find them, the traps that make idx_scan = 0 misleading, and how to drop them safely.
Dashboards hitting your production Postgres database can slow your whole product. Here is the SQL to find the culprit queries in five minutes, fix them and keep them from coming back.