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

Re: EXPLAIN Node Docs?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: EXPLAIN Node Docs?
Date: 2011-04-29 21:07:07
Message-ID: 14056.1304111227@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"David E. Wheeler" <david(at)kineticode(dot)com> writes:
> Is there any place where the contents of EXPLAIN nodes are documented?

Use the source, Luke ...

In particular, src/include/nodes/plannodes.h is pretty well commented.
If it's not immediately obvious how that maps to what's shown by
EXPLAIN, look into commands/explain.c.  (There are things that aren't
mentioned by EXPLAIN even in verbose mode, such as which columns Group
is going to group by; usually that's because it's redundant with info
available elsewhere, such as the sort columns of a lower sort node.)

Keep in mind also that we reserve the right to whack these things around
in arbitrary ways from one release to the next.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-04-29 21:59:45
Subject: Re: branching for 9.2devel
Previous:From: Vaibhav KaushalDate: 2011-04-29 20:57:19
Subject: Re: What would AggrefExprState nodes' args contain?

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