pg_stat_xact_all_tables
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.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- columns not enumerated
- true
- derived from
- pg_stat_all_tables
- kind
- statistics
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- 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
- runtime verified
- false
- source
- english-manual
Definition PG 18
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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| relid | oid | Nullable | OID of a table |
| schemaname | name | Nullable | Name of the schema that this table is in |
| relname | name | Nullable | Name of this table |
| seq_scan | bigint | Nullable | Number of sequential scans initiated on this table This view reports counters for the current transaction. |
| seq_tup_read | bigint | Nullable | Number of live rows fetched by sequential scans This view reports counters for the current transaction. |
| idx_scan | bigint | Nullable | Number of index scans initiated on this table This view reports counters for the current transaction. |
| idx_tup_fetch | bigint | Nullable | Number of live rows fetched by index scans This view reports counters for the current transaction. |
| n_tup_ins | bigint | Nullable | Total number of rows inserted This view reports counters for the current transaction. |
| n_tup_upd | bigint | Nullable | 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 | Nullable | Total number of rows deleted This view reports counters for the current transaction. |
| n_tup_hot_upd | bigint | Nullable | 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 | Nullable | 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. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:7526a83209d7c73689bbd2446a5f27baabe09b120bf7e15787e3015426a95ad9
Text language: en · catalog-bilingual-repair:7526a83209d7c73689bbd2446a5f27baabe09b120bf7e15787e3015426a95ad9