Re: How to log canceled SQL statement due to statement timeout

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: How to log canceled SQL statement due to statement timeout
Дата
Msg-id 4DA58AEC020000250003C79C@gw.wicourts.gov
обсуждение исходный текст
Ответ на How to log canceled SQL statement due to statement timeout  (Eric Comeau <ecomeau@signiant.com>)
Ответы Re: How to log canceled SQL statement due to statement timeout  (Eric Comeau <ecomeau@signiant.com>)
Список pgsql-admin
Eric Comeau <ecomeau@signiant.com> wrote:

> We currently have statement timeout set
>
>        statement_timeout = 10800000  # 3 hrs
>
> and we receive the following in the postgresql.log
>
>    [1-1] ERROR:  canceling statement due to statement timeout
>
> Is there a way to have the SQL statement logged as well?

log_min_error_statement = 'ERROR'

-Kevin

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

Предыдущее
От: Eric Comeau
Дата:
Сообщение: How to log canceled SQL statement due to statement timeout
Следующее
От: raghu ram
Дата:
Сообщение: Streaming Replication limitations