Commit07ab261

committed

Document auto_explain.log_timing.

Tomas Vondra

1 parentf80e550 commit07ab261Copy full SHA for 07ab261

File tree

+21

-0

lines changed

+21

-0

lines changed

Lines changed: 21 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -139,6 +139,27 @@ LOAD 'auto_explain';`
`139`	`139`	`</listitem>`
`140`	`140`	`</varlistentry>`
`141`	`141`
	`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`	`+`
`142`	`163`	`<varlistentry>`
`143`	`164`	`<term>`
`144`	`165`	`<varname>auto_explain.log_nested_statements</varname> (<type>boolean</type>)`

Comments

(0)