GLOBAL_STAT_ALL_TABLES
GLOBAL_STAT_ALL_TABLES displays statistics about one row for each table (including TOAST tables) in databases on each node.
Name |
Type |
Description |
---|---|---|
node_name |
name |
Node name |
relid |
oid |
OID of the table |
schemaname |
name |
Name of the schema that contains the table |
relname |
name |
Table name |
seq_scan |
bigint |
Number of sequential scans initiated on this table |
seq_tup_read |
bigint |
Number of live rows fetched by sequential scans |
idx_scan |
bigint |
Number of index scans initiated on the table |
idx_tup_fetch |
bigint |
Number of live rows fetched by index scans |
n_tup_ins |
bigint |
Number of rows inserted |
n_tup_upd |
bigint |
Number of rows updated |
n_tup_del |
bigint |
Number of rows deleted |
n_tup_hot_upd |
bigint |
Number of rows HOT updated (with no separate index update required) |
n_live_tup |
bigint |
Estimated number of live rows |
n_dead_tup |
bigint |
Estimated number of dead rows |
last_vacuum |
timestamp with time zone |
Last time at which this table was manually vacuumed (not counting VACUUM FULL) |
last_autovacuum |
timestamp with time zone |
Last time at which this table was vacuumed by the autovacuum daemon |
last_analyze |
timestamp with time zone |
Last time at which this table was manually analyzed |
last_autoanalyze |
timestamp with time zone |
Last time at which this table was analyzed by the autovacuum daemon |
vacuum_count |
bigint |
Number of times the table has been manually vacuumed (not counting VACUUM FULL) |
autovacuum_count |
bigint |
Number of times the table has been vacuumed by the autovacuum daemon |
analyze_count |
bigint |
Number of times the table has been manually analyzed |
autoanalyze_count |
bigint |
Number of times the table has been analyzed by the autovacuum daemon |
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