Re: [HACKERS] EXPLAIN/EXPLAIN ANALYSE for pl/pgsql functions

2007-04-23 Thread korryd
> > 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 fl

Re: [HACKERS] EXPLAIN/EXPLAIN ANALYSE for pl/pgsql functions

2007-04-23 Thread Simon Riggs
On Mon, 2007-04-23 at 11:01 +0300, Hannu Krosing wrote: > 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 the

[HACKERS] EXPLAIN/EXPLAIN ANALYSE for pl/pgsql functions

2007-04-23 Thread Hannu Krosing
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