explain and explain analyze with functions - Mailing list pgsql-general

From elein
Subject explain and explain analyze with functions
Date
Msg-id 5.1.0.14.0.20020501114814.01c5e6c8@office.nextbus.com
Whole thread Raw
In response to Re: R: I: Migrating a very large db  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: explain and explain analyze with functions
List 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 by date:

Previous
From: dorian dorian
Date:
Subject: Re: icps, shmmax and shmall - Shared Memory tuning
Next
From: Mike Mascari
Date:
Subject: Re: rowcount