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