explain and explain analyze with functions

Поиск
Список
Период
Сортировка
Искать
От
elein
Тема
explain and explain analyze with functions
Дата
в 15:43:05
Msg-id
5.1.0.14.0.20020501114814.01c5e6c8@office.nextbus.com
Ответ на
Список
Дерево обсуждения
I: Migrating a very large db "Samuele Brignoli" <samuele.brignoli@darpha.com>
Re: I: Migrating a very large db Tom Lane <tgl@sss.pgh.pa.us>
R: I: Migrating a very large db "Samuele Brignoli" <samuele.brignoli@darpha.com>
Re: R: I: Migrating a very large db Tom Lane <tgl@sss.pgh.pa.us>
explain and explain analyze with functions elein <elein@nextbus.com>
Re: explain and explain analyze with functions Tom Lane <tgl@sss.pgh.pa.us>

Explain and explain analyze do not seem to count any
subqueries in functions called.

select la, di, da from mytab where la=fala(di,da);

gets a lower score on both explain and analyze
than the query in fala() does by itself (or select fala()).
The runtime reported in milliseconds is also lower (19 vs 55).
The function fala() is just an sql function.

Is this a bug?  Is this a feature request?  Is there
any way besides doing the arithmetic to get this information?

I understand the function runs in a different context, but
the explain should traverse the execution tree and sum up, no?

elein@nextbus.com




:::::::::::::::::::::::::::::::::
: elein@nextbus.com :
:     AND NOT OR     :
:::::::::::::::::::::::::::::::::

В списке pgsql-general по дате отправления
От: dorian dorian
Дата:
От: Mike Mascari
Дата:
Сообщение: Re: rowcount
FAQ