2009/12/29 matt <nuc...@yahoo.com>: > > > --- On Mon, 12/28/09, Andres Freund <and...@anarazel.de> wrote: > >> From: Andres Freund <and...@anarazel.de> >> Subject: Re: [HACKERS] parse tree to XML format >> To: pgsql-hackers@postgresql.org >> Cc: "Robert Haas" <robertmh...@gmail.com>, "matt" <nuc...@yahoo.com> >> Date: Monday, December 28, 2009, 7:39 PM >> On Tuesday 29 December 2009 01:35:25 >> Robert Haas wrote: >> > On Mon, Dec 28, 2009 at 7:32 PM, Andres Freund <and...@anarazel.de> >> wrote: >> > > On Monday 28 December 2009 22:30:44 matt wrote: >> > >> Is there some way to export the postgresql >> query parse tree in XML >> > >> format? I can not locate the API/Tool etc to >> do that... >> > > >> > > Thats more of a -general question. >> > > >> > > There is no such possibility in 8.4 - the not yet >> released 8.5 contains >> > > such a possibility. >> > >> > Well, you can export the plan as XML using EXPLAIN >> (FORMAT XML), but >> > that's not the same thing as the query parse-tree. >> Uh. Err. Sorry. >> >> You can play around with "debug_print_parse" but thats many >> things but >> definitely not xml. >> >> Matt, what are you trying to achieve? > > We are trying to gather statistics about our queries and get automatic > suggestions for what indexes to utilize ...its easier to figure that on > queries that are in some format else we have to effectively parse the queries > ourself or hack the postgresql parser...which we dont want to do...
It's wrong place - you have to parse execution plan. Parser knows nothing about index usage. maybe this link will be useful for you http://archives.postgresql.org/pgsql-patches/2007-05/msg00421.php Regards Pavel Stehule > > Did you mention that the 8.5 code has such a functionality? i would like to > download the code and play with it a bit, any pointers what i need to do to > get the XML? > > regards > Matt > > >> >> Andres >> > > > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers