Re: Why isn't PG using an index-only scan?

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:
thein-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