log_min_duration question

From: Harald Fuchs <hari(dot)fuchs(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: log_min_duration question
Date: 2016-02-08 08:25:56
Message-ID: 87bn7r7gmj.fsf@hf.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From the 9.5 docs:

log_min_duration_statement (integer)

Causes the duration of each completed statement to be logged if the
statement ran for at least the specified number of
milliseconds. Setting this to zero prints all statement
durations. Minus-one (the default) disables logging statement
durations. For example, if you set it to 250ms then all SQL statements
that run 250ms or longer will be logged.

While the first sentence explicitly states a fixed unit (namely msec),
the last sentence seems to imply a (maybe optional) unit suffix
(ms in this case). Which one is true?

How would e.g. "SET log_min_duration_statement=1min" be interpreted?

I'd prefer a docs clarification.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Berkus 2016-02-08 09:13:42 Re: log_min_duration question
Previous Message Pierre HILBERT 2016-02-08 08:15:32 Re: Trouble installing postgresql server on Amazon Linux