From: Tom Lane <tgl@sss.pgh.pa.us>
To: Marco Colli <collimarco91@gmail.com>
cc: Justin Pryzby <pryzby@telsasoft.com>,
        pgsql-performance@lists.postgresql.org
Subject: Re: Bad query plan when you add many OR conditions
In-reply-to: 
 <CAFvCgN7yQFLjwLSs7VPLp8VxUrGTy5uzmQ8_GfraXTUSQdyoQQ@mail.gmail.com>
References: 
 <CAFvCgN5N+C1BZdri5t2gnP15UFNBGtg6Ve0nJ7WALr4XwWYorg@mail.gmail.com>
 <20200110030601.GH12066@telsasoft.com>
 <CAFvCgN7Kf35VDEu_e8f-qfUjq-2vhs21rbc1UJqEfos0=TMcUw@mail.gmail.com>
 <20200110133447.GI12066@telsasoft.com>
 <CAFvCgN7yQFLjwLSs7VPLp8VxUrGTy5uzmQ8_GfraXTUSQdyoQQ@mail.gmail.com>
Comments: In-reply-to Marco Colli <collimarco91@gmail.com>
	message dated "Fri, 10 Jan 2020 15:53:22 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <28695.1578669482.1@sss.pgh.pa.us>
Date: Fri, 10 Jan 2020 10:18:02 -0500
Message-ID: <28696.1578669482@sss.pgh.pa.us>
Precedence: bulk

Marco Colli <collimarco91@gmail.com> writes:
> As you can see it is a *index scan* and not an *index only* scan... I don't
> understand why. The index includes all the fields used by the query... so
> an index only scan should be possible.

Huh?  The query is "select * from ...", so it retrieves *all* columns
of the table.

			regards, tom lane