diff options
| author | Michael Paquier <michael@paquier.xyz> | 2023-10-27 11:16:39 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2023-10-27 11:16:39 +0900 |
| commit | 74604a37f2f9eb6e626a4ff3cedd02aef5a2ad59 (patch) | |
| tree | 98c896ef510e28351b45e102e7c9970a0211c535 /doc/src | |
| parent | 0c882a298881056176a27ccc44c5c3bb7c8f308c (diff) | |
| download | postgresql-74604a37f2f9eb6e626a4ff3cedd02aef5a2ad59.tar.gz postgresql-74604a37f2f9eb6e626a4ff3cedd02aef5a2ad59.zip | |
Remove buffers_backend and buffers_backend_fsync from pg_stat_checkpointer
Two attributes related to checkpointer statistics are removed in this
commit:
- buffers_backend, that counts the number of buffers written directly by
a backend.
- buffers_backend_fsync, that counts the number of times a backend had
to do fsync() by its own.
These are actually not checkpointer properties but backend properties.
Also, pg_stat_io provides a more accurate and equivalent report of these
numbers, by tracking all the I/O stats related to backends, including
writes and fsyncs, so storing them in pg_stat_checkpointer was
redundant.
Thanks also to Robert Haas and Amit Kapila for their input.
Bump catalog version.
Author: Bharath Rupireddy
Reviewed-by: Bertrand Drouvot, Andres Freund
Discussion: https://postgr.es/m/20230210004604.mcszbscsqs3bc5nx@awork3.anarazel.de
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 20 |
1 files changed, 0 insertions, 20 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 3f49ff79f34..9fea60b5b21 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -2955,26 +2955,6 @@ description | Waiting for a newly initialized WAL file to reach durable storage <row> <entry role="catalog_table_entry"><para role="column_definition"> - <structfield>buffers_backend</structfield> <type>bigint</type> - </para> - <para> - Number of buffers written directly by a backend - </para></entry> - </row> - - <row> - <entry role="catalog_table_entry"><para role="column_definition"> - <structfield>buffers_backend_fsync</structfield> <type>bigint</type> - </para> - <para> - Number of times a backend had to execute its own - <function>fsync</function> call (normally the background writer handles those - even when the backend does its own write) - </para></entry> - </row> - - <row> - <entry role="catalog_table_entry"><para role="column_definition"> <structfield>buffers_alloc</structfield> <type>bigint</type> </para> <para> |