From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Kevin Dorne <kevin(at)catalyst(dot)net(dot)nz> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Printing query durations |
Date: | 2006-03-28 10:32:36 |
Message-ID: | 1143541956.3839.329.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Tue, 2006-03-28 at 13:26 +1200, Kevin Dorne wrote:
> 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?
These two logging formats are each produced by different parameters:
> Example output from an interactive query:
> LOG: duration: 109.524 ms statement: SELECT count(*) FROM transaction;
This is produced by log_min_duration_statement > -1
These lines always have duration prefixes.
> Example output from a JDBC query:
> LOG: statement: SELECT count(*) FROM transaction;
This is produced by log_statement = 'all'
These lines never have durations.
If you want the matching durations, use log_duration = on and read the
manual to see how to match them up.
The same statement can be logged twice using those options.
http://www.postgresql.org/docs/8.1/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
Does that answer your query?
Best Regards, Simon Riggs
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Schaber | 2006-03-28 11:44:57 | Re: Printing query durations |
Previous Message | Kevin Dorne | 2006-03-28 04:33:52 | Re: Printing query durations |