
> Index Scan using foo_f1_key on foo  (cost=0.00..17.08 rows=1 width=12)
>   indxqual: (f1 = 11)
>   qual: (f3 = 44)

Wow, that looks really nice. 
The field headers could probably be more verbose, like:

Index Scan using foo_f1_key on foo  (cost=0.00..17.08 rows=1 width=12)
   Index Filter: (f1 = 11)
   Filter: (f3 = 44)

and for btree ranges: 
   Lower Index Filter:
   Upper Index Filter:

> Question for the group: does this seem valuable enough to put into the
> standard EXPLAIN output, or should it be a special option?  I can

Imho make it standard for EXPLAIN. Simply too useful to not show it :-)

Andreas

Tue, 12 Mar 2002 17:23:09 +0100
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>
Re: Adding qualification conditions to EXPLAIN output