Postgresql Logging - Mailing list pgsql-general

From Ericson Smith
Subject Postgresql Logging
Date
Msg-id 40B4E242.6000700@did-it.com
Whole thread Raw
Responses Re: Postgresql Logging
List pgsql-general
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.

--
Warmest regards,
Ericson Smith
Tracking Specialist/DBA
+-----------------------+----------------------------+
| http://www.did-it.com | RAM is cheap. RAM is fun   |
| eric@did-it.com       | RAM should go to everyone! |
| 516-255-0500          |             - Sascga Segan |
+-----------------------+----------------------------+


Attachment

pgsql-general by date:

Previous
From: Frank Finner
Date:
Subject: Re: performance very slow
Next
From: Bruce Momjian
Date:
Subject: Re: Postgresql Logging