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

Commit92ee8a4

Browse files
committed
doc: Mention cost-based delays for total_[auto]{vacuum,analyze}_time
30a6ed0 has added four attributes to pg_stat_all_tables to track thecumulative time spent in [auto]vacuum and [auto]analyze. It was notmentioned that the vacuum cost-based delays are included in thesenumbers, which could be confusing now that the delays are included inthe vacuum progress view (bb8dff9).This commit adds an extra note about this matter.Reported-by: Magnus Hagander <magnus@hagander.net>Author: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>Discussion:https://postgr.es/m/CABUevEz9v1ZNToPyD98JnWDGZgG=SmPZKkSNzU9hXQ-nGTQF0g@mail.gmail.com
1 parent45e7e8c commit92ee8a4

File tree

1 file changed

+8
-4
lines changed

1 file changed

+8
-4
lines changed

‎doc/src/sgml/monitoring.sgml

Lines changed: 8 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -4066,7 +4066,8 @@ description | Waiting for a newly initialized WAL file to reach durable storage
40664066
<structfield>total_vacuum_time</structfield> <type>double precision</type>
40674067
</para>
40684068
<para>
4069-
Total time this table has been manually vacuumed, in milliseconds
4069+
Total time this table has been manually vacuumed, in milliseconds.
4070+
(This includes the time spent sleeping due to cost-based delays.)
40704071
</para></entry>
40714072
</row>
40724073

@@ -4076,7 +4077,8 @@ description | Waiting for a newly initialized WAL file to reach durable storage
40764077
</para>
40774078
<para>
40784079
Total time this table has been vacuumed by the autovacuum daemon,
4079-
in milliseconds
4080+
in milliseconds. (This includes the time spent sleeping due to
4081+
cost-based delays.)
40804082
</para></entry>
40814083
</row>
40824084

@@ -4085,7 +4087,8 @@ description | Waiting for a newly initialized WAL file to reach durable storage
40854087
<structfield>total_analyze_time</structfield> <type>double precision</type>
40864088
</para>
40874089
<para>
4088-
Total time this table has been manually analyzed, in milliseconds
4090+
Total time this table has been manually analyzed, in milliseconds.
4091+
(This includes the time spent sleeping due to cost-based delays.)
40894092
</para></entry>
40904093
</row>
40914094

@@ -4095,7 +4098,8 @@ description | Waiting for a newly initialized WAL file to reach durable storage
40954098
</para>
40964099
<para>
40974100
Total time this table has been analyzed by the autovacuum daemon,
4098-
in milliseconds
4101+
in milliseconds. (This includes the time spent sleeping due to
4102+
cost-based delays.)
40994103
</para></entry>
41004104
</row>
41014105
</tbody>

0 commit comments

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