May be you want to check how it's done in Postgres-XC. Postgres-XC works on plans being created by PostgreSQL and "reverse-engineers" queries (for parts of the plans which are "shippable".) The notions of "shippability" may not be of interest to you, but the code to "reverse-engineer" most of the plan nodes is there in Postgres-XC.
On Wed, Nov 5, 2014 at 8:47 AM, mariem <mariem.benfad...@gmail.com> wrote: > Hello, > > I would like to transform the query plan (output of the planner, > debug_print_plan) into an sql query. > I know that there are pieces of the query plan that might be machine > dependent (in var for example). > So I wanted to have your suggestions or thoughts before I put efforts into > it. > > Basically, if I have: > query1 -> parser -> rewriter -> planner > the process would be : > query_plan -> planner -> parser -> query2 > > query1 and query2 are not necessarily the same due to rewrite, stats.. > > Thanks! > > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/Convert-query-plan-to-sql-query-tp5825727.html > Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company
