Home Explore Blog CI



postgresql

38th chunk of `doc/src/sgml/monitoring.sgml`
c261e4e03476e37ac26255884b245725db5d4d5121624bb10000000100000fa9
 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>
    </tbody>
   </tgroup>
  </table>

 </sect2>

 <sect2 id="monitoring-pg-stat-checkpointer-view">
  <title><structname>pg_stat_checkpointer</structname></title>

  <indexterm>
   <primary>pg_stat_checkpointer</primary>
  </indexterm>

  <para>
   The <structname>pg_stat_checkpointer</structname> view will always have a
   single row, containing data about the checkpointer process of the cluster.
  </para>

  <table id="pg-stat-checkpointer-view" xreflabel="pg_stat_checkpointer">
   <title><structname>pg_stat_checkpointer</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>num_timed</structfield> <type>bigint</type>
      </para>
      <para>
       Number of scheduled checkpoints due to timeout
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>num_requested</structfield> <type>bigint</type>
      </para>
      <para>
       Number of requested checkpoints
      </para></entry>
     </row>

      <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>num_done</structfield> <type>bigint</type>
      </para>
      <para>
       Number of checkpoints that have been performed
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>restartpoints_timed</structfield> <type>bigint</type>
      </para>
      <para>
       Number of scheduled restartpoints due to timeout or after a failed attempt to perform it
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>restartpoints_req</structfield> <type>bigint</type>
      </para>
      <para>
       Number of requested restartpoints
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>restartpoints_done</structfield> <type>bigint</type>
      </para>
      <para>
       Number of restartpoints that have been performed
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>write_time</structfield> <type>double precision</type>
      </para>
      <para>
       Total amount of time that has been spent in the portion of
       processing checkpoints and restartpoints where files are written to disk,
       in milliseconds
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>sync_time</structfield> <type>double precision</type>
      </para>
      <para>
       Total amount of time that has been spent in the portion of
       processing checkpoints and restartpoints where files are synchronized to
       disk, in milliseconds
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>buffers_written</structfield> <type>bigint</type>
      </para>
      <para>
       Number of shared buffers written during checkpoints and restartpoints
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
        <structfield>slru_written</structfield> <type>bigint</type>
      </para>
      <para>
        Number of SLRU buffers written during checkpoints and restartpoints

Title: pg_stat_checkpointer View Details
Summary
This section describes the `pg_stat_checkpointer` view, which provides data about the checkpointer process. It details the columns available in the view, including: `num_timed` (scheduled checkpoints due to timeout), `num_requested` (requested checkpoints), `num_done` (checkpoints performed), `restartpoints_timed` (scheduled restartpoints), `restartpoints_req` (requested restartpoints), `restartpoints_done` (restartpoints performed), `write_time` (time spent writing files to disk during checkpoints/restartpoints), `sync_time` (time spent synchronizing files to disk), `buffers_written` (shared buffers written), and `slru_written` (SLRU buffers written during checkpoints/restartpoints).