Re: Parsing output of EXPLAIN command in PostgreSQL

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Parsing output of EXPLAIN command in PostgreSQL
Дата
Msg-id CA+TgmoZrM26=K8L4L9BiO-DwqRjWHppQx96TH6F36cci_14oXg@mail.gmail.com
обсуждение исходный текст
Ответ на Parsing output of EXPLAIN command in PostgreSQL  (Αναστάσιος Αρβανίτης <tasosarvanitis@yahoo.gr>)
Ответы Re: Parsing output of EXPLAIN command in PostgreSQL  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
2011/11/10 Αναστάσιος Αρβανίτης <tasosarvanitis@yahoo.gr>:
> 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?

Not that I know of.  I think pgAdmin can parse the EXPLAIN output,
too, but that's in C++.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: type privileges and default privileges
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: const correctness