[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

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 them, or

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 flags to