Re: fix log_min_duration_statement logic error

Bruce Momjian writes:

> Another idea if you like consistency would be:
>
>     LOG:  duration: 4.056 ms  query: select * \nfrom pg_language;

Speaking of consistency...

Imagine someone always having log_statement on and doing some sort of
aggregate query counting, say like grep '^LOG: query:' | wc -l.  Now that
someone (or maybe the admin on the night shift, to make it more dramatic)
also turns on log_min_statement_duration (or whatever it's spelled), say
to find the slowest queries: grep '^LOG: duration:' | sort -xyz | head
-10.  In order to guarantee the consistency of both results, you'd have to
log each query twice in this case.

--
Peter Eisentraut   peter_e@gmx.net