explain analyzing a query inside an sql stored procedure

Поиск
Список
Период
Сортировка
От Havasvölgyi Ottó
Тема explain analyzing a query inside an sql stored procedure
Дата
Msg-id 005f01c598e4$02db2950$8200a8c0@OTTO
обсуждение исходный текст
Ответ на dbf to pgsql  ("Piotr" <hokah@wp.pl>)
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: "Alejandro D. Burne"
Дата:
Сообщение: pgsql-odbc list problem
Следующее
От: Oluwatope Akinniyi
Дата:
Сообщение: Trigger Variables