Printing query durations

From: Kevin Dorne <kevin(at)catalyst(dot)net(dot)nz>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Printing query durations
Date: 2006-03-28 01:26:49
Message-ID: 442890D9.40905@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-03-28 03:01:26 Re: Printing query durations
Previous Message Tom Lane 2006-03-27 23:32:19 Re: gcj has a lot of complaints about 8.1-405 release