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 <tgl@sss.pgh.pa.us>) |
Ответы |
Re: explain and explain analyze with functions
|
Список | pgsql-general |
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 по дате отправления: