The new pg_stat_checkpointer view in Postgres 17, and what happened with bgwriter

Author: pganalyze
Published At: 2023-11-09T00:00:00
Length: 04:51

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

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*

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=96f052613f35d07d001c8dd2f284ca8d95f82d1b

*Introduce a new view for checkpointer related stats - on the postgres hackers mailing list*

https://www.postgresql.org/message-id/flat/CALj2ACVxX2ii%3D66RypXRweZe2EsBRiPMj0aHfRfHUeXJcC7kHg%40mail.gmail.com

Translated At: 2025-08-18T13:06:17Z

Request translate (One translation is about 5 minutes)

Version 3 (stable)

Optimized for a single speaker. Suitable for knowledge sharing or teaching videos.

Recommended Videos