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
Name	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