Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] EXPLAIN doesn't explain operations on inheritance trees

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane)
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] EXPLAIN doesn't explain operations on inheritance trees
Date: 1998-07-15 15:10:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
> If I create a class A and make subclasses A1 and A2, then
> I get useful explanations when I say "EXPLAIN SELECT * FROM A1 ..."
> but not if I ask about a query on the inheritance tree A*.
> tgl=> EXPLAIN SELECT * FROM A* WHERE accountid = 3;
> Append  (cost=0.00 size=0 width=0)
> With "explain verbose" it is possible to see that the APPEND plan
> has substructure, but it's hard to see what's going on in that format.
> How come plain "explain" doesn't show the subnodes of an APPEND plan?

I have just applied a patch to fix this.  Append is an unusual node,
because instead of checking left/right plans, you have to loop through a
list of plans.  EXPLAIN did not do this, nor did cost computations and

Should be better now.  

I renamed all the Append structure names because they were very
confusing to me.  I had created some of them for UNION, but named the

Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-07-15 15:32:19
Subject: Re: Recent updates
Previous:From: Bruce MomjianDate: 1998-07-15 14:42:00
Subject: Re: [INTERFACES][HACKERS] atttypmod now 32 bits, interface change

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group