Re: [ADMIN] SELECT statements in log files

2006-03-03 Thread Volkan YAZICI
On Mar 03 06:20, Simon Riggs wrote: > On Fri, 2006-03-03 at 12:19 +0100, Mario Splivalo wrote: > > When I connect to postgres from PHP or Python or using just psql, I can > > see full SELECT querries logged, with the actuall values for the > > parameters. > > Those interfaces do not use prepared s

Re: [ADMIN] SELECT statements in log files

2006-03-03 Thread Simon Riggs
On Fri, 2006-03-03 at 12:19 +0100, Mario Splivalo wrote: > We're using JDBC to connect to postgres server. I've setup logging so > that any query that executes over 100ms gets logged. But, the log file > looks like this: > > > 2006-03-03 12:17:08 CET [31591] SELECTLOG: duration: > 253.307 ms s

[ADMIN] SELECT statements in log files

2006-03-03 Thread Mario Splivalo
We're using JDBC to connect to postgres server. I've setup logging so that any query that executes over 100ms gets logged. But, the log file looks like this: 2006-03-03 12:17:08 CET [31591] SELECTLOG: duration: 253.307 ms statement: EXECUTE [PREPARE: select * from create_mt_sms_message($1,