explain and explain analyze with functions
От
elein
Тема
explain and explain analyze with functions
Дата
Msg-id
5.1.0.14.0.20020501114814.01c5e6c8@office.nextbus.com
Ответ на
Re: R: I: Migrating a very large db (Tom Lane)
Список
Дерево обсуждения
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 по дате отправления