From 559efce1d684069acf234a5cb032acba84e70938 Mon Sep 17 00:00:00 2001 From: Fujii Masao Date: Mon, 30 Sep 2024 11:56:05 +0900 Subject: Add num_done counter to the pg_stat_checkpointer view. Checkpoints can be skipped when the server is idle. The existing num_timed and num_requested counters in pg_stat_checkpointer track both completed and skipped checkpoints, but there was no way to count only the completed ones. This commit introduces the num_done counter, which tracks only completed checkpoints, making it easier to see how many were actually performed. Bump catalog version. Author: Anton A. Melnikov Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/9ea77f40-818d-4841-9dee-158ac8f6e690@oss.nttdata.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 db7f35a4515..d83e99da495 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -3063,7 +3063,16 @@ description | Waiting for a newly initialized WAL file to reach durable storage num_requested bigint - Number of requested checkpoints that have been performed + Number of backend requested checkpoints + + + + + + num_done bigint + + + Number of checkpoints that have been performed -- cgit v1.2.3