Re: Adding qualification conditions to EXPLAIN output - Mailing list pgsql-hackers

> 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