PG_STAT_XACT_SYS_TABLES
PG_STAT_XACT_SYS_TABLES displays the transaction status information of the system catalog in the namespace.
Name |
Type |
Description |
---|---|---|
relid |
oid |
Table OID |
schemaname |
name |
Schema name of the table |
relname |
name |
Table name |
seq_scan |
bigint |
Number of sequential scans started on the table |
seq_tup_read |
bigint |
Number of live rows fetched by sequential scans |
idx_scan |
bigint |
Number of index scans started 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 with HOT updates (that is, without separate index required for updates) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.