pg_stat_xact_sys_tables

Same as pg_stat_xact_all_tables, except that only system tables are shown.

Reading PG 18current·documented in 17 of 24 versions, 9.1 to 20

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Kind: Statistics views
Columns in this snapshot: 12
Definition source: English manual
Metadata snapshot: 18.6

Columns 12

The selected manual names this view but does not list its columns. The columns below come from the separately attributed catalog snapshot for the same version.

Column	Type	Description / reference
`relid`	`oid`	OID of a table
`schemaname`	`name`	Name of the schema that this table is in
`relname`	`name`	Name of this table
`seq_scan`	`bigint`	Number of sequential scans initiated on this table This view reports counters for the current transaction.
`seq_tup_read`	`bigint`	Number of live rows fetched by sequential scans This view reports counters for the current transaction.
`idx_scan`	`bigint`	Number of index scans initiated on this table This view reports counters for the current transaction.
`idx_tup_fetch`	`bigint`	Number of live rows fetched by index scans This view reports counters for the current transaction.
`n_tup_ins`	`bigint`	Total number of rows inserted This view reports counters for the current transaction.
`n_tup_upd`	`bigint`	Total number of rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.) This view reports counters for the current transaction.
`n_tup_del`	`bigint`	Total number of rows deleted This view reports counters for the current transaction.
`n_tup_hot_upd`	`bigint`	Number of rows HOT updated. These are updates where no successor versions are required in indexes. This view reports counters for the current transaction.
`n_tup_newpage_upd`	`bigint`	Number of rows updated where the successor version goes onto a new heap page, leaving behind an original version with a t_ctid field that points to a different heap page. These are always non-HOT updates. This view reports counters for the current transaction.