Index: doc/src/sgml/runtime.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v retrieving revision 1.332 diff -c -c -r1.332 runtime.sgml *** doc/src/sgml/runtime.sgml 26 Jun 2005 19:16:04 -0000 1.332 --- doc/src/sgml/runtime.sgml 1 Jul 2005 13:25:51 -0000 *************** *** 2628,2643 **** ! 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 ! 250 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. --- 2628,2644 ---- ! 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 250 ! 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 log_statement and ! log_duration. Only superusers can change ! this setting. Index: src/backend/utils/misc/postgresql.conf.sample =================================================================== RCS file: /cvsroot/pgsql/src/backend/utils/misc/postgresql.conf.sample,v retrieving revision 1.148 diff -c -c -r1.148 postgresql.conf.sample *** src/backend/utils/misc/postgresql.conf.sample 26 Jun 2005 03:03:41 -0000 1.148 --- src/backend/utils/misc/postgresql.conf.sample 1 Jul 2005 13:25:53 -0000 *************** *** 227,233 **** # debug5, debug4, debug3, debug2, debug1, # info, notice, warning, error, panic(off) ! #log_min_duration_statement = -1 # -1 is disabled, in milliseconds. #silent_mode = false # DO NOT USE without syslog or redirect_stderr --- 227,234 ---- # debug5, debug4, debug3, debug2, debug1, # info, notice, warning, error, panic(off) ! #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