Skip site navigation (1) Skip section navigation (2)

Re: log_duration?

From: "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: log_duration?
Date: 2007-02-19 16:39:39
Message-ID: 45D9D2CB.1040600@mailnetwork.co.uk (view raw or flat)
Thread:
Lists: pgsql-admin
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.

In response to

pgsql-admin by date

Next:From: Dmitry MorozovskyDate: 2007-02-19 18:30:07
Subject: grant model in PostgreSQL 8.2
Previous:From: Ray StellDate: 2007-02-19 16:19:37
Subject: log_duration?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group