Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: profiling PL/pgSQL?
- From: Richard Huxton <dev(at)archonet(dot)com>
- To: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: profiling PL/pgSQL?
- Date: Fri, 03 Nov 2006 12:07:58 +0000
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
- Follow-Ups:
- Re: profiling PL/pgSQL?
- From: korryd
- Re: profiling PL/pgSQL?
- From: Jonah H. Harris
- Re: profiling PL/pgSQL?
- References:
- profiling PL/pgSQL?
- From: Drew Wilson
- Re: profiling PL/pgSQL?
- From: A. Kretschmer
- profiling PL/pgSQL?
- Prev by Date: Re: profiling PL/pgSQL?
- Next by Date: Context switch storm
- Previous by thread: Re: profiling PL/pgSQL?
- Next by thread: Re: profiling PL/pgSQL?
- Indexes: