Re: Change in Log Format and Prepared Statements - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: Change in Log Format and Prepared Statements
Date
Msg-id 50595763.8070008@ringerc.id.au
Whole thread Raw
In response to Re: Change in Log Format and Prepared Statements  (Alexander Stanier <alexander.stanier@egsgroup.com>)
Responses Re: Change in Log Format and Prepared Statements  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
On 09/17/2012 02:45 PM, Alexander Stanier wrote:
> Thanks Dave and Craig for you input.
>
> Does anyone know what the three durations specifically represent?
> Presumably two of them are the time to prepare and execute the
> statement? What's the third? Is the overall execution time the sum of
> the three (or two in some cases)?

I have no idea, honestly. Maybe ask on pgsql-general ?

> It would be useful to have one summary time for the overall execution of
> each statement as before.

I strongly agree. Three separate log lines for timing, with no
indication about which is which, sucks.

I wonder what'd happen if a more informative log_line_prefix were added...

--
Craig Ringer


pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: pgbouncer transaction patch?
Next
From: Tom Lane
Date:
Subject: Re: Change in Log Format and Prepared Statements