Wiki / Statistics & Metrics / pg_stat_sys_tables
pg_stat_sys_tables.n_tup_upd
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.)
Reading PostgreSQL 18.6.
Description
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.)
- View
- pg_stat_sys_tables
- Field
- n_tup_upd
- SQL type
- bigint
- Units named in the field definition
- rows
- Reset observation
- No stats_reset field is documented for this view
Usage
SELECT n_tup_upd FROM pg_catalog.pg_stat_sys_tables;View semantics
Same as pg_stat_all_tables, except that only system tables are shown.
Collection and reset context
Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name.
Inspect this field
Example query; no execution result or measured value is asserted.
SELECT n_tup_upd FROM pg_catalog.pg_stat_sys_tables;Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Compare versions
PostgreSQL 17 → 18: unchanged.
Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
pg_stat_sys_tables.analyze_countpg_stat_sys_tables.autoanalyze_countpg_stat_sys_tables.autovacuum_countpg_stat_sys_tables.idx_scanpg_stat_sys_tables.idx_tup_fetchpg_stat_sys_tables.last_analyzepg_stat_sys_tables.last_autoanalyzepg_stat_sys_tables.last_autovacuumpg_stat_sys_tables.last_idx_scanpg_stat_sys_tables.last_seq_scanpg_stat_sys_tables.last_vacuumpg_stat_sys_tables.n_dead_tup
Export JSON · Back to Statistics & Metrics · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.