From: | Rajmohan C <csrajmohan(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | how to find the order of joins from Explain command XML plan output in PostgreSQL9.3.4 |
Date: | 2014-07-06 18:31:48 |
Message-ID: | CAHaqV0h_SM0Nwo=Qsg7F7HaLWO+FM5HEq2cz5rOXgqHbQyMYtg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-novice |
"EXPLAIN (format XML) <query>" command in PostgreSQL9.3.4 gives the plan
chosen by the optimizer in XML format. In my program, I have to extract
certain data about optimizer plan from this XML output.
I am using *LibXML2* library for parsing the XML. I had successfully
extracted information about which relations are involved and what joins are
used by parsing the XML.
But I am *unable to extract the* *order of joining the relations from
the XML output*. I conceptually understood that the level order traversal
of binary tree representation of the XML plan will give correct ordering of
joins applied.
But I could not figure out how do I get that from the XML? Does
libXML2 support anything of this sort? If not how should I proceed to
tackle this?
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2014-07-06 19:02:21 | Re: Spinlocks and compiler/memory barriers |
Previous Message | Sawada Masahiko | 2014-07-06 17:18:38 | Re: add line number as prompt option to psql |
From | Date | Subject | |
---|---|---|---|
Next Message | Rajmohan C | 2014-07-06 19:15:15 | Estimating selectivity of predicates involving string pattern matching |
Previous Message | Albe Laurenz | 2014-07-04 11:33:15 | Re: external table |