Clarify VACUUM FULL exclusion in total_vacuum_time docs

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Clarify VACUUM FULL exclusion in total_vacuum_time docs
Date: 2025-06-06 11:38:35
Message-ID: 2ac375d1-591b-4f1b-a2af-f24335567866@oss.nttdata.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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>

Regards,

--
Fujii Masao
NTT DATA Japan Corporation

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2025-06-06 13:57:11 Re: Clarify VACUUM FULL exclusion in total_vacuum_time docs
Previous Message Laurenz Albe 2025-06-06 01:18:02 Re: Add sentence about SECURITY LABEL object ownership