Parsing output of EXPLAIN command in PostgreSQL

From: Αναστάσιος Αρβανίτης <tasosarvanitis(at)yahoo(dot)gr>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Parsing output of EXPLAIN command in PostgreSQL
Date: 2011-11-10 16:10:46
Message-ID: 1320941446.71274.YahooMailNeo@web26208.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm developing an application that requires parsing of
execution plans (those produced as output by issuing an EXPLAIN [query]
command). Are you aware of any Java library that I could use for this
purpose? I found https://github.com/depesz/Pg--Explain but it is built in Perl.

Also another option I am considering is to use EXPLAIN [query] FORMAT XML which is available in PostgreSQL 9.1. However, in that case it
would better to have the XML Schema of the generated plans available.

Is there any other solution I am not aware of?

Thank you

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Αναστάσιος Αρβανίτης 2011-11-10 16:23:00 Parsing output of EXPLAIN command in PostgreSQL
Previous Message Robert Haas 2011-11-10 16:09:34 Re: Disable OpenSSL compression