aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorMagnus Hagander <magnus@hagander.net>2016-03-11 15:08:34 +0100
committerMagnus Hagander <magnus@hagander.net>2016-03-11 15:08:34 +0100
commit92f03fe76fe6be683a8b7497579158b8a82b2c25 (patch)
tree09b3625e28d98cd510141b685893e22b0d374692 /doc/src
parent69ab7b9d6c9b9e1d782ffad6e440a3615c63f621 (diff)
downloadpostgresql-92f03fe76fe6be683a8b7497579158b8a82b2c25.tar.gz
postgresql-92f03fe76fe6be683a8b7497579158b8a82b2c25.zip
Allow setting sample ratio for auto_explain
New configuration parameter auto_explain.sample_ratio makes it possible to log just a fraction of the queries meeting the configured threshold, to reduce the amount of logging. Author: Craig Ringer and Julien Rouhaud Review: Petr Jelinek
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/auto-explain.sgml18
1 files changed, 18 insertions, 0 deletions
diff --git a/doc/src/sgml/auto-explain.sgml b/doc/src/sgml/auto-explain.sgml
index d527208271f..6f1bde0d17e 100644
--- a/doc/src/sgml/auto-explain.sgml
+++ b/doc/src/sgml/auto-explain.sgml
@@ -203,6 +203,24 @@ LOAD 'auto_explain';
</para>
</listitem>
</varlistentry>
+
+ <varlistentry>
+ <term>
+ <varname>auto_explain.sample_ratio</varname> (<type>real</type>)
+ <indexterm>
+ <primary><varname>auto_explain.sample_ratio</> configuration parameter</primary>
+ </indexterm>
+ </term>
+ <listitem>
+ <para>
+ <varname>auto_explain.sample_ratio</varname> (<type>floating point</type>)
+ causes auto_explain to only explain a fraction of the statements in each
+ session. The default is 1, meaning explain all the queries. In case
+ of nested statements, either all will be explained or none. Only
+ superusers can change this setting.
+ </para>
+ </listitem>
+ </varlistentry>
</variablelist>
<para>