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(at)nextbus(dot)com
:::::::::::::::::::::::::::::::::
: elein(at)nextbus(dot)com :
: AND NOT OR :
:::::::::::::::::::::::::::::::::