Postgres Pro
Downloads
Home   >   mailing lists

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

From Eric Comeau
Subject How to log canceled SQL statement due to statement timeout
Date
Msg-id io43kp$1qpj$1@news.hub.org
Whole thread Raw
Responses Re: How to log canceled SQL statement due to statement timeout  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view 
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?

We have set the log_min_duration_statement = 5000 to log any SQL
statement that takes longer than 5 secs and this works when the
statement complete.

We are using version 8.1.17

Thanks,
Eric

pgsql-admin by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: unsupported header version error
Next
From: "Kevin Grittner"
Date:
Subject: Re: How to log canceled SQL statement due to statement timeout