Re: Understanding EXPLAIN ANALYZE output - Mailing list pgsql-general

From Tom Lane
Subject Re: Understanding EXPLAIN ANALYZE output
Date
Msg-id 4585.1108082047@sss.pgh.pa.us
Whole thread Raw
In response to Re: Understanding EXPLAIN ANALYZE output  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Understanding EXPLAIN ANALYZE output  (Greg Stark <gsstark@mit.edu>)
Re: Understanding EXPLAIN ANALYZE output  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> I've been wondering about that. A while ago the change was made from
> outputting a NOTICE with the EXPLAIN output to returning a resultset.
> If you could agree on what columns to return it might not be so hard
> for the EXPLAIN to return full tuples...

The major stumbling block to that is that a table is inherently
unordered, so you'd have to devise a labeling scheme to allow the
node-tree structure to be represented properly.  And without WITH or
CONNECT BY, it'd be a bit of a PITA for an application to decipher the
labeling scheme again ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Stapleton, Mike"
Date:
Subject: Fwd: Unending recursive gmake during install?
Next
From: Tom Lane
Date:
Subject: Re: Fwd: Unending recursive gmake during install?