From 17cc5f666f6aada21eb3237974c50681ba4814ea Mon Sep 17 00:00:00 2001 From: Fujii Masao Date: Wed, 2 Oct 2024 11:17:47 +0900 Subject: Fix inconsistent reporting of checkpointer stats. Previously, the pg_stat_checkpointer view and the checkpoint completion log message could show different numbers for buffers written during checkpoints. The view only counted shared buffers, while the log message included both shared and SLRU buffers, causing inconsistencies. This commit resolves the issue by updating both the view and the log message to separately report shared and SLRU buffers written during checkpoints. A new slru_written column is added to the pg_stat_checkpointer view to track SLRU buffers, while the existing buffers_written column now tracks only shared buffers. This change would help users distinguish between the two types of buffers, in the pg_stat_checkpointer view and the checkpoint complete log message, respectively. Bump catalog version. Author: Nitin Jadhav Reviewed-by: Bharath Rupireddy, Michael Paquier, Kyotaro Horiguchi, Robert Haas Reviewed-by: Andres Freund, vignesh C, Fujii Masao Discussion: https://postgr.es/m/CAMm1aWb18EpT0whJrjG+-nyhNouXET6ZUw0pNYYAe+NezpvsAA@mail.gmail.com --- doc/src/sgml/monitoring.sgml | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 48ffe87241c..331315f8d3c 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -3127,7 +3127,16 @@ description | Waiting for a newly initialized WAL file to reach durable storage buffers_written bigint - Number of buffers written during checkpoints and restartpoints + Number of shared buffers written during checkpoints and restartpoints + + + + + + slru_written bigint + + + Number of SLRU buffers written during checkpoints and restartpoints -- cgit v1.2.3