Content-Length: 288929 | pFad | http://github.com/postgrespro/postgres/commit/07ab261ef3a9575a4a2bd3045b222d7b3dee2c46

50 Document auto_explain.log_timing. · postgrespro/postgres@07ab261 · GitHub
Skip to content

Commit 07ab261

Browse files
committed
Document auto_explain.log_timing.
Tomas Vondra
1 parent f80e550 commit 07ab261

File tree

1 file changed

+21
-0
lines changed

1 file changed

+21
-0
lines changed

doc/src/sgml/auto-explain.sgml

Lines changed: 21 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -139,6 +139,27 @@ LOAD 'auto_explain';
139139
</listitem>
140140
</varlistentry>
141141

142+
<varlistentry>
143+
<term>
144+
<varname>auto_explain.log_timing</varname> (<type>boolean</type>)
145+
</term>
146+
<indexterm>
147+
<primary><varname>auto_explain.log_timing</> configuration parameter</primary>
148+
</indexterm>
149+
<listitem>
150+
<para>
151+
<varname>auto_explain.log_timing</varname> causes <command>EXPLAIN
152+
(ANALYZE, TIMING off)</> output, rather than just <command>EXPLAIN (ANALYZE)</>
153+
output. The overhead of repeatedly reading the system clock can slow down the
154+
query significantly on some systems, so it may be useful to set this
155+
parameter to <literal>FALSE</literal> when only actual row counts, and not
156+
exact times, are needed.
157+
This parameter is only effective when <varname>auto_explain.log_analyze</varname>
158+
is also enabled. It defaults to <literal>TRUE</literal>.
159+
</para>
160+
</listitem>
161+
</varlistentry>
162+
142163
<varlistentry>
143164
<term>
144165
<varname>auto_explain.log_nested_statements</varname> (<type>boolean</type>)

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/07ab261ef3a9575a4a2bd3045b222d7b3dee2c46

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy