An Index Only Scan is possible when the index can return every required column. PostgreSQL must also know that matching heap pages contain only visible tuples; otherwise it visits the heap for visibility. For example, a missing path column forces a heap visit, while adding INCLUDE (path) covers it as payload without making it a search key.