Re: Unexpected "canceling statement due to user request" error

Will Storey <will@summercat.com> writes:
> On Sun 2019-09-01 19:46:19 -0400, Tom Lane wrote:
>> A separate question is how come the particular query you're complaining
>> about has (seemingly) a fairly wide window where it never does any
>> CHECK_FOR_INTERRUPTS call before terminating.  Perhaps there's someplace
>> we need to sprinkle a few more of those.

> Yeah, it is strange. There are many queries in this system with statement
> timeouts and this is the only one where I see this and it happens several
> times a day.

It'd be interesting to see EXPLAIN ANALYZE output from a typical execution
of that query.  Even better would be a test case (w/ tables and dummy
data) so somebody else could reproduce it; but maybe looking at EXPLAIN
ANALYZE would be enough to determine where we're missing checks.

            regards, tom lane