Clarify VACUUM FULL exclusion in total_vacuum_time docs
Fujii Masao <masao.fujii@oss.nttdata.com>
From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: pgsql-docs@lists.postgresql.org
Date: 2025-06-06T11:38:35Z
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
Commits
-
doc: Clarify that total_vacuum_time excludes VACUUM FULL.
- da9a888da22c 18.0 landed
- 7c3b591af3d8 19 (unreleased) landed