Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit8f6e8e8

Browse files
committed
Clarify documentation about log_min_duration_statement.
1 parent5350216 commit8f6e8e8

File tree

2 files changed

+14
-12
lines changed

2 files changed

+14
-12
lines changed

‎doc/src/sgml/runtime.sgml

Lines changed: 12 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
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 $
33
-->
44

55
<chapter Id="runtime">
@@ -2628,16 +2628,17 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows
26282628
</indexterm>
26292629
<listitem>
26302630
<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.
26412642
</para>
26422643
</listitem>
26432644
</varlistentry>

‎src/backend/utils/misc/postgresql.conf.sample

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -227,7 +227,8 @@
227227
# debug5, debug4, debug3, debug2, debug1,
228228
# info, notice, warning, error, panic(off)
229229

230-
#log_min_duration_statement = -1 # -1 is disabled, in milliseconds.
230+
#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements
231+
# and their durations, in milliseconds.
231232

232233
#silent_mode = false # DO NOT USE without syslog or redirect_stderr
233234

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp