diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2018-07-31 08:03:57 -0400 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2018-07-31 08:03:57 -0400 |
| commit | 2d36a5e9dab6eda817b3d72a2d0f42c3d0cd922c (patch) | |
| tree | 91220085ad3bc2a1caf7b0f245bb6706635a4013 /doc/src | |
| parent | 6574f19127ea539408267c1891ccc12ca5ebeca2 (diff) | |
Provide a log_level setting for auto_explain
Up to now the log level has been hardcoded at LOG. A new
auto_explain.log_level setting allows that to be modified.
Discussion: https://postgr.es/m/CAPPfruyZh+snR2AdmutrA0B_caj=yWZkLqxUTZYNjJCaQ_wKQg@mail.gmail.com
Tom Dunstan and Andrew Dunstan
Reviewed by Daniel Gustafsson
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/auto-explain.sgml | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/doc/src/sgml/auto-explain.sgml b/doc/src/sgml/auto-explain.sgml index 08b67f2600b..2b928d0806f 100644 --- a/doc/src/sgml/auto-explain.sgml +++ b/doc/src/sgml/auto-explain.sgml @@ -189,6 +189,27 @@ LOAD 'auto_explain'; <varlistentry> <term> + <varname>auto_explain.log_level</varname> (<type>enum</type>) + <indexterm> + <primary><varname>auto_explain.log_level</> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + <varname>auto_explain.log_level</varname> selects the log level at which + auto_explain will log the query plan. + Valid values are <literal>DEBUG5</literal>, <literal>DEBUG4</literal>, + <literal>DEBUG3</literal>, <literal>DEBUG2</literal>, + <literal>DEBUG1</literal>, <literal>INFO</literal>, + <literal>NOTICE</literal>, <literal>WARNING</literal>, + and <literal>LOG</literal>. The default is <literal>LOG</literal>. + Only superusers can change this setting. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term> <varname>auto_explain.log_nested_statements</varname> (<type>boolean</type>) <indexterm> <primary><varname>auto_explain.log_nested_statements</varname> configuration parameter</primary> |