Re: log_duration

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: log_duration
Дата
Msg-id GNELIHDDFBOCMGBFGEFOMEIGCFAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: log_duration  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: log_duration  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: [HACKERS] log_duration  ()
Re: [HACKERS] log_duration  ()
Список pgsql-hackers
> Tom is right here.  log_duration _just_ prints the duration, so we would
> need to basically create a merged param that does log_duration and
> log_statement and have it activate only if the statement takes more than
> X milliseconds, something like log_long_statement, or something like
> that.
>
> Here are the log_* params we have:
>
>     log_connections = false
>     log_hostname = false
>     log_source_port = false
>     log_pid = false
>     log_statement = false
>     log_duration = false
>     log_timestamp = false

OK, while I'm doing all this benchmarking and stuff - is there any sort of
option where I can see it logged when a sort doesn't have enought sort
memory and hence hits the disk?  eg. an elog(LOG) is emitted?

Chris



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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: Changing the default configuration (was Re:
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: location of the configuration files