PGXC_STAT_OBJECT

Updated on 2024-09-30 GMT+08:00

View PDF

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.

**Table 1** PGXC_STAT_OBJECT columns
Name	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	Database OID.
relid	oid	PG_CLASS.oid	Table OID. It is the OID of the primary table for a partitioned table.
partid	oid	PG_PARTITION .oid	Partition OID. If the table is not partitioned, the value 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. (This field is supported only by cluster versions 8.3.0 and later.) 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.