STAT_XACT_USER_TABLES
Displays transaction status information about the user tables in schemas on 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 new 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.