PGXC_STAT_OBJECT

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 a database.

relid

oid

PG_CLASS.oid

OID of a 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).

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.