Home Explore Blog CI



postgresql

46th chunk of `doc/src/sgml/monitoring.sgml`
a91d0f205e9539e42c36a643253e2c45ea80e57b3ac3f9c10000000100000fa6
   <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>last_seq_scan</structfield> <type>timestamp with time zone</type>
      </para>
      <para>
       The time of the last sequential scan on this table, based on the
       most recent transaction stop time
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>seq_tup_read</structfield> <type>bigint</type>
      </para>
      <para>
       Number of live rows fetched by sequential scans
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>idx_scan</structfield> <type>bigint</type>
      </para>
      <para>
       Number of index scans initiated on this table
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>last_idx_scan</structfield> <type>timestamp with time zone</type>
      </para>
      <para>
       The time of the last index scan on this table, based on the
       most recent transaction stop time
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>idx_tup_fetch</structfield> <type>bigint</type>
      </para>
      <para>
       Number of live rows fetched by index scans
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>n_tup_ins</structfield> <type>bigint</type>
      </para>
      <para>
       Total number of rows inserted
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>n_tup_upd</structfield> <type>bigint</type>
      </para>
      <para>
       Total number of rows updated.  (This includes row updates
       counted in <structfield>n_tup_hot_upd</structfield> and
       <structfield>n_tup_newpage_upd</structfield>, and remaining
       non-<acronym>HOT</acronym> updates.)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>n_tup_del</structfield> <type>bigint</type>
      </para>
      <para>
       Total number of rows deleted
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>n_tup_hot_upd</structfield> <type>bigint</type>
      </para>
      <para>
       Number of rows <link linkend="storage-hot">HOT updated</link>.
       These are updates where no successor versions are required in
       indexes.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>n_tup_newpage_upd</structfield> <type>bigint</type>
      </para>
      <para>
       Number of rows updated where the successor version goes onto a
       <emphasis>new</emphasis> heap page, leaving behind an original
       version with a
       <link linkend="storage-tuple-layout"><structfield>t_ctid</structfield>
        field</link> that points to a different heap page.  These are
       always non-<acronym>HOT</acronym> updates.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>n_live_tup</structfield> <type>bigint</type>
      </para>
      <para>
       Estimated number of live rows
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>n_dead_tup</structfield> <type>bigint</type>
      </para>
      <para>
       Estimated number of dead rows
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>n_mod_since_analyze</structfield> <type>bigint</type>

Title: pg_stat_all_tables View: Scan and Tuple Statistics
Summary
This section continues describing the columns of the `pg_stat_all_tables` view, focusing on scan and tuple statistics. It includes details on `last_idx_scan` (time of last index scan), `idx_tup_fetch` (number of live rows fetched by index scans), `n_tup_ins` (total rows inserted), `n_tup_upd` (total rows updated), `n_tup_del` (total rows deleted), `n_tup_hot_upd` (number of HOT updated rows), `n_tup_newpage_upd` (number of rows updated with successor on a new page), `n_live_tup` (estimated live rows), and `n_dead_tup` (estimated dead rows).