Re: Change in Log Format and Prepared Statements

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Alexander Stanier <alexander(dot)stanier(at)egsgroup(dot)com>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Change in Log Format and Prepared Statements
Date: 2012-09-19 05:25:55
Message-ID: 50595763.8070008@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2012-09-19 06:32:06 Re: Change in Log Format and Prepared Statements
Previous Message Craig Ringer 2012-09-19 05:09:14 Re: pgbouncer transaction patch?