Re: Postgresql Logging

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.
>
>  
>