Horton

Re: REVIEW: EXPLAIN and nfiltered

Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>

View thread
From: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: depesz@depesz.com, Stephen Frost <sfrost@snowman.net>, Robert Haas <robertmhaas@gmail.com>, Magnus Hagander <magnus@hagander.net>, pgsql-hackers@postgresql.org
Date: 2011-01-20T23:23:45Z
Lists: pgsql-hackers 
On 1/20/2011 12:47 PM, Tom Lane wrote:
> So the line I'm thinking we should pursue is to visually associate the
> new counter with the filter condition, either like
>
> 	Filter Cond: (x>  42)  (nfiltered = 123)
>
> or
>
> 	Filter Cond: (x>  42)
> 	Rows Filtered: 123

I'd prefer the latter.  Sometimes the Filter Cond is very complex and 
finding the nfiltered information would be easier if it always had its 
own row.


Regards,
Marko Tiikkaja