Re: EXPLAIN and nfiltered - Mailing list pgsql-hackers

From Andres Freund
Subject Re: EXPLAIN and nfiltered
Date
Msg-id 201011181744.29184.andres@anarazel.de
Whole thread Raw
In response to EXPLAIN and nfiltered  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
Responses Re: EXPLAIN and nfiltered
List pgsql-hackers
On Thursday 18 November 2010 16:45:23 Marko Tiikkaja wrote:
> Hi,
> 
> Here's a patch for showing in EXPLAIN ANALYZE the number of rows a plan
> qual filtered from a node's input.  The output looks like this:
If it supports the same for index-scans I *really* like it and even proposed a 
patch earlier (4A16A8AF.2080508@anarazel.de)
I still find myself constantly wishing to have something like that... 
Especially when wondering if it might be worthwile to add another column 
(which is implemented as an additional qual atm) should get included in a 
multiicolumn index.

It was shot down at the time because it might break some explain-parsers 
expectations. Imho that argument is less valid these days.

Andres


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: final patch - plpgsql: for-in-array
Next
From: Marko Tiikkaja
Date:
Subject: Re: EXPLAIN and nfiltered