GLOBAL_TABLE_CHANGE_STAT
GLOBAL_TABLE_CHANGE_STAT displays the changes of all tables (excluding foreign tables) in the current database. The value of each column that indicates the number of times is the accumulated value since the instance was started.
Name |
Type |
Description |
---|---|---|
schemaname |
name |
Namespace of a table |
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. The value is the sum of the number of times on each CN. |
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. The value is the sum of the number of times on each CN. |
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). The ANALYZE operation is performed on all CNs at the same time. Therefore, the value of this column is the maximum value on all CNs. |
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. The value is the sum of the number of times on each CN. |
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.