Exactly what I need. Thanks a lot.
Bruce Momjian wrote:
>Ericson Smith wrote:
>>Currently we are logging SQL statements for profiling purposes. We now
>>get something like this:
>>2004-05-26 13:27:51  LOG: statement: SELECT * FROM cache_62
>>2004-05-26 13:27:51  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.
Description: text/x-vcard (315 bytes)
In response to
pgsql-general by date
|Next:||From: Sean Shanny||Date: 2004-05-26 20:00:37|
|Subject: Problem with sequences on a reload of a pg_dump file|
|Previous:||From: mack paul||Date: 2004-05-26 19:23:24|
|Subject: temas del comando COPY|