autovacuum

Your "Index Only Scan" Did 2,847 Heap Fetches: Covering Indexes Are a Vacuum Problem

A dev.to workshop makes a case worth repeating: the plan label describes intent, not cost. Whether a covering index actually skips the heap is decided by autovacuum, not by the index.