pg_stat_xact_sys_tables
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
- 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
版本定义 PG 18
目录列
| 列 | 类型 | 可空性 | 描述 |
|---|---|---|---|
| relid | oid | 可空 | 表的OID |
| schemaname | name | 可空 | 该表所在的模式的名称 |
| relname | name | 可空 | 这个表的名称 |
| 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. |
比较版本
来源引用
定义来源
center · PostgreSQL 18 · english-manuals:d5d622ab1b144234e75640e71c9a71a211931764795eb4bb4e50f7480c8d204a
正文语言: zh-Hans · 2026-09-27@419045e