From: | Ericson Smith <eric(at)did-it(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql Logging |
Date: | 2004-05-26 19:59:42 |
Message-ID: | 40B4F72E.3090705@did-it.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
>
>
Attachment | Content-Type | Size |
---|---|---|
eric.vcf | text/x-vcard | 315 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Shanny | 2004-05-26 20:00:37 | Problem with sequences on a reload of a pg_dump file |
Previous Message | mack paul | 2004-05-26 19:23:24 | temas del comando COPY |