Skip site navigation (1) Skip section navigation (2)

Re: EXPLAIN/EXPLAIN ANALYSE for pl/pgsql functions

From: <korryd(at)enterprisedb(dot)com>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: "Hannu Krosing" <hannu(at)skype(dot)net>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: EXPLAIN/EXPLAIN ANALYSE for pl/pgsql functions
Date: 2007-04-23 20:05:24
Message-ID: 1177358724.7637.330.camel@sakai.localdomain (view raw or flat)
Thread:
Lists: pgsql-hackers
> > 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

In response to

pgsql-hackers by date

Next:From: August ZajoncDate: 2007-04-23 20:16:14
Subject: Re: Wild idea: 9.0?
Previous:From: Neil ConwayDate: 2007-04-23 20:04:07
Subject: Re: RESET command seems pretty disjointed now

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group