Обсуждение: 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
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 think we covered this in IRC, but you should set log_statement=none and leave log_min_duration_statement as is.
--Scott
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