PG_STAT_XACT_USER_TABLES
PG_STAT_XACT_USER_TABLES displays the transaction status information of the user table in the namespace.
|
Column |
Type |
Description |
|---|---|---|
|
relid |
OID |
Table OID |
|
schemaname |
Name |
Schema name of the table |
|
relname |
Name |
Name of a table |
|
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 (no separate index update is required). |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
