Re: REVIEW: EXPLAIN and nfiltered

On Jan22, 2011, at 17:55 , Tom Lane wrote:
> Reflecting on that, I'm inclined to suggest
> 
>     Bitmap Heap Scan ...
>         Recheck Cond: blah blah
>         Rows Removed by Recheck: 42
>         Filter Cond: blah blah blah
>         Rows Removed by Filter: 77
> 
> or even more verbosely
> 
>     Bitmap Heap Scan ...
>         Recheck Cond: blah blah
>         Rows Removed by Recheck Cond: 42
>         Filter Cond: blah blah blah
>         Rows Removed by Filter Cond: 77
> 
> ie repeat the label of the filtering condition exactly.  This is looking
> pretty long, but from the viewpoint of vertical or horizontal space
> occupied by the printout, I doubt it matters.

+1. Repeating the label of the condition adds enough context to make
"Removed" unambiguous IMHO.

best regards,
Florian Pflug