Request a Demo
Home   >   mailing lists

Re: Index Only Scans with functions - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Index Only Scans with functions
Date
Msg-id CAKFQuwZkZb6BXA3ELVQnAZKWk_VL3jcv0ZaQszRq9zRnALJXOA@mail.gmail.com
Whole thread
In response to Index Only Scans with functions  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
Tree view
On Mon, Jul 6, 2026 at 8:44 AM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/18/indexes-index-only-scans.html
 
and concludes that an index-only scan is not possible."

I tried to reproduce the behavior, but it used the index (which is good):

You haven't demonstrated it using an index ONLY scan which is what that section is talking about.


                                                QUERY PLAN
-----------------------------------------------------------------------------------------------------------
 Index Scan using t_i1 on t  (cost=0.42..8.69 rows=1 width=4) (actual
time=0.034..0.035 rows=1.00 loops=1)
    

David J.

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Index Only Scans with functions
Next
From: surya poondla
Date:
Subject: Re: doc: Clarify ANALYZE VERBOSE output