Re: Minor documentation tweak to pg_stat_all_tables view description - Mailing list pgsql-hackers

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