Re: Add n_tup_newpage_upd to pg_stat table views
Peter Geoghegan <pg@bowt.ie>
From: Peter Geoghegan <pg@bowt.ie>
To: Corey Huinker <corey.huinker@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2023-03-23T00:14:08Z
Lists: pgsql-hackers
Attachments
- v2-0001-Count-the-number-of-new-page-updates-in-pgstats.patch (application/x-patch) patch v2-0001
On Fri, Mar 17, 2023 at 3:22 PM Peter Geoghegan <pg@bowt.ie> wrote: > I think that this is pretty close to being committable already. Attached revision has some small tweaks by me. Going to commit this revised version tomorrow morning. Changes: * No more dedicated struct to carry around the type of an update. We just use two boolean arguments to the pgstats function instead. The struct didn't seem to be adding much, and it was distracting to track the information this way within heap_update(). * Small adjustments to the documentation. Nearby related items were tweaked slightly to make everything fit together a bit better. For example, the description of n_tup_hot_upd is revised to make it obvious that n_tup_hot_upd counts row updates that can never get counted under the new n_tup_newpage_upd counter. -- Peter Geoghegan
Commits
-
Count updates that move row to a new page.
- ae4fdde1352f 16.0 landed