Re: Log files cluttered with jdbc3/4 for pg8.2 - Mailing list pgsql-jdbc

On Fri, 2007-06-22 at 10:00 -0400, Tom Lane wrote:
> > I need to have log_duration at 0 so I log EVERY call from the jdbc to
> > the postgresql because that's excellent way of debuging the dataflow
> > from the middle-tier to the application.
>
> That is a job for log_statement not log_duration.

Thnx, that makes sense now :) I guess I overlooked log_statement for
some reason in pg8.0.

Altough I'd like to see this:

SELECT LOG: execute <unnamed>: select * from ad_get('104', '2007-07-02
14:36:57.361+02', '109')

instead of

SELECT LOG:  execute <unnamed>: select * from ad_get($1, $2, $3) as
result
SELECT DETAIL:  parameters: $1 = '104', $2 = '2007-07-02 14:36:57.361
+02', $3 = '109'

Yes, I know, prepared statements, but still..


    Mario