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
