Re: Printing query durations

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
>