Postgres Pro
Downloads
Home   >   mailing lists

Thread: log_duration?

log_duration?

From
Ray Stell
Date:
I toggle log_duration:

wiki=# \!date
Mon Feb 19 11:14:35 EST 2007
wiki=#  set log_duration=off;
SET
wiki=# SELECT current_setting('log_duration');
 current_setting
-----------------
 off
(1 row)

yet duration continues to be logged:

wiki,13190,wiki,2007-02-19 11:16:00.926 EST,45d94f9e.3386,36108,2007-02-19 02:19:58 EST,270828,BIND LOG:  duration:
0.034ms 
wiki,13190,wiki,2007-02-19 11:16:00.929 EST,45d94f9e.3386,36109,2007-02-19 02:19:58 EST,0,COMMIT LOG:  duration: 2.840
ms

do I have to bounce to get it set?  Thx.

Re: log_duration?

From
"Andy Shellam (Mailing Lists)"
Date:
Ray Stell wrote: 
I toggle log_duration:

wiki=# \!date
Mon Feb 19 11:14:35 EST 2007
wiki=#  set log_duration=off;
SET
wiki=# SELECT current_setting('log_duration');current_setting
-----------------off
(1 row)

yet duration continues to be logged:

wiki,13190,wiki,2007-02-19 11:16:00.926 EST,45d94f9e.3386,36108,2007-02-19 02:19:58 EST,270828,BIND LOG:  duration: 0.034 ms
wiki,13190,wiki,2007-02-19 11:16:00.929 EST,45d94f9e.3386,36109,2007-02-19 02:19:58 EST,0,COMMIT LOG:  duration: 2.840 ms

do I have to bounce to get it set?  Thx.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

!DSPAM:37,45d9d01c18514452914812!
Probably best to restart Postgres, yes.  I've observed logging functions to not take effect without a restart.

Andy.

Re: log_duration?

From
Tom Lane
Date:
Ray Stell <stellr@cns.vt.edu> writes:
> I toggle log_duration:

> wiki=# \!date
> Mon Feb 19 11:14:35 EST 2007
> wiki=#  set log_duration=off;
> SET

SET only affects your own session, not anyone else's ...

            regards, tom lane