X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3DDA0534FC for ; Tue, 12 Apr 2005 11:11:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02681-08 for ; Tue, 12 Apr 2005 14:11:11 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 66DA3534E2 for ; Tue, 12 Apr 2005 11:11:10 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3CEArdT015426; Tue, 12 Apr 2005 10:10:53 -0400 (EDT) To: hubert.lubaczewski@eo.pl Cc: pgsql-performance@postgresql.org Subject: Re: profiling postgresql queries? In-reply-to: <20050412104643.GB11445@eo.pl> References: <20050412104643.GB11445@eo.pl> Comments: In-reply-to hubert lubaczewski message dated "Tue, 12 Apr 2005 12:46:43 +0200" Date: Tue, 12 Apr 2005 10:10:53 -0400 Message-ID: <15425.1113315053@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/225 X-Sequence-Number: 11622 hubert lubaczewski writes: > and it made me wonder - is there a way to tell how much time of backend > was spent on triggers, index updates and so on? In CVS tip, EXPLAIN ANALYZE will break out the time spent in each trigger. This is not in any released version, but if you're desperate you could load up a play server with your data and test. regards, tom lane