Unused index review
Index audit
PostgreSQL index audit for small teams
PostgresAudit separates evidence from advice: index recommendations must be tied to scan counts, query behavior, and human-review risk notes.
Composite index candidates
EXPLAIN required before production changes
Missing index candidates
The audit looks for scan-heavy tables and slow query patterns, then asks for EXPLAIN evidence before treating an index as production-ready.
Unused index candidates
Large non-primary, non-unique indexes with low idx_scan can become review candidates, but PostgresAudit does not recommend blind drops.
Why Evidence Gate matters
AI can suggest plausible indexes. Evidence Gate keeps unsupported claims out of the official findings list unless metrics support the recommendation.