Re: Why isn't PG using an index-only scan? - Mailing list pgsql-performance

On Thu, 18 Sept 2025 at 19:45, Jean-Christophe BOGGIO
<postgresql@thefreecat.org> wrote:
> Ok but then why is it doing it on the AD table? Is it because of the
> number of rows?

It's hard to tell as I don't have a clear view on which columns are
from which tables.  Perhaps "ad" can Index Only Scan because all of
the columns required are in an index but with "oeu" there's a column
being used that's not indexed?

David