Minor documentation tweak to pg_stat_all_tables view description

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

On Thu, Dec 4, 2014 at 2:56 PM, Andres Freund <andres@2ndquadrant.com> wrote:

I wondered for a sec whether it'd be better to refer to n_tup_hot_upd
here, but decided you were right.

Pushed.

Thanks.

--
Peter Geoghegan

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers