pg_stats: How Postgres Internal Stats Work | POSETTE: An Event for Postgres 2026
Postgres uses pg_statistic stats like correlation and most-common-values to decide between sequential and index scans.
“Now you might be tempted to think that something's broken, but it's actually working just fine.”
A conference talk explains how Postgres internal statistics in pg_statistic (viewed via pg_stats) inform the query planner's cost-based choice between sequential and index scans. It is an educational database tutorial with no meaningful AI industry signal.