Re: How to see detailed plan of a funciton

Поиск
Список
Период
Сортировка
От Andreas Seltenreich
Тема Re: How to see detailed plan of a funciton
Дата
Msg-id 87iru1hv3m.fsf@gate450.dyndns.org
обсуждение исходный текст
Ответ на How to see detailed plan of a funciton  ("Obe, Regina DND\\MIS" <robe.dnd@cityofboston.gov>)
Список pgsql-novice
Дерево обсуждения 
Regina Obe writes:

> I have a pgsql function that returns a set of records and I'm trying to
> optimize it.
>
> Needless to say it goes thru several selects and appends to the final
> result.  I was wondering how I can see the query plan without having to
> write things out piece meal.

You could enable logging of plans and timings using some GUC
variables:

<http://www.postgresql.org/docs/8.1/static/runtime-config-statistics.html>
<http://www.postgresql.org/docs/8.1/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT>

The output is different from explain's, but most of the information
should be there.

regards,
Andreas

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

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: Pl/pgsql import
Следующее
От: "Luis Silva"
Дата:
Сообщение: trigger function with arguments from a sql command