STATISTICS VIEW · 统计视图

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.

首次收录 PG 9.1最近收录 PG 19当前字段 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

已与 PostgreSQL 18.6 实例逐字段核对 · 原始实测记录 ↗

字段结构 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.

标记“隐式列”的字段不包含在 SELECT * 中；部分早期统计视图由同版本源码补全，额外来源会显示在字段说明中。

字段演化矩阵

悬停查看字段类型

存在新增 / 类型或属性变化移除

字段 / 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 是收录基线；基线中已存在的字段不标记为新增。矩阵按字段名称对齐，重命名显示为旧字段移除与新字段新增。

演化时间线

相邻大版本的变化

PostgreSQL 16 ← 15

+ n_tup_newpage_upd4 处字段说明更新

PostgreSQL 9.5 ← 9.4

1 处字段说明更新

PostgreSQL 9.2 ← 9.1

11 处字段说明更新目录说明更新

PostgreSQL 9.1 ← 9.0新增目录

+ 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

比较任意两个版本

起始版本 / FROM目标版本 / TO包含描述更新

选择两个版本，查看字段的新增、移除与类型变化。交互比较需要 JavaScript；演化时间线可直接阅读。