pg_stat_xact_sys_tables
Same as pg_stat_xact_all_tables, except that only system tables are shown.
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_xact_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
Same as pg_stat_xact_all_tables, except that only system tables are shown.
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:ca78828e22aca74f8602dad44c64803ceb419a46f0440a23ce184ab97aeb3adb
Text language: en · catalog-bilingual-repair:ca78828e22aca74f8602dad44c64803ceb419a46f0440a23ce184ab97aeb3adb