On 2014-12-04 14:43:43 -0800, Peter Geoghegan wrote: > Attached patch makes minor modification to the pg_stat_all_tables > documentation. This clarifies that pg_stat_*_tables.n_tup_upd includes > HOT updates.
Ah. Good idea. I've been asked that by others and myself quite a number of times and had to check the code every time. > diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml > index b29e5e6..3ce7e80 100644 > --- a/doc/src/sgml/monitoring.sgml > +++ b/doc/src/sgml/monitoring.sgml > @@ -1226,7 +1226,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss > 11:34 0:00 postgres: ser > <row> > <entry><structfield>n_tup_upd</></entry> > <entry><type>bigint</></entry> > - <entry>Number of rows updated</entry> > + <entry>Number of rows updated (includes HOT updated rows)</entry> > </row> > <row> > <entry><structfield>n_tup_del</></entry> I wondered for a sec whether it'd be better to refer to n_tup_hot_upd here, but decided you were right. Pushed. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
