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.
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? |