Statistics not updated causes poor query plans
warningperformanceUpdated Jan 21, 2026
Technologies:
How to detect:
Outdated table statistics cause PostgreSQL's query planner to make poor decisions about index usage, join order, and execution strategies, leading to inefficient query plans and slow performance.
Recommended action:
Run ANALYZE on tables after significant data changes. For columns with skewed distributions, increase statistics target with 'ALTER TABLE table ALTER COLUMN column SET STATISTICS 1000' then run ANALYZE. Query pg_stats to verify statistics are current.