Updated on 2024-11-05 GMT+08:00

PGXC_TABLE_CHANGE_STAT

PGXC_TABLE_CHANGE_STAT displays the changes of all tables of the database on all CNs in the cluster. Except the nodename column of the name type added in front of each row, the names, types, and sequences of other columns are the same as those in the GS_TABLE_CHANGE_STAT view.

Table 1 PGXC_TABLE_CHANGE_STAT columns

Column

Type

Description

nodename

name

Node name

schemaname

name

Table namespace.

relname

name

Table name

last_vacuum

timestamp with time zone

Time when the last VACUUM operation is performed manually

vacuum_count

bigint

Number of times of manually performing the VACUUM operation

last_autovacuum

timestamp with time zone

Time when the last VACUUM operation is performed automatically

autovacuum_count

bigint

Number of times of automatically performing the VACUUM operation

last_analyze

timestamp with time zone

Time when the ANALYZE operation is performed (both manually and automatically)

analyze_count

bigint

Number of times of performing the ANALYZE operation (both manually and automatically)

last_autoanalyze

timestamp with time zone

Time when the last ANALYZE operation is performed automatically

autoanalyze_count

bigint

Number of times of automatically performing the ANALYZE operation

last_change

bigint

Time when the last modification (INSERT, UPDATE, or DELETE) is performed