How to create/initialize/access an execution plan

From: oozmen(at)cs(dot)uwaterloo(dot)ca
To: pgsql-hackers(at)postgresql(dot)org
Subject: How to create/initialize/access an execution plan
Date: 2004-11-08 18:48:55
Message-ID: 1099939735.418fbf9748de1@www.nexusmail.uwaterloo.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> Hi all,
>
> I need a help and an advice on playing around execution plans. I need a
> direct
> access to a 'plan structure' and change some fields. Even one step more, I
> need to create an execution plan directly w/o issuing an SQL statement (i.e.
>
> skipping parser and optimizer phases) and initialize (fill in the fields)
> it.
>
> I searched a lot to find a suitable documentation and example set, but I
> couldn't find any. If you give some advices on how to create a plan
> node/structure (directly w/o an sql statement or query tree assuming
> that I have my own plan in my mind) and how to play around it (change
> fields), I would really appreciate it.
>
> Thanks in advance,
>
> PS: I tried to access fields of a plan returned by SPI_prepare(), but I
> couldn't manage it either.
>
>
> ----------------------------------------
> This mail sent through www.mywaterloo.ca
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

----------------------------------------
This mail sent through www.mywaterloo.ca

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2004-11-08 19:56:55 ExclusiveLock
Previous Message Tom Lane 2004-11-08 18:07:34 Re: View pg_stat_activity slow to get up to date