| From: | Peter Geoghegan <peter(at)2ndquadrant(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: show Heap Fetches in EXPLAIN for index-only scans |
| Date: | 2012-01-13 15:31:19 |
| Message-ID: | CAEYLb_Uy1dnSWA9g+SH7CAzN5g=Mx63WzL9pS50iGh1S+AjG6Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 13 January 2012 15:21, Robert Haas <robertmhaas(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2012-01-13 15:31:42 | Re: show Heap Fetches in EXPLAIN for index-only scans |
| Previous Message | Jim Nasby | 2012-01-13 15:31:13 | Re: Disabled features on Hot Standby |