From 4538bd3f1dde065820438ea461ad30c993982d92 Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Thu, 20 Feb 2025 14:16:23 +0900 Subject: [PATCH] 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 Discussion: https://postgr.es/m/Z7RkQ0EfYaqqjgz/@ip-10-97-1-34.eu-west-3.compute.internal --- doc/src/sgml/monitoring.sgml | 10 ++++++++++ 1 file changed, 10 insertions(+) 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 @@ -2930,6 +2930,16 @@ description | Waiting for a newly initialized WAL file to reach durable storage writer. + + For the object wal, + fsyncs and fsync_time track the + fsync activity of WAL files done in issue_xlog_fsync. + writes and write_time + track the write activity of WAL files done in + XLogWrite. + See for more information. + + pg_stat_io can be used to inform database tuning. For example: -- 2.39.5