Re: Clarify VACUUM FULL exclusion in total_vacuum_time docs

On Friday, June 6, 2025, Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com> wrote:

> Hi,
>
> Since last_vacuum and vacuum_count in pg_stat_all_tables explicitly mention
> that they don't include VACUUM FULL ("not counting VACUUM FULL"), I think
> we should add the same clarification to the description of
> total_vacuum_time.
> This field also excludes VACUUM FULL, and without this note, users might
> mistakenly think the time spent on VACUUM FULL is included. Thought?
>
> <structfield>total_vacuum_time</structfield> <type>double
> precision</type>
> </para>
> <para>
> - Total time this table has been manually vacuumed, in milliseconds.
> + Total time this table has been manually vacuumed, in milliseconds
> + (not counting <command>VACUUM FULL</command>).
> (This includes the time spent sleeping due to cost-based delays.)
> </para></entry>
> </row>
>

Makes sense. Our naming this table rewrite vacuum full does confuse
people into thinking it is related to vacuum.

David J.