X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D13249FA5BA for ; Thu, 15 Jun 2006 09:43:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 92926-07 for ; Thu, 15 Jun 2006 09:43:25 -0300 (ADT) X-Greylist: delayed 00:26:50.033067 by SQLgrey- Received: from calypso.bi.lt (calypso.bi.lt [213.226.153.10]) by postgresql.org (Postfix) with ESMTP id EAD309F9CAA for ; Thu, 15 Jun 2006 09:43:25 -0300 (ADT) Received: from calypso.bi.lt (localhost [127.0.0.1]) by calypso.bi.lt (Postfix) with ESMTP id 355EF480B84 for ; Thu, 15 Jun 2006 15:16:33 +0300 (EEST) Received: from B027543 (inet.bee.lt [213.226.131.30]) by calypso.bi.lt (Postfix) with SMTP id 1DF63480A74 for ; Thu, 15 Jun 2006 15:16:33 +0300 (EEST) Message-ID: <016401c69075$8a35e8c0$f20214ac@bite.lt> From: "Mindaugas" To: Subject: How to analyze function performance Date: Thu, 15 Jun 2006 15:16:32 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1257" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/300 X-Sequence-Number: 19657 Hello, Is it possible to somehow analyze function performance? E.g. we are using function cleanup() which takes obviously too much time to execute but I have problems trying to figure what is slowing things down. When I explain analyze function lines step by step it show quite acceptable performance. PostgreSQL 8.0 is running on two dual core Opterons. Thanks, Mindaugas