~aglenyoung/+junk/postgres-9.3-dtrace

« back to all changes in this revision

Viewing changes to doc/src/sgml/auto-explain.sgml

  • Committer: Package Import Robot
  • Author(s): Martin Pitt, Christoph Berg, Martin Pitt
  • Date: 2013-06-26 15:13:32 UTC
  • mfrom: (1.1.1)
  • Revision ID: package-import@ubuntu.com-20130626151332-p34yjpn0txbdsdzd
Tags: 9.3~beta2-1
[ Christoph Berg ]
* hurd-i386: Ignore testsuite failures so we have a working libpq5 (they
  don't implement semaphores so the server won't even start).
* Mark postgresql-9.3 as beta in the description, suggested by Joshua D.
  Drake.

[ Martin Pitt ]
* New upstream release 9.3 beta2.

Show diffs side-by-side

added added

removed removed

Lines of Context:
141
141
 
142
142
   <varlistentry>
143
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
   
 
163
   <varlistentry>
 
164
    <term>
144
165
     <varname>auto_explain.log_nested_statements</varname> (<type>boolean</type>)
145
166
    </term>
146
167
    <indexterm>