From: | Kevin Dorne <kevin(at)catalyst(dot)net(dot)nz> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Printing query durations |
Date: | 2006-03-29 01:41:16 |
Message-ID: | 4429E5BC.9050604@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Simon Riggs wrote:
[...]
>> 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.
Yes, that's what I would expect. My problem is that this setting only
logs queries via psql; queries via JDBC don't get logged at all.
>> 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.
Yes, I've done that. Again, I can get those durations to appear for
queries via psql, but not via JDBC.
[...]
By the way, the JDBC driver I'm using (thanks Markus Schaber for the
tip) is "PostgreSQL 8.0 JDBC3 with SSL (build 311)".
-k
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2006-03-29 01:50:26 | Re: Printing query durations |
Previous Message | Kris Jurka | 2006-03-28 20:56:42 | Re: Array support in 8.1 JDBC driver |