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

From Magnus Hagander
Subject Re: show Heap Fetches in EXPLAIN for index-only scans
Date
Msg-id CABUevEw8189hPjRoq70TVG0OzfjQwWoyit=h9XhOZFCxeuen9w@mail.gmail.com
Whole thread Raw
In response to show Heap Fetches in EXPLAIN for index-only scans  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: show Heap Fetches in EXPLAIN for index-only scans  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, Jan 13, 2012 at 16: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.

Agreed.

Would also be good to have counter sin pg_stat_* for this, since you'd
usually want to look at this kind of data over time as well. In your
plans? ;)

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Disabled features on Hot Standby
Next
From: Jim Nasby
Date:
Subject: Re: Disabled features on Hot Standby