Re: profiling PL/pgSQL?

A. Kretschmer wrote:
> am  Fri, dem 03.11.2006, um  3:12:14 -0800 mailte Drew Wilson folgendes:
>> I have 700 lines of non-performant pgSQL code that I'd like to
>> profile to see what's going on.
>>
>> What's the best way to profile stored procedures?
>
> RAISE NOTICE, you can raise the aktual time within a transaction with
> timeofday()

Of course you only have very small values of "best" available with
plpgsql debugging.

There's a GUI debugger from EnterpriseDB I believe, but I've no idea how
good it is. Any users/company bods care to let us know?

--
   Richard Huxton
   Archonet Ltd