diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-07-01 13:29:25 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-07-01 13:29:25 +0000 |
| commit | 8f6e8e8fed372a592f645d8900b6f456db82cc59 (patch) | |
| tree | aed16365f832f03a4f71671ef3cd9a1911fe206e | |
| parent | 5350216156f6d7dbff471af891797a576b1aad63 (diff) | |
| download | postgresql-8f6e8e8fed372a592f645d8900b6f456db82cc59.tar.gz postgresql-8f6e8e8fed372a592f645d8900b6f456db82cc59.zip | |
Clarify documentation about log_min_duration_statement.
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 23 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 3 |
2 files changed, 14 insertions, 12 deletions
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index c0b3e65ba78..42398529866 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.332 2005/06/26 19:16:04 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.333 2005/07/01 13:29:23 momjian Exp $ --> <chapter Id="runtime"> @@ -2628,16 +2628,17 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows </indexterm> <listitem> <para> - Sets a minimum statement execution time (in milliseconds) - that causes a statement to be logged. All SQL statements - that run for the time specified or longer will be logged with - their duration. Setting this to zero will print - all queries and their durations. Minus-one (the default) - disables the feature. For example, if you set it to - <literal>250</literal> then all SQL statements that run 250ms - or longer will be logged. Enabling this option can be - useful in tracking down unoptimized queries in your applications. - Only superusers can change this setting. + Logs the statement and its duration on a single log line if its + duration is greater than or equal to the specified number of + milliseconds. Setting this to zero will print all statements + and their durations. Minus-one (the default) disables the + feature. For example, if you set it to <literal>250</literal> + then all SQL statements that run 250ms or longer will be + logged. Enabling this option can be useful in tracking down + unoptimized queries in your applications. This setting is + independent of <varname>log_statement</varname> and + <varname>log_duration</varname>. Only superusers can change + this setting. </para> </listitem> </varlistentry> diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 72f447c76b4..ac1cc4875a8 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -227,7 +227,8 @@ # debug5, debug4, debug3, debug2, debug1, # info, notice, warning, error, panic(off) -#log_min_duration_statement = -1 # -1 is disabled, in milliseconds. +#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements + # and their durations, in milliseconds. #silent_mode = false # DO NOT USE without syslog or redirect_stderr |