↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Statistics & Metrics

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 PG 18·Select a recorded version

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
documented
true
field
n_tup_upd
manual path
/docs/18/monitoring-stats.html
signature
SELECT n_tup_upd FROM pg_catalog.pg_stat_sys_tables;
source only
false
sql type
bigint
units mentioned
rows
view
pg_stat_sys_tables

Definition PG 18

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.)

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f