Re: Parsing output of EXPLAIN command in PostgreSQL - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: Parsing output of EXPLAIN command in PostgreSQL
Date
Msg-id 4EBC547F.2030300@proxel.se
Whole thread Raw
In response to Re: Parsing output of EXPLAIN command in PostgreSQL  (Andreas Karlsson <andreas@proxel.se>)
List pgsql-hackers
On 2011-11-10 23:42, Andreas Karlsson wrote:
> Hi,
>
> I recommend using the XML, JSON or YAML version of the plan, whichever
> is easiest in your programming language to parse. I do not think anyone
> has written a formal schema yet for the XML but it still should be much
> easier to parse than rolling your own parser for the human readable format.
>
> But if you insist on parsing the human readable format, e.g. to support
> versions before 9.1, I recommend that you take a look at
> http://explain.depesz.com/ which supports parsing text plans in addition
> to XML and JSON. The site is open source and written in Perl.
>
> The source code can be found at:
>
> https://github.com/depesz/Pg--Explain

Sorry, I did not see the other thread about the same thing. Let's keep 
all discussion there.

-- 
Andreas Karlsson


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disable OpenSSL compression
Next
From: Robert Haas
Date:
Subject: Re: LOCK_DEBUG is busted