Marco Colli <collimarc...@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
