Re: log_duration

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Looking at the log_duration postgresql.conf option.  How about adding an
> option log_duration_min which is a value in milliseconds that is the minimum
> time a query must run for before being logged.

Fine with me --- but you'll need to add more logic than that.  Right
now, log_duration *only* causes the query duration to be printed out;
if you ain't got log_statement on, you're in the dark as to what the
query itself was.  You'll need to add some code to print the query
(the log_min_error_statement logic might be a useful source of
inspiration).  Not sure how this should interact with the case where
log_duration is set and the min-duration isn't.  But maybe that case
is silly, and we should just redefine log_duration as a minimum runtime
that causes the query *and* its runtime to be printed to the log.
        regards, tom lane