STAT_XACT_SYS_TABLES
Displays transaction status information about the system catalogs in the schemas of the current node.
Name |
Type |
Description |
---|---|---|
relid |
oid |
Table OID. |
schemaname |
name |
Name of the schema where the table is located. |
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 updated by HOT (that is, the number of rows whose index columns are not updated). |
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