explain analyzing a query inside an sql stored procedure

[Havasvölgyi Ottó <h.otto@xxxxxxxxxxx>]

Hi,

Is there any easy way to explain analyze a query, which is inside an sql 
stored procedure? I could of course copy the query out of the procedure, and 
explain analyze it but this is a slower process. I would do this with a lot 
of procedures, that's why it should be fast.

create function myquery() returns setof record as $$
   select * from mytable; --this is a set returning query
$$ language sql;

explain analyze select * from myquery();

For me this shows function scan, and not the plan of the query itself.

Best Regards,
Otto



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly