"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