|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.332 2005/06/26 19:16:04 tgl Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.333 2005/07/01 13:29:23 momjian Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <chapter Id="runtime"> |
@@ -2628,16 +2628,17 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows |
2628 | 2628 | </indexterm> |
2629 | 2629 | <listitem> |
2630 | 2630 | <para> |
2631 | | - Sets a minimum statement execution time (in milliseconds) |
2632 | | - that causes a statement to be logged. All SQL statements |
2633 | | - that run for the time specified or longer will be logged with |
2634 | | - their duration. Setting this to zero will print |
2635 | | - all queries and their durations. Minus-one (the default) |
2636 | | - disables the feature. For example, if you set it to |
2637 | | - <literal>250</literal> then all SQL statements that run 250ms |
2638 | | - or longer will be logged. Enabling this option can be |
2639 | | - useful in tracking down unoptimized queries in your applications. |
2640 | | - Only superusers can change this setting. |
| 2631 | + Logs the statement and its duration on a single log line if its |
| 2632 | + duration is greater than or equal to the specified number of |
| 2633 | + milliseconds. Setting this to zero will print all statements |
| 2634 | + and their durations. Minus-one (the default) disables the |
| 2635 | + feature. For example, if you set it to <literal>250</literal> |
| 2636 | + then all SQL statements that run 250ms or longer will be |
| 2637 | + logged. Enabling this option can be useful in tracking down |
| 2638 | + unoptimized queries in your applications. This setting is |
| 2639 | + independent of <varname>log_statement</varname> and |
| 2640 | + <varname>log_duration</varname>. Only superusers can change |
| 2641 | + this setting. |
2641 | 2642 | </para> |
2642 | 2643 | </listitem> |
2643 | 2644 | </varlistentry> |
|