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 A2F99534E2 for ; Tue, 12 Apr 2005 11:18:33 -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 07785-01 for ; Tue, 12 Apr 2005 14:18:28 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196]) by svr1.postgresql.org (Postfix) with ESMTP id 8BDC5534C8 for ; Tue, 12 Apr 2005 11:18:27 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so1903182wri for ; Tue, 12 Apr 2005 07:18:32 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=oew6XsOMBEC3UFY5CaNKk3sPVDG79auczjaryuaiEgktcz+2dKQMVwYOSHt8/aUizoEDEEwxg5aeZUfL2Oi4ZvKUCniqBIhiZgVOzavjc4uKSg5+3r3qmB1xmREs54CB5GjydA0SLd3MbVOeiqdscQZv2UdJHOBi1UBZYljx25Y= Received: by 10.54.10.67 with SMTP id 67mr817443wrj; Tue, 12 Apr 2005 07:18:32 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Tue, 12 Apr 2005 07:18:31 -0700 (PDT) Message-ID: <33c6269f05041207182473d08b@mail.gmail.com> Date: Tue, 12 Apr 2005 10:18:31 -0400 From: Alex Turner Reply-To: Alex Turner To: Tom Lane Subject: Re: profiling postgresql queries? Cc: hubert.lubaczewski@eo.pl, pgsql-performance@postgresql.org In-Reply-To: <15425.1113315053@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <20050412104643.GB11445@eo.pl> <15425.1113315053@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.263 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/227 X-Sequence-Number: 11624 Speaking of triggers... Is there any plan to speed up plpgsql tiggers? Fairly simple crosstable insert triggers seem to slow my inserts to a crawl. Is the best thing just to write triggers in C (I really don't want to put this stuff in the application logic because it really doesn't belong there). Alex Turner netEconomist On Apr 12, 2005 10:10 AM, Tom Lane wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >