<ul><li>PostgreSQL 18 introduces per-relation cumulative statistics for [auto]vacuum and [auto]analyze.</li><li>Previously, pg_stat_all_tables provided statistics about vacuum and analyze operations, but not the total time spent.</li><li>In PostgreSQL 18, the view pg_stat_all_tables includes columns for total vacuum and analyze time.</li><li>These statistics help identify relations where [auto]vacuum and [auto]analyze have consumed the most time.</li></ul>

PostgreSQL 18: Per-relation cumulative statistics for [auto]vacuum and [auto]analyze

Discover more