Re: Get execution plan of dynamic query

"=?KOI8-R?Q?=E1=CC=C5=CB=D3=C5=CA =FB.?=" <savbr(at)rin(dot)ru> writes:
> How to get results of EXPLAIN of dynamic query maked up in PL/PGSQL function?

Pretend that it's a prepared statement.

For example, if your plpgsql function has

declare x int;
y int;
begin
...
select f1 into x from tab1 where f2 = y;

then this will show the same plan as plpgsql will be using:

prepare foo(int) as select f1 from tab1 where f2 = $1;

explain analyze execute foo(42);

regards, tom lane