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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>,"Eric Comeau" <ecomeau(at)signiant(dot)com>
Subject: Re: How to log canceled SQL statement due to statement timeout
Date: 2011-04-13 16:37:16
Message-ID: 4DA58AEC020000250003C79C@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Eric Comeau <ecomeau(at)signiant(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message raghu ram 2011-04-13 17:53:24 Streaming Replication limitations
Previous Message Eric Comeau 2011-04-13 12:06:50 How to log canceled SQL statement due to statement timeout