Postgres Pro
Downloads
Home   >   mailing lists

Thread: Reg: Logging log_min_duration_statement

Reg: Logging log_min_duration_statement

From
S Arvind
Date:
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

Re: Reg: Logging log_min_duration_statement

From
Scott Mead
Date:

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

Re: Reg: Logging log_min_duration_statement

From
"A. Kretschmer"
Date:
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