Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 158789FB312 for ; Fri, 3 Nov 2006 07:12:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 95883-09 for ; Fri, 3 Nov 2006 07:12:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id 7DE719FB313 for ; Fri, 3 Nov 2006 07:12:24 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x37so1469832nfc for ; Fri, 03 Nov 2006 03:12:22 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:mime-version:content-transfer-encoding:message-id:content-type:to:from:subject:date:x-mailer; b=tOwJnBgtK6rLBk86vyDSZRswEDiJYBTZt5oKDTPuFCTo8HFvkOVM9lUrQZNBuLO9AJoiJ/qcWKSm1/lHJWpq4qr6hlbJPHLfpW+NEsfR0HiOUafL8UTf6GOvCRLAcPODGGSkLpbsaBBJXO7M5uvFjIstJY9Vzd5EWjyzsUhChfc= Received: by 10.78.128.15 with SMTP id a15mr2556215hud.1162552342012; Fri, 03 Nov 2006 03:12:22 -0800 (PST) Received: from ?192.168.1.100? ( [66.166.239.210]) by mx.google.com with ESMTP id 30sm899272hub.2006.11.03.03.12.19; Fri, 03 Nov 2006 03:12:19 -0800 (PST) Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-performance@postgresql.org From: Drew Wilson Subject: profiling PL/pgSQL? Date: Fri, 3 Nov 2006 03:12:14 -0800 X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/35 X-Sequence-Number: 21805 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? Thanks, Drew