pg_stat_xact_all_tables

PostgreSQL documentation ↗Source definition ↗

Similar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views). The columns for numbers of live and dead rows and vacuum and analyze actions are not present in this view.

First seen PG 9.1Last seen PG 19Columns 12

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19^β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_stat_xact_all_tables

COLUMN	TYPE	DESCRIPTION
`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.

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15
`relid`	–
`schemaname`	–
`relname`	–
`seq_scan`	–
`seq_tup_read`	–
`idx_scan`	–
`idx_tup_fetch`	–
`n_tup_ins`	–
`n_tup_upd`	–
`n_tup_del`	–
`n_tup_hot_upd`	–
`n_tup_newpage_upd`	–	–	–	–	–	–	–	–	–	–	–	–	–

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 16 ← 15

+ n_tup_newpage_upd4 column description updates

PostgreSQL 9.5 ← 9.4

1 column description updates

PostgreSQL 9.2 ← 9.1

11 column description updatesCatalog description updated

PostgreSQL 9.1 ← 9.0Catalog added

+ relid+ schemaname+ relname+ seq_scan+ seq_tup_read+ idx_scan+ idx_tup_fetch+ n_tup_ins+ n_tup_upd+ n_tup_del+ n_tup_hot_upd

Compare any two versions

FROMTOInclude description updates

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.