diff options
| author | Michael Paquier <michael@paquier.xyz> | 2025-02-20 14:16:23 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2025-02-20 14:16:23 +0900 |
| commit | 4538bd3f1dde065820438ea461ad30c993982d92 (patch) | |
| tree | 017ee32f42fa426f400889c112e4fcf4ebe19ada /doc/src | |
| parent | 2f70871c2bc18d103d5dd25ff9d91e0da29412ee (diff) | |
| download | postgresql-4538bd3f1dde065820438ea461ad30c993982d92.tar.gz postgresql-4538bd3f1dde065820438ea461ad30c993982d92.zip | |
doc: Add details about object "wal" in pg_stat_io
This commit adds a short description of what kind of activity is tracked
in pg_stat_io for the object "wal", with a link pointing to the section
"WAL configuration" that has a lot of details on the matter.
This should perhaps have been added in a051e71e28a1, but things are what
they are.
Author: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Discussion: https://postgr.es/m/Z7RkQ0EfYaqqjgz/@ip-10-97-1-34.eu-west-3.compute.internal
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 928a6eb64b0..71c4f96d054 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -2931,6 +2931,16 @@ description | Waiting for a newly initialized WAL file to reach durable storage </para> <para> + For the <varname>object</varname> <literal>wal</literal>, + <varname>fsyncs</varname> and <varname>fsync_time</varname> track the + fsync activity of WAL files done in <function>issue_xlog_fsync</function>. + <varname>writes</varname> and <varname>write_time</varname> + track the write activity of WAL files done in + <function>XLogWrite</function>. + See <xref linkend="wal-configuration"/> for more information. + </para> + + <para> <structname>pg_stat_io</structname> can be used to inform database tuning. For example: <itemizedlist> |