Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

Commit 0550651

Browse filesBrowse files
MasaoFujiiMasaoFujii
committed
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
1 parent d898665 commit 0550651
Copy full SHA for 0550651

File tree

Expand file treeCollapse file tree

2 files changed

+5
-3
lines changed
Filter options
Expand file treeCollapse file tree

2 files changed

+5
-3
lines changed

‎doc/src/sgml/config.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/config.sgml
+3-1Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8319,7 +8319,9 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
83198319
measure the overhead of timing on your system.
83208320
I/O timing information is
83218321
displayed in <link linkend="monitoring-pg-stat-database-view">
8322-
<structname>pg_stat_database</structname></link>, in the output of
8322+
<structname>pg_stat_database</structname></link>,
8323+
<link linkend="monitoring-pg-stat-io-view">
8324+
<structname>pg_stat_io</structname></link>, in the output of
83238325
<xref linkend="sql-explain"/> when the <literal>BUFFERS</literal> option
83248326
is used, in the output of <xref linkend="sql-vacuum"/> when
83258327
the <literal>VERBOSE</literal> option is used, by autovacuum

‎doc/src/sgml/monitoring.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/monitoring.sgml
+2-2Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -180,12 +180,12 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser
180180

181181
<para>
182182
The parameter <xref linkend="guc-track-io-timing"/> enables monitoring
183-
of block read and write times.
183+
of block read, write, extend, and fsync times.
184184
</para>
185185

186186
<para>
187187
The parameter <xref linkend="guc-track-wal-io-timing"/> enables monitoring
188-
of WAL write times.
188+
of WAL write and fsync times.
189189
</para>
190190

191191
<para>

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.