> 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