Convert query plan to sql query

From: mariem <mariem(dot)benfadhel(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Convert query plan to sql query
Date: 2014-11-05 03:17:02
Message-ID: 1415157422962-5825727.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2014-11-05 03:31:37 Re: Add CREATE support to event triggers
Previous Message Tom Lane 2014-11-05 02:41:37 Re: Preferring MemSet or memset?