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.
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot