Postgres Pro
Downloads
Home   >   mailing lists

Re: How to log canceled SQL statement due to statement timeout - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: How to log canceled SQL statement due to statement timeout
Date
Msg-id 4DA58AEC020000250003C79C@gw.wicourts.gov
Whole thread Raw
In response to How to log canceled SQL statement due to statement timeout  (Eric Comeau <ecomeau@signiant.com>)
Responses Re: How to log canceled SQL statement due to statement timeout  (Eric Comeau <ecomeau@signiant.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Eric Comeau
Date:
Subject: How to log canceled SQL statement due to statement timeout
Next
From: raghu ram
Date:
Subject: Streaming Replication limitations