GLOBAL_STAT_XACT_ALL_TABLES
GLOBAL_STAT_XACT_ALL_TABLES displays the transaction status information about all ordinary tables and TOAST tables in namespaces on each node.
Name |
Type |
Description |
---|---|---|
node_name |
name |
Node name |
relid |
oid |
Table OID |
schemaname |
name |
Name of the schema that the table is in |
relname |
name |
Table name |
seq_scan |
bigint |
Number of sequential scans initiated on the 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) |
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