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