Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5F8B52E157F for ; Mon, 19 Nov 2007 10:15:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 72387-09 for ; Mon, 19 Nov 2007 10:15:02 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id D96D52E1374 for ; Mon, 19 Nov 2007 10:15:36 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id lAJEFUqb082872 for ; Mon, 19 Nov 2007 10:15:30 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id lAJDH24S043884 for pgsql-sql@postgresql.org; Mon, 19 Nov 2007 09:17:02 -0400 (AST) (envelope-from news) From: "Sabin Coanda" X-Newsgroups: pgsql.sql Subject: EXPLAIN ANALYZE inside functions Date: Mon, 19 Nov 2007 15:17:08 +0200 Organization: Hub.Org Networking Services Lines: 15 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-RFC2646: Format=Flowed; Original To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/90 X-Sequence-Number: 29618 Hi there, I'd like to rise the performance of a custom function, but I read somewhere I cannot use EXPLAIN ANALYZE to get the execution plan of the code from the function. Do you know a workaround to do this ? I tried to apply EXPLAIN ANALYZE statements inside my procedure hopping I will get some notice messages, but I got nothing :(. TIA, Sabin