Re: EXPLAIN/EXPLAIN ANALYSE for pl/pgsql functions - Mailing list pgsql-hackers

From
Subject Re: EXPLAIN/EXPLAIN ANALYSE for pl/pgsql functions
Date
Msg-id 1177358724.7637.330.camel@sakai.localdomain
Whole thread Raw
In response to Re: EXPLAIN/EXPLAIN ANALYSE for pl/pgsql functions  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
<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  

pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: RESET command seems pretty disjointed now
Next
From: Josh Berkus
Date:
Subject: Wild idea: 9.0?