| Lists: | pgsql-admin |
|---|
| From: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | log_duration? |
| Date: | 2007-02-19 16:19:37 |
| Message-ID: | 20070219161937.GA7927@cns.vt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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.
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: log_duration? |
| Date: | 2007-02-20 02:40:09 |
| Message-ID: | 18571.1171939209@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Ray Stell <stellr(at)cns(dot)vt(dot)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