public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andrei Lepikhov <[email protected]>
To: David Rowley <[email protected]>
To: Jean-Christophe BOGGIO <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Why isn't PG using an index-only scan?
Date: Thu, 18 Sep 2025 09:55:57 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAApHDvoUdvw68oHnfACQE=u8XPJ+Te49dZsfC2yW+DVfzdT2+Q@mail.gmail.com>
References: <[email protected]>
<CAApHDvoUdvw68oHnfACQE=u8XPJ+Te49dZsfC2yW+DVfzdT2+Q@mail.gmail.com>
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
view thread (9+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Why isn't PG using an index-only scan?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox