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

EXPLAIN doesn't explain operations on inheritance trees

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)hub(dot)org
Subject: EXPLAIN doesn't explain operations on inheritance trees
Date: 1998-07-14 17:48:41
Message-ID: 16520.900438521@sss.pgh.pa.us (view raw or flat)
Thread:
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;
NOTICE:  QUERY PLAN:

Append  (cost=0.00 size=0 width=0)

EXPLAIN

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?

			regards, tom lane

Responses

pgsql-hackers by date

Next:From: Mike EmbryDate: 1998-07-14 20:37:31
Subject: SEQUENCES and COPY FROM
Previous:From: Bruce MomjianDate: 1998-07-14 17:01:44
Subject: Re: Recent updates

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