Exactly what I need. Thanks a lot.
- Ericson
Bruce Momjian wrote:
>Ericson Smith wrote:
>
>
>>Hi,
>>
>>Currently we are logging SQL statements for profiling purposes. We now
>>get something like this:
>>
>>2004-05-26 13:27:51 [30017] LOG: statement: SELECT * FROM cache_62
>>WHERE key='6832271710644150012240e7153b6f62'
>>2004-05-26 13:27:51 [30017] LOG: duration: 0.733 ms
>>
>>Is there a way to get the duration into the statement line as well?
>>Sometimes the logging overlaps, so its difficult to decide which
>>duration applies to which statement, even though the have the PID in there.
>>
>>
>
>Sure, set log_min_duration_statement to 0. That is new in 7.4.
>
>
>
