X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 88FC05337C for ; Mon, 2 May 2005 08:57:07 -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 84109-02 for ; Mon, 2 May 2005 11:56:57 +0000 (GMT) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr1.postgresql.org (Postfix) with ESMTP id 281A153318 for ; Mon, 2 May 2005 08:56:56 -0300 (ADT) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1DSZRK-0003co-CB for pgsql-admin@postgresql.org; Mon, 02 May 2005 13:50:18 +0200 Received: from port-212-202-189-224.dynamic.qsc.de ([212.202.189.224]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 02 May 2005 13:50:18 +0200 Received: from holger by port-212-202-189-224.dynamic.qsc.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 02 May 2005 13:50:18 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Holger Hoffstaette" Subject: Re: measuring most-expensive queries Date: Mon, 02 May 2005 13:36:56 +0200 Organization: The Tyler Durden Rehab Clinic Lines: 11 Message-ID: References: <20050502031830.GC24546@nibiru.borg.metux.de> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: port-212-202-189-224.dynamic.qsc.de User-Agent: Pan/0.13.91 (Before we let euphoria convince us we are free) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/5 X-Sequence-Number: 17434 On Mon, 02 May 2005 05:18:30 +0200, Enrico Weigelt wrote: > I'd like to find out which queries are most expensive (taking very long or > producing high load) in a running system, to see what requires further > optimization. (the application is quite large and some more folks > involved, so I cant check evrything manually). http://pqa.projects.postgresql.org/ -h