Reg: Logging log_min_duration_statement
I set log_min_duration_statement to 10000 and restart the postgres. But when
i check the tail to log i am getting all queries. please tell is it bug ?
i have log_statement = all . is there any relation between this and
min_duaration?
Arvind S
*
"Many of lifes failure are people who did not realize how close they were to
success when they gave up."
-Thomas Edison*
On Wed, Apr 22, 2009 at 9:16 AM, S Arvind <arvindwill@gmail.com> wrote:
I set log_min_duration_statement to 10000 and restart the postgres. But
when
i check the tail to log i am getting all queries. please tell is it bug ?
i have log_statement = all . is there any relation between this and
min_duaration?
I think we covered this in IRC, but you should set log_statement=none and
leave log_min_duration_statement as is.
--Scott
In response to S Arvind :
I set log_min_duration_statement to 10000 and restart the postgres. But when
i check the tail to log i am getting all queries. please tell is it bug ?
i have log_statement = all . is there any relation between this and
min_duaration?
log_statement = all loggs _all_ statements, but
log_min_duration_statement loggs only statements with a duraton time
more than the parameter (ms).
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net