Home Explore Blog CI



postgresql

48th chunk of `doc/src/sgml/monitoring.sgml`
2413434ec5d1faec50a72e13fec2c8f5915386b1cf9a81c30000000100000fa5
 <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>autovacuum_count</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times this table has been vacuumed by the autovacuum
       daemon
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>analyze_count</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times this table has been manually analyzed
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>autoanalyze_count</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times this table has been analyzed by the autovacuum
       daemon
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>total_vacuum_time</structfield> <type>double precision</type>
      </para>
      <para>
       Total time this table has been manually vacuumed, in milliseconds.
       (This includes the time spent sleeping due to cost-based delays.)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>total_autovacuum_time</structfield> <type>double precision</type>
      </para>
      <para>
       Total time this table has been vacuumed by the autovacuum daemon,
       in milliseconds. (This includes the time spent sleeping due to
       cost-based delays.)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>total_analyze_time</structfield> <type>double precision</type>
      </para>
      <para>
       Total time this table has been manually analyzed, in milliseconds.
       (This includes the time spent sleeping due to cost-based delays.)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>total_autoanalyze_time</structfield> <type>double precision</type>
      </para>
      <para>
       Total time this table has been analyzed by the autovacuum daemon,
       in milliseconds. (This includes the time spent sleeping due to
       cost-based delays.)
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>

 </sect2>

 <sect2 id="monitoring-pg-stat-all-indexes-view">
  <title><structname>pg_stat_all_indexes</structname></title>

  <indexterm>
   <primary>pg_stat_all_indexes</primary>
  </indexterm>

  <para>
   The <structname>pg_stat_all_indexes</structname> view will contain
   one row for each index in the current database,
   showing statistics about accesses to that specific index. The
   <structname>pg_stat_user_indexes</structname> and
   <structname>pg_stat_sys_indexes</structname> views
   contain the same information,
   but filtered to only show user and system indexes respectively.
  </para>

  <table id="pg-stat-all-indexes-view" xreflabel="pg_stat_all_indexes">
   <title><structname>pg_stat_all_indexes</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>relid</structfield> <type>oid</type>
      </para>
      <para>
       OID of the table for this index
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>indexrelid</structfield> <type>oid</type>
      </para>
      <para>
       OID of this index
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">

Title: pg_stat_all_tables and pg_stat_all_indexes Views: Time and Access Statistics
Summary
This section describes the remaining fields in the `pg_stat_all_tables` view, which include the total time spent on manual and autovacuum/analyze operations. It then transitions to the `pg_stat_all_indexes` view, providing an overview of its purpose (to show statistics about index accesses) and its relationship to the `pg_stat_user_indexes` and `pg_stat_sys_indexes` views. The section also presents the initial fields of `pg_stat_all_indexes`, namely `relid` and `indexrelid`, which represent the OIDs of the table and the index, respectively.