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