Re: SPI functions to work with the Execution Plan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Osmel Barreras Piñera <obarreras(at)estudiantes(dot)uci(dot)cu>
Cc: lista_postgres <pgsql-general(at)postgresql(dot)org>
Subject: Re: SPI functions to work with the Execution Plan
Date: 2012-02-06 05:48:46
Message-ID: 28482.1328507326@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Osmel Barreras =?utf-8?Q?Pi=C3=B1era?= <obarreras(at)estudiantes(dot)uci(dot)cu> writes:
> I need to develop for my diploma thesis an extension that allows me to travel the implementation plan once you pass through the phase of planning and optimization. SPI functions that could be used to obtain and work with the plan?

SPI is not meant to expose anything like that. You could install a
planner_hook though, and look at the plan after calling standard_planner.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2012-02-06 05:56:27 Triggering a function on table overwrite
Previous Message Tom Lane 2012-02-06 05:46:50 Re: sql query bug???