Will Storey <will@xxxxxxxxxxxxx> 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
