Marco Colli <collimarco91@xxxxxxxxx> 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