STAT_XACT_USER_TABLES
STAT_XACT_USER_TABLES displays transaction status information about the user tables in namespaces on the current node.
Table 1 STAT_XACT_USER_TABLES columns
Name
|
Type
|
Description
|
|---|
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)
|