- 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.
begin:vcard fn:Ericson Smith n:Smith;Ericson org:Did-it.com;Programming adr:#304;;55 Maple Avenue;Rockville Center;NY;11570;USA email;internet:eric@did-it.com title:Web Developer tel;work:516-255-0500 tel;cell:646-483-3420 note:Nothing special! x-mozilla-html:FALSE url:http://www.did-it.com version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
