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

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.