Re: Adding qualification conditions to EXPLAIN output

On Sat, Mar 09, 2002 at 06:02:17PM -0500, Tom Lane wrote:
> I have been fooling around with adding decompiled display of plan
> qualification conditions to EXPLAIN output.  With this, you can
> for example tell the difference between indexscanned and
> not-indexscanned clauses, without having to dig through EXPLAIN
> VERBOSE dumps.  Here is an example motivated by Rob Hoopman's
> recent query on pgsql-general:

Very neat, Tom. Information on projections would also be nice.

> 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
> imagine showing it only in EXPLAIN VERBOSE's summary display, or adding
> a GUC variable to enable it, or adding another option keyword to
> EXPLAIN, but I don't much want to do any of those things.  On the other
> hand, maybe this stuff won't make any sense to non-experts anyway.
> Thoughts?

My initial thought is to display the information in one of the new
VERBOSE levels, perhaps the first (default)?

Liam

-- 
Liam Stewart :: Red Hat Canada, Ltd. :: liams@redhat.com