summaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2023-04-21 07:21:50 +0900
committerMichael Paquier <michael@paquier.xyz>2023-04-21 07:21:50 +0900
commit0ecb87e1fa07a733494e35636e55807b0f3fc1ed (patch)
tree958227cf546cbf36d6e6791866785cef1c49ddb6 /doc
parenteab2d3147e3c13aca4a9aca52c0a9a581a8d224a (diff)
downloadpostgresql-0ecb87e1fa07a733494e35636e55807b0f3fc1ed.tar.gz
Remove io prefix from pg_stat_io columns
a9c70b46 added the statistics view pg_stat_io which contained columns "io_context" and "io_object". Given that the columns are in the pg_stat_io view, the "io" prefix is somewhat redundant, so remove it. The code variables referring to these fields are kept unchanged so as they can keep their context about I/O. Bump catalog version. Author: Melanie Plageman Reviewed-by: Kyotaro Horiguchi, Fabrízio de Royes Mello Discussion: https://postgr.es/m/CAAKRu_aAQoJWrvT2BYYQvJChFKra_O-5ra3jhzKJZqWsTR1CPQ@mail.gmail.com
Diffstat (limited to 'doc')
-rw-r--r--doc/src/sgml/monitoring.sgml22
1 files changed, 11 insertions, 11 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index 2903b67170..99f7f95c39 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -3754,7 +3754,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
<row>
<entry role="catalog_table_entry">
<para role="column_definition">
- <structfield>io_object</structfield> <type>text</type>
+ <structfield>object</structfield> <type>text</type>
</para>
<para>
Target object of an I/O operation. Possible values are:
@@ -3777,7 +3777,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
<row>
<entry role="catalog_table_entry">
<para role="column_definition">
- <structfield>io_context</structfield> <type>text</type>
+ <structfield>context</structfield> <type>text</type>
</para>
<para>
The context of an I/O operation. Possible values are:
@@ -3786,10 +3786,10 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
<listitem>
<para>
<literal>normal</literal>: The default or standard
- <varname>io_context</varname> for a type of I/O operation. For
+ <varname>context</varname> for a type of I/O operation. For
example, by default, relation data is read into and written out from
shared buffers. Thus, reads and writes of relation data to and from
- shared buffers are tracked in <varname>io_context</varname>
+ shared buffers are tracked in <varname>context</varname>
<literal>normal</literal>.
</para>
</listitem>
@@ -3798,7 +3798,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
<literal>vacuum</literal>: I/O operations performed outside of shared
buffers while vacuuming and analyzing permanent relations. Temporary
table vacuums use the same local buffer pool as other temporary table
- IO operations and are tracked in <varname>io_context</varname>
+ IO operations and are tracked in <varname>context</varname>
<literal>normal</literal>.
</para>
</listitem>
@@ -3929,9 +3929,9 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
buffer in order to make it available for another use.
</para>
<para>
- In <varname>io_context</varname> <literal>normal</literal>, this counts
+ In <varname>context</varname> <literal>normal</literal>, this counts
the number of times a block was evicted from a buffer and replaced with
- another block. In <varname>io_context</varname>s
+ another block. In <varname>context</varname>s
<literal>bulkwrite</literal>, <literal>bulkread</literal>, and
<literal>vacuum</literal>, this counts the number of times a block was
evicted from shared buffers in order to add the shared buffer to a
@@ -3949,7 +3949,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
The number of times an existing buffer in a size-limited ring buffer
outside of shared buffers was reused as part of an I/O operation in the
<literal>bulkread</literal>, <literal>bulkwrite</literal>, or
- <literal>vacuum</literal> <varname>io_context</varname>s.
+ <literal>vacuum</literal> <varname>context</varname>s.
</para>
</entry>
</row>
@@ -3961,7 +3961,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
</para>
<para>
Number of <literal>fsync</literal> calls. These are only tracked in
- <varname>io_context</varname> <literal>normal</literal>.
+ <varname>context</varname> <literal>normal</literal>.
</para>
</entry>
</row>
@@ -3997,7 +3997,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
in some I/O contexts. These rows are omitted from the view. For example, the
checkpointer does not checkpoint temporary tables, so there will be no rows
for <varname>backend_type</varname> <literal>checkpointer</literal> and
- <varname>io_object</varname> <literal>temp relation</literal>.
+ <varname>object</varname> <literal>temp relation</literal>.
</para>
<para>
@@ -4005,7 +4005,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
backend types or on certain I/O objects and/or in certain I/O contexts.
These cells will be NULL. For example, temporary tables are not
<literal>fsync</literal>ed, so <varname>fsyncs</varname> will be NULL for
- <varname>io_object</varname> <literal>temp relation</literal>. Also, the
+ <varname>object</varname> <literal>temp relation</literal>. Also, the
background writer does not perform reads, so <varname>reads</varname> will
be NULL in rows for <varname>backend_type</varname> <literal>background
writer</literal>.