Home Explore Blog CI



postgresql

34th chunk of `doc/src/sgml/monitoring.sgml`
18881a562ca6b8394ce8fae21720938b824f8431a394fcfe0000000100000fa5
 </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>reads</structfield> <type>bigint</type>
       </para>
       <para>
        Number of read operations.
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>read_bytes</structfield> <type>numeric</type>
       </para>
       <para>
        The total size of read operations in bytes.
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>read_time</structfield> <type>double precision</type>
       </para>
       <para>
        Time spent waiting for read operations in milliseconds (if
        <xref linkend="guc-track-io-timing"/> is enabled and
        <varname>object</varname> is not <literal>wal</literal>,
        or if <xref linkend="guc-track-wal-io-timing"/> is enabled
        and <varname>object</varname> is <literal>wal</literal>,
        otherwise zero)
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>writes</structfield> <type>bigint</type>
       </para>
       <para>
        Number of write operations.
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>write_bytes</structfield> <type>numeric</type>
       </para>
       <para>
        The total size of write operations in bytes.
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>write_time</structfield> <type>double precision</type>
       </para>
       <para>
        Time spent waiting for write operations in milliseconds (if
        <xref linkend="guc-track-io-timing"/> is enabled and
        <varname>object</varname> is not <literal>wal</literal>,
        or if <xref linkend="guc-track-wal-io-timing"/> is enabled
        and <varname>object</varname> is <literal>wal</literal>,
        otherwise zero)
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>writebacks</structfield> <type>bigint</type>
       </para>
       <para>
        Number of units of size <symbol>BLCKSZ</symbol> (typically 8kB) which
        the process requested the kernel write out to permanent storage.
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>writeback_time</structfield> <type>double precision</type>
       </para>
       <para>
        Time spent waiting for writeback operations in milliseconds (if
        <xref linkend="guc-track-io-timing"/> is enabled, otherwise zero). This
        includes the time spent queueing write-out requests and, potentially,
        the time spent to write out the dirty data.
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>extends</structfield> <type>bigint</type>
       </para>
       <para>
        Number of relation extend operations.
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>extend_bytes</structfield> <type>numeric</type>
       </para>
       <para>
        The total size of relation extend operations in bytes.
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>extend_time</structfield> <type>double precision</type>
       </para>
       <para>
        Time spent waiting for extend operations in milliseconds.

Title: pg_stat_io View: Read/Write Operations, Writebacks, and Extends
Summary
This section describes the `pg_stat_io` view columns related to I/O statistics. It covers `reads` (number of read operations), `read_bytes` (total size of read operations), `read_time` (time spent waiting for reads), `writes` (number of write operations), `write_bytes` (total size of write operations), `write_time` (time spent waiting for writes), `writebacks` (number of writeback operations), `writeback_time` (time spent waiting for writebacks), `extends` (number of relation extend operations), `extend_bytes` (total size of extend operations), and `extend_time` (time spent waiting for extend operations). The timing information's availability depends on the `track_io_timing` and `track_wal_io_timing` settings.