[GENERAL] Reg: Logging log_min_duration_statement
I set log_min_duration_statement to 1 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*
Re: [GENERAL] Reg: Logging log_min_duration_statement
On Wed, Apr 22, 2009 at 9:16 AM, S Arvind arvindw...@gmail.com wrote: I set log_min_duration_statement to 1 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
Re: [GENERAL] Reg: Logging log_min_duration_statement
In response to S Arvind : I set log_min_duration_statement to 1 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general