CODEWITHSUNDEEP
javapostgresqljdbc
JWH_
JWH_

Reputation: 267

Converting Postgres Query Plan into xml and store in file using Eclipse JDBC

As per title, I'm current using JDBC on eclipse to connect to my PostgreSQL.

I have been running EXPLAIN ANALYZE statements to retrieve query plans from postgres itself. However, is it possible to store these query plan in a structure that resemble a tree? e.g main branch and sub branch etc. I read somewhere that it is a good idea to store it into xml document first and manipulate it from there.

Is there an API in Java for me to achieve this? Thanks!

Upvotes: 0

Views: 202

Answers (1)

Vao Tsun
Vao Tsun

Reputation: 51609

try using format xml eg 

t=# explain (analyze, format xml) select * from pg_database join pg_class on true;
                           QUERY PLAN
----------------------------------------------------------------
 <explain xmlns="http://www.postgresql.org/2009/explain">      +
   <Query>                                                     +
     <Plan>                                                    +
       <Node-Type>Nested Loop</Node-Type>                      +
       <Join-Type>Inner</Join-Type>                            +
       <Startup-Cost>0.00</Startup-Cost>                       +
       <Total-Cost>23.66</Total-Cost>                          +
       <Plan-Rows>722</Plan-Rows>                              +
       <Plan-Width>457</Plan-Width>                            +
       <Actual-Startup-Time>0.026</Actual-Startup-Time>        +
       <Actual-Total-Time>3.275</Actual-Total-Time>            +
       <Actual-Rows>5236</Actual-Rows>                         +
       <Actual-Loops>1</Actual-Loops>                          +
       <Plans>                                                 +
         <Plan>                                                +
           <Node-Type>Seq Scan</Node-Type>                     +
           <Parent-Relationship>Outer</Parent-Relationship>    +
     ...and so on

Upvotes: 1

Related Questions