SYSTEM CATALOGS / STATISTICS VIEWS
pg_stat_xact_sys_tables
Read PG 18 manual ↗A transaction can also see its own statistics (not yet flushed out to the shared memory statistics) in the views pg_stat_xact_all_tables, pg_stat_xact_sys_tables, pg_stat_xact_user_tables, and pg_stat_xact_user_functions.
- Kind
- Statistics views
- Columns in this snapshot
- 12
- Definition source
- English manual
Columns 12
The selected manual identifies this view but does not enumerate its columns. The columns below come from the separately attributed catalog snapshot for this 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. |
Column history across versions
| Column | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ? |
Version history 3
- PG 14 → 15changed
- PG 9.1 → 9.2changed
- PG 9.0 → 9.1added
Definition snapshot: english-manuals:3790f4eaca77e78945b53a81b24… · English manual source