postgres.git / summary / log / commit / refs

commit    0d483ad4cc4c4d4ebdbe456a5565f11fa137bd24
Author:   Fujii Masao <fujii@postgresql.org>
Date:     Wed Jul 10 06:56:07 2024 +0000
First released in: 18.0, 16.4, 17.0

    doc: Update track_io_timing documentation to mention pg_stat_io.
    
    The I/O timing information collected when track_io_timing is
    enabled is now documented to appear in the pg_stat_io view,
    which was previously not mentioned.
    
    This commit also enhances the description of track_io_timing
    to clarify that it monitors not only block read and write
    but also block extend and fsync operations. Additionally,
    the description of track_wal_io_timing has been improved
    to mention both WAL write and WAL fsync monitoring.
    
    Backpatch to v16 where pg_stat_io was added.
    
    Author: Hajime Matsunaga
    Reviewed-by: Melanie Plageman, Nazir Bilal Yavuz, Fujii Masao
    Discussion: https://postgr.es/m/TYWPR01MB10742EE4A6F34C33061429D38A4D52@TYWPR01MB10742.jpnprd01.prod.outlook.com


 doc/src/sgml/config.sgml     | 4 +++-
 doc/src/sgml/monitoring.sgml | 4 ++--
 2 files changed, 5 insertions(+), 3 deletions(-)

diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 8f0fd147a2a..3ef99e2ee08 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -8131,7 +8131,9 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
         measure the overhead of timing on your system.
         I/O timing information is
         displayed in <link linkend="monitoring-pg-stat-database-view">
-        <structname>pg_stat_database</structname></link>, in the output of
+        <structname>pg_stat_database</structname></link>,
+        <link linkend="monitoring-pg-stat-io-view">
+        <structname>pg_stat_io</structname></link>, in the output of
         <xref linkend="sql-explain"/> when the <literal>BUFFERS</literal> option
         is used, in the output of <xref linkend="sql-vacuum"/> when
         the <literal>VERBOSE</literal> option is used, by autovacuum
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index d16da9c1877..d7f2f90ba12 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -180,12 +180,12 @@ postgres   27093  0.0  0.0  30096  2752 ?        Ss   11:34   0:00 postgres: ser
 
   <para>
    The parameter <xref linkend="guc-track-io-timing"/> enables monitoring
-   of block read and write times.
+   of block read, write, extend, and fsync times.
   </para>
 
   <para>
    The parameter <xref linkend="guc-track-wal-io-timing"/> enables monitoring
-   of WAL write times.
+   of WAL write and fsync times.
   </para>
 
   <para>


[parent: 4ac08251eb3d]