Request a Demo
Home   >   mailing lists

Re: Convert query plan to sql query - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: Convert query plan to sql query
Date
Msg-id CAFjFpRczRiBoLsqqXUvsV2t0pDFCK5zhwRVhgA9t+RCT5DA+xw@mail.gmail.com
Whole thread
In response to Convert query plan to sql query  (mariem <mariem.benfadhel@gmail.com>)
Responses Re: Convert query plan to sql query
List pgsql-hackers
Tree view
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.benfadhel@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

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: WAL replay bugs
Next
From: David Fetter
Date:
Subject: Re: Let's drop two obsolete features which are bear-traps for novices