Re: log_duration?
| От | Andy Shellam (Mailing Lists) |
|---|---|
| Тема | Re: log_duration? |
| Дата | |
| Msg-id | 45D9D2CB.1040600@mailnetwork.co.uk обсуждение исходный текст |
| Ответ на | log_duration? (Ray Stell <stellr@cns.vt.edu>) |
| Список | pgsql-admin |
Ray Stell wrote:
Andy.
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!
Andy.
В списке pgsql-admin по дате отправления: