Re: Tuning queries inside a function

Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> On Fri, Apr 29, 2005 at 12:32:26PM -0500, Mike Nolan wrote:
>> Any ideas on how to tune a user function?

> Maybe you could return a refcursor pointing to the EXPLAIN ANALYZE of
> the query inside the function.

The raw materials exist to do this: if you know which elements of a
query will be replaced by plpgsql variables, you can duplicate the
results via

    PREPARE foo(...) AS ...
    EXPLAIN EXECUTE foo(...)

Certainly there is a lot more that we can and must do about making
it easier to debug and tune plpgsql functions.  But you can fix 'em
with a little determination even now...

            regards, tom lane