Re: Parsing output of EXPLAIN command in PostgreSQL

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