PG_STAT_OBJECT¶
Records table statistics and autovacuum efficiency information of the current DB instance, and creates indexes for the databaseid, relid, and partid columns. Update of this system catalog is controlled by the enable_pg_stat_object parameter. This system catalog is supported only by clusters of version 8.2.1 or later.
Column | Type | Reference | Description |
|---|---|---|---|
databaseid | oid | PG_DATABASE.oid | OID of the database. |
relid | oid | PG_CLASS.oid | OID of the table. It is the OID of the primary table for a partitioned table. |
partid | oid | PG_PARTITION.oid | Partition OID. For an ordinary table, the value of this column is 0. |
numscans | bigint |
| Number of times that sequential scans are started. |
tuples_returned | bigint |
| Number of visible tuples fetched by sequential scans. |
tuples_fetched | bigint |
| Number of visible tuples fetched. |
tuples_inserted | bigint |
| Number of inserted records. |
tuples_updated | bigint |
| Number of updated records. |
tuples_deleted | bigint |
| Number of deleted records. |
tuples_hot_updated | bigint |
| Number of HOT updates. |
n_live_tuples | bigint |
| Number of visible tuples. |
last_autovacuum_begin_n_dead_tuple | bigint |
| Number of tuples deleted before Autovacuum is executed. |
n_dead_tuples | bigint |
| Number of tuples deleted after Autovacuum is successful. |
changes_since_analyze | bigint |
| Last data modification time after Analyze. |
blocks_fetched | bigint |
| Number of selected pages. |
blocks_hit | bigint |
| Number of scanned pages. |
cu_mem_hit | bigint |
| Number of CU memory hits. |
cu_hdd_sync | bigint |
| Times that CUs are synchronously read from disks. |
cu_hdd_asyn | bigint |
| Times that CUs are asynchronously read from disks. |
data_changed_timestamp | timestamp with time zone |
| Last data modification time. |
data_access_timestamp | timestamp with time zone |
| Last access time of a table. |
analyze_timestamp | timestamp with time zone |
| Last Analyze time. |
analyze_count | bigint |
| Total number of Analyze times. |
autovac_analyze_timestamp | timestamp with time zone |
| Last Autoanalyze time. |
autovac_analyze_count | bigint |
| Total number of Autoanalyze times. |
vacuum_timestamp | timestamp with time zone |
| Time of the latest Vacuum. |
vacuum_count | bigint |
| Total number of Vacuum times. |
autovac_vacuum_timestamp | timestamp with time zone |
| Last Autovacuum time. |
autovac_vacuum_count | bigint |
| Total number of Autovacuum times. |
autovacuum_success_count | bigint |
| Total number of successful Autovacuum operations. |
last_autovacuum_time_cost | bigint |
| Time spent on the latest successful Autovacuum, in microseconds. |
avg_autovacuum_time_cost | bigint |
| Average execution time of successful Autovacuum operations. Unit: μs. |
last_autovacuum_failed_count | bigint |
| Total number of autovacuum failures since the last successful Autovacuum. |
last_autovacuum_trigger | smallint |
| Triggering mode of the latest autovacuum, which helps maintenance personnel determine the Vacuum status. |
last_autovacuum_oldestxmin | bigint |
| oldestxmin after the latest successful Autovacuum execution. If the table-level oldestxmin feature is enabled, this field records the value of oldestxmin used by the latest (AUTO)VACUUM of the table. |
last_autovacuum_scan_pages | bigint |
| Number of pages last scanned by autovacuum (only for row-store tables). |
last_autovacuum_dirty_pages | bigint |
| Number of pages last modified by Autovacuum (only for row-store tables). |
last_autovacuum_clear_deadtuples | bigint |
| Number of dead tuples last cleared by Autovacuum (only for row-store tables) |
sum_autovacuum_scan_pages | bigint |
| Total number of pages scanned by Autovacuum since database initialization (only for row-store tables). |
sum_autovacuum_dirty_pages | bigint |
| Number of pages modified by Autovacuum since database initialization (only for row-store tables). |
sum_autovacuum_clear_deadtuples | bigint |
| Total number of dead tuples cleared by Autovacuum since database initialization (only for row-store tables). |
last_autovacuum_begin_cu_size | bigint |
| Size of the CU file before the latest Autovacuum operation (only for column-store tables) |
last_autovacuum_cu_size | bigint |
| Size of the CU file after the latest Autovacuum (only for column-store tables) |
last_autovacuum_rewrite_size | bigint |
| Size of the column-store file last rewritten by autovacuum (only for column-store tables). |
last_autovacuum_clear_size | bigint |
| Size of the column-store file last cleared by Autovacuum (only for column-store tables). |
last_autovacuum_clear_cbtree_tuples | bigint |
| Number of cbtree tuples last cleared by Autovacuum (only for column-store tables) |
sum_autovacuum_rewrite_size | bigint |
| Total size of column-store files rewritten by Autovacuum since database initialization (only for column-store tables). |
sum_autovacuum_clear_size | bigint |
| Total size of column-store files cleared by Autovacuum since database initialization (only for column-store tables). |
sum_autovacuum_clear_cbtree_tuples | bigint |
| Total number of cbtree tuples cleared by Autovacuum since database initialization (only for column-store tables). |
extra1 | bigint |
| Reserved field 1. |
extra2 | bigint |
| Reserved field 2. |
extra3 | bigint |
| Reserved field 3. |
extra4 | bigint |
| Reserved field 4. |