Count updates that move row to a new page.
authorPeter Geoghegan <pg@bowt.ie>
Thu, 23 Mar 2023 18:16:17 +0000 (11:16 -0700)
committerPeter Geoghegan <pg@bowt.ie>
Thu, 23 Mar 2023 18:16:17 +0000 (11:16 -0700)
commitae4fdde1352fa6b2c9123e91435efafc78c370a0
tree2f0bc32e55b16114a24d14180231a117be526e8b
parent3b50275b12950280fb07193e24a4f400ed8a9fef
Count updates that move row to a new page.

Add pgstat counter to track row updates that result in the successor
version going to a new heap page, leaving behind an original version
whose t_ctid points to the new version.  The current count is shown by
the n_tup_newpage_upd column of each of the pg_stat_*_tables views.

The new n_tup_newpage_upd column complements the existing n_tup_hot_upd
and n_tup_upd columns.  Tables that have high n_tup_newpage_upd values
(relative to n_tup_upd) are good candidates for tuning heap fillfactor.

Corey Huinker, with small tweaks by me.

Author: Corey Huinker <corey.huinker@gmail.com>
Reviewed-By: Peter Geoghegan <pg@bowt.ie>
Reviewed-By: Andres Freund <andres@anarazel.de>
Discussion: https://postgr.es/m/CADkLM=ded21M9iZ36hHm-vj2rE2d=zcKpUQMds__Xm2pxLfHKA@mail.gmail.com
doc/src/sgml/monitoring.sgml
src/backend/access/heap/heapam.c
src/backend/catalog/system_views.sql
src/backend/utils/activity/pgstat_relation.c
src/backend/utils/adt/pgstatfuncs.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/include/pgstat.h
src/test/regress/expected/rules.out