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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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