On 18/9/2025 09:20, David Rowley wrote:
On Thu, 18 Sept 2025 at 18:36, Jean-Christophe BOGGIO
If it still takes a long time, you might try SET enable_mergejoin = 0;
and run the EXPLAIN ANALYZE SELECT .. part. That'll at least give us
more accurate row counts of what we're actually working with.This appears to be a good example of a missing feature: the in-execution
callback or hook.
Imagine if we had a hook within the ExecProcNode. In that scenario, we
could create a trivial extension that would stop the query after, let's
say, 10 minutes of execution and display the current state. This would
give us more reliable data on estimation and the state of the plan tree.
What are your thoughts?
--
regards, Andrei Lepikhov
