PGXC_STAT_OBJECT¶
PGXC_STAT_OBJECT displays statistics and autovacuum efficiency information about tables of all instances in a cluster. This system view is supported only by clusters of version 8.2.1 or later.
Column | Type | Reference | Description |
|---|---|---|---|
nodename | name |
| Node name |
datname | name |
| Name of the database where the table is located. |
relnamespace | name |
| Name of the schema where the table is located. |
relname | name |
| Table name |
partname | name |
| Partition name of the partitioned table |
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 | .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). |
last_autovacuum_csn | bigint |
| If the table-level oldestxmin feature is enabled, this field records the CSN value corresponding to the latest oldestxmin value used by the table (AUTO)VACUUM. |
last_reference_timestamp | timestamp with time zone |
| Last access time of a table. (Added for clusters of version 8.2.1.210) This parameter corresponds to the latest time between data_changed_time_stamp (last modification time) and data_access_timestamp (last access time) in PG_STAT_OBJECT. |
extra1 | bigint |
| Reserved field 1. |
extra2 | bigint |
| Reserved field 2. |
extra3 | bigint |
| Reserved field 3. |
extra4 | bigint |
| Reserved field 4. |