Home Explore Blog CI



postgresql

25th chunk of `doc/src/sgml/monitoring.sgml`
222119bee97e93e7e1f20db90a011225ebbc0c59b68465ca0000000100000fa3
 id="pg-stat-recovery-prefetch-view" xreflabel="pg_stat_recovery_prefetch">
   <title><structname>pg_stat_recovery_prefetch</structname> View</title>
   <tgroup cols="1">
    <thead>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       Column Type
      </para>
      <para>
       Description
      </para></entry>
     </row>
    </thead>

    <tbody>
     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>stats_reset</structfield> <type>timestamp with time zone</type>
       </para>
       <para>
        Time at which these statistics were last reset
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>prefetch</structfield> <type>bigint</type>
       </para>
       <para>
        Number of blocks prefetched because they were not in the buffer pool
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>hit</structfield> <type>bigint</type>
       </para>
       <para>
        Number of blocks not prefetched because they were already in the buffer pool
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>skip_init</structfield> <type>bigint</type>
       </para>
       <para>
        Number of blocks not prefetched because they would be zero-initialized
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>skip_new</structfield> <type>bigint</type>
       </para>
       <para>
        Number of blocks not prefetched because they didn't exist yet
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>skip_fpw</structfield> <type>bigint</type>
       </para>
       <para>
        Number of blocks not prefetched because a full page image was included in the WAL
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>skip_rep</structfield> <type>bigint</type>
       </para>
       <para>
        Number of blocks not prefetched because they were already recently prefetched
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>wal_distance</structfield> <type>int</type>
       </para>
       <para>
        How many bytes ahead the prefetcher is looking
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>block_distance</structfield> <type>int</type>
       </para>
       <para>
        How many blocks ahead the prefetcher is looking
       </para>
      </entry>
     </row>

     <row>
      <entry role="catalog_table_entry">
       <para role="column_definition">
        <structfield>io_depth</structfield> <type>int</type>
       </para>
       <para>
        How many prefetches have been initiated but are not yet known to have completed
       </para>
      </entry>
     </row>
    </tbody>
   </tgroup>
  </table>

 </sect2>

 <sect2 id="monitoring-pg-stat-subscription">
  <title><structname>pg_stat_subscription</structname></title>

  <indexterm>
   <primary>pg_stat_subscription</primary>
  </indexterm>

  <table id="pg-stat-subscription" xreflabel="pg_stat_subscription">
   <title><structname>pg_stat_subscription</structname> View</title>
   <tgroup cols="1">
    <thead>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       Column Type
      </para>
      <para>
       Description
      </para></entry>
     </row>

Title: Detailed Columns of the pg_stat_recovery_prefetch View
Summary
This section details the columns of the `pg_stat_recovery_prefetch` view, including: `stats_reset` (time of last reset), `prefetch` (number of prefetched blocks), `hit` (number of blocks already in buffer pool), `skip_init` (blocks skipped due to zero-initialization), `skip_new` (blocks skipped due to non-existence), `skip_fpw` (blocks skipped due to full page image in WAL), `skip_rep` (blocks skipped due to recent prefetch), `wal_distance` (prefetcher's lookahead in bytes), `block_distance` (prefetcher's lookahead in blocks), and `io_depth` (number of initiated but uncompleted prefetches). It then introduces the `pg_stat_subscription` view.