diff options
| author | Fujii Masao <fujii@postgresql.org> | 2024-09-19 02:14:10 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2024-09-19 02:14:10 +0900 |
| commit | a7c39db5eb342dd491dacf39546486c6a539ea43 (patch) | |
| tree | 5924630c70bbd7b9bf5181cb62a5902998aae857 /doc/src | |
| parent | 24f5205948093a96edf8213294b3d585ac3fe1fb (diff) | |
| download | postgresql-a7c39db5eb342dd491dacf39546486c6a539ea43.tar.gz postgresql-a7c39db5eb342dd491dacf39546486c6a539ea43.zip | |
docs: Improve the description of num_timed column in pg_stat_checkpointer.
The previous documentation stated that num_timed reflects the number of
scheduled checkpoints performed. However, checkpoints may be skipped
if the server has been idle, and num_timed counts both skipped and completed
checkpoints. This commit clarifies the description to make it clear that
the counter includes both skipped and completed checkpoints.
Back-patch to v17 where pg_stat_checkpointer was added.
Author: Fujii Masao
Reviewed-by: Alexander Korotkov
Discussion: https://postgr.es/m/9ea77f40-818d-4841-9dee-158ac8f6e690@oss.nttdata.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 933de6fe07f..a2fda4677d7 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -3051,7 +3051,10 @@ description | Waiting for a newly initialized WAL file to reach durable storage <structfield>num_timed</structfield> <type>bigint</type> </para> <para> - Number of scheduled checkpoints that have been performed + Number of scheduled checkpoints due to timeout. + Note that checkpoints may be skipped if the server has been idle + since the last one, and this value counts both completed and + skipped checkpoints </para></entry> </row> |