Re: Printing query durations - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Printing query durations
Date
Msg-id C2617EFB-3E07-431A-988A-CEBF85C41544@fastcrypt.com
Whole thread Raw
In response to Printing query durations  (Kevin Dorne <kevin@catalyst.net.nz>)
Responses Re: Printing query durations  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Kevin,

There is no difference between a jdbc query and a psql query. The
backend doesn't know where the query comes from.

DAve
On 27-Mar-06, at 8:26 PM, Kevin Dorne wrote:

> Hello,
>
> I am having some trouble getting PostgreSQL to log durations with
> statements when called through JDBC.  They appear just fine with
> interactive queries using psql, but the duration field does not
> show up
> on JDBC queries.
>
> Is there some configuration I need to pass to the JDBC driver?
>
> Example output from an interactive query:
> LOG:  duration: 109.524 ms  statement: SELECT count(*) FROM
> transaction;
>
> Example output from a JDBC query:
> LOG:  statement: SELECT count(*) FROM transaction;
>
> Cheers,
> -k
>


pgsql-jdbc by date:

Previous
From: Kevin Dorne
Date:
Subject: Printing query durations
Next
From: Tom Lane
Date:
Subject: Re: gcj has a lot of complaints about 8.1-405 release