<div dir="ltr">"EXPLAIN (format XML) " command in PostgreSQL9.3.4 gives the plan chosen by the optimizer in XML format.
Inmy program, I have to extract certain data about optimizer plan from this XML output. I am using
<strong>LibXML2</strong>library for parsing the XML. I had successfully extracted information about which relations are
involvedand what joins are used by parsing the XML. But I am <strong>unable to extract the</strong> <strong>order of
joiningthe relations from the XML output</strong>. I conceptually understood that the reverse level order traversal of
binarytree representation of the XML plan will give correct ordering of joins applied. But I could not figure out how
doI get that from the XML? Does libXML2 support anything of this sort? If not how should I proceed to tackle this?<br
/></div>