Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit7c3b591

Browse files
committed
doc: Clarify that total_vacuum_time excludes VACUUM FULL.
The last_vacuum and vacuum_count fields in pg_stat_all_tables alreadystate that they do not include VACUUM FULL. However, total_vacuum_time,which also excludes VACUUM FULL, did not mention this. This couldmislead users into thinking VACUUM FULL time is included.To address this, this commit updates the documentation forpg_stat_all_tables to explicitly state that total_vacuum_time does notcount VACUUM FULL.Back-patched to v18, where total_vacuum_time was introduced.Additionally, this commit clarifies that n_ins_since_vacuum alsoexcludes VACUUM FULL. Although n_ins_since_vacuum was added in v13,we are not back-patching this change to stable branches, as it isa documentation improvement, not a bug fix.Author: Fujii Masao <masao.fujii@gmail.com>Reviewed-by: Robert Treat <rob@xzilla.net>Reviewed-by: David G. Johnston <david.g.johnston@gmail.com>Reviewed-by: Laurenz Albe <laurenz.albe@cybertec.at>Discussion:https://postgr.es/m/2ac375d1-591b-4f1b-a2af-f24335567866@oss.nttdata.comBackpatch-through: 18
1 parent5fe55a0 commit7c3b591

File tree

1 file changed

+3
-1
lines changed

1 file changed

+3
-1
lines changed

‎doc/src/sgml/monitoring.sgml

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3980,6 +3980,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
39803980
</para>
39813981
<para>
39823982
Estimated number of rows inserted since this table was last vacuumed
3983+
(not counting <command>VACUUM FULL</command>)
39833984
</para></entry>
39843985
</row>
39853986

@@ -4066,7 +4067,8 @@ description | Waiting for a newly initialized WAL file to reach durable storage
40664067
<structfield>total_vacuum_time</structfield> <type>double precision</type>
40674068
</para>
40684069
<para>
4069-
Total time this table has been manually vacuumed, in milliseconds.
4070+
Total time this table has been manually vacuumed, in milliseconds
4071+
(not counting <command>VACUUM FULL</command>).
40704072
(This includes the time spent sleeping due to cost-based delays.)
40714073
</para></entry>
40724074
</row>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp