> > How much effort would it be to add EXPLAIN/EXPLAIN ANALYSE capability to > > pl/pgsql functions? > > > > what I mean, is either a special mode, where "SELECT my_plpgsql_func()" > > would print all query plans instead or in addition to executing them, or > > some way for EXPLAIN to pass some flags to functions so that they can > > "do the right thing". > > I agree this is an important thing to have.
This is a feature I would like to add to the elusive PL/pgSQL debugger/tracer/profiler. -- Korry