We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
The new pg_stat_checkpointer view in Postgres 17, and what happened with bgwriter
Summary
Description
*Find the article on our blog here:*
https://pganalyze.com/blog/5mins-postgres-17-pg-stat-checkpointer-bgwriter
Today, we're going to talk about the new pg_stat_checkpointer in Postgres 17, and how that changed the pg_stat_bgwriter, or background writer, statistics. We are also looking at the impact these changes have on shared buffers, the Postgres WAL, and pg_stat_io.
*Learn more about pganalyze:*
https://pganalyze.com/newsletter
https://twitter.com/pganalyze/
*Check out the pganalyze library for eBooks, webinars, and more:*
https://pganalyze.com/resources
📑 *What we have discussed in this episode of 5mins of Postgres:*
*PostgreSQL 17: New catalog view pg_stat_checkpointer - by Daniel Westermann*
https://www.dbi-services.com/blog/postgresql-17-new-catalog-view-pg_stat_checkpointer/
*Daniel Westermann on LinkedIn*
https://www.linkedin.com/in/daniel-westermann/
*pg_stat_bgwriter view on postgresql.org*
https://www.postgresql.org/docs/16/monitoring-stats.html#MONITORING-PG-STAT-BGWRITER-VIEW
*2011 commit by Simon Riggs to split work into bgwriter and checkpointer*
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=806a2aee3791
*Introduce pg_stat_checkpointer - commit by Michael Paquier*
*Introduce a new view for checkpointer related stats - on the postgres hackers mailing list*
Translated At: 2025-08-18T13:06:17Z