Re: show Heap Fetches in EXPLAIN for index-only scans - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: show Heap Fetches in EXPLAIN for index-only scans
Date
Msg-id CAEYLb_Uy1dnSWA9g+SH7CAzN5g=Mx63WzL9pS50iGh1S+AjG6Q@mail.gmail.com
Whole thread Raw
In response to show Heap Fetches in EXPLAIN for index-only scans  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 13 January 2012 15:21, Robert Haas <robertmhaas@gmail.com> wrote:
> I think that people who are using index-only scans are going to want
> some way to find out the degree to which the scans are in fact
> index-only.
>
> So here's a 5-line patch that adds the number of heap fetches to the
> EXPLAIN ANALYZE output.  This might not be all the instrumentation
> we'll ever want here, but I think we at least want this much.

Good idea. The fact that that information wasn't available did bother me.

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services


pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Disabled features on Hot Standby
Next
From: Robert Haas
Date:
Subject: Re: show Heap Fetches in EXPLAIN for index-only scans