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