Re: postgres seems to ignore log_min_duration_statement

Поиск
Список
Период
Сортировка
От Vladimir Rusinov
Тема Re: postgres seems to ignore log_min_duration_statement
Дата
Msg-id f6fdfb550810140441y75db39f3l7aea87cce27cc37f@mail.gmail.com
обсуждение исходный текст
Ответ на postgres seems to ignore log_min_duration_statement  ("Martin A. Brooks" <martin@antibodymx.net>)
Ответы Re: postgres seems to ignore log_min_duration_statement
Список pgsql-admin
Дерево обсуждения




On Tue, Oct 14, 2008 at 1:23 PM, Martin A. Brooks <martin@antibodymx.net> wrote:
Hi

I want to have postgres log sql statements that take longer than 5 seconds to execute.  In postgresql.conf I have set log_min_duration_statement as follows:

root@martin-desktop:/etc/postgresql/8.3/main# grep log_min_duration postgresql.conf
log_min_duration_statement = 5000       # -1 is disabled, 0 logs all statements


May be you have log_min_messages = debug?
Please, show full logging section.


--
Vladimir Rusinov
http://greenmice.info/

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Martin A. Brooks"
Дата:
Сообщение: Re: postgres seems to ignore log_min_duration_statement
Следующее
От: "Martin A. Brooks"
Дата:
Сообщение: Re: postgres seems to ignore log_min_duration_statement