diff options
author | Magnus Hagander <magnus@hagander.net> | 2016-03-11 15:08:34 +0100 |
---|---|---|
committer | Magnus Hagander <magnus@hagander.net> | 2016-03-11 15:08:34 +0100 |
commit | 92f03fe76fe6be683a8b7497579158b8a82b2c25 (patch) | |
tree | 09b3625e28d98cd510141b685893e22b0d374692 /doc/src | |
parent | 69ab7b9d6c9b9e1d782ffad6e440a3615c63f621 (diff) | |
download | postgresql-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.sgml | 18 |
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> |