Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D3B049FB322 for ; Fri, 3 Nov 2006 11:27:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 61052-04 for ; Fri, 3 Nov 2006 15:27:30 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 516239FA158 for ; Fri, 3 Nov 2006 11:27:30 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so393366ugf for ; Fri, 03 Nov 2006 07:27:29 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ghLE99uPhIcshyhIOyPBzidf+MULxm+fRIU8ydigHx4fg8Yjcqozhdjmh2iL04BZUm9eCdG+hKb8vWGSrcygsBQl+1SKpjgK8OCxj9ZhkcEUil2RWQjxzF5ejImWtBdFxDmsXxP8XS0nYEWEcrRlqf7OEFhB67XvFy/lGoYSRGM= Received: by 10.78.157.8 with SMTP id f8mr2978624hue.1162567648707; Fri, 03 Nov 2006 07:27:28 -0800 (PST) Received: by 10.78.165.7 with HTTP; Fri, 3 Nov 2006 07:27:28 -0800 (PST) Message-ID: <36e682920611030727s42fbc698j7dcca6bbb0ae2570@mail.gmail.com> Date: Fri, 3 Nov 2006 10:27:28 -0500 From: "Jonah H. Harris" To: "Richard Huxton" Subject: Re: profiling PL/pgSQL? Cc: "A. Kretschmer" , pgsql-performance@postgresql.org In-Reply-To: <454B311E.9010001@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20061103112137.GD15480@a-kretschmer.de> <454B311E.9010001@archonet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/50 X-Sequence-Number: 21820 On 11/3/06, Richard Huxton wrote: > 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? If you visit: http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/edb-debugger/#dirlist We have both a PL/pgSQL profiler and tracer available. -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 2nd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/