Hi, When a statement is cancelled due to it running for long enough for statement_timeout to take effect, it logs a message:
ERROR: canceling statement due to statement timeout However, it doesn't log what the timeout was at the time of the cancellation. This may be set in postgresql.conf, the database, or on the role, but unless log_line_prefix is set to show the database name and the user name, there's no reliable way of finding out what context the configuration applied from. Setting log_duration won't help either because that only logs the duration of completed queries. Should we output the statement_timeout value when a query is cancelled? -- Thom -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers