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 9E602538B2 for ; Fri, 25 Mar 2005 18:07:44 +0000 (GMT) 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 45643-04 for ; Fri, 25 Mar 2005 18:07:39 +0000 (GMT) Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by svr1.postgresql.org (Postfix) with ESMTP id 5913A538B8 for ; Fri, 25 Mar 2005 18:07:38 +0000 (GMT) X-EthosMedia-Virus-Scanned: no infections found Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 7167162; Fri, 25 Mar 2005 10:09:32 -0800 From: Josh Berkus Organization: Aglio Database Solutions To: Jack Xue Subject: Re: Script for getting a table of reponse-time breakdown Date: Fri, 25 Mar 2005 10:07:13 -0800 User-Agent: KMail/1.6.2 Cc: pgsql-performance@postgresql.org References: <200503250940.59062.josh@agliodbs.com> <1111773606.18036.19.camel@localhost.localdomain> In-Reply-To: <1111773606.18036.19.camel@localhost.localdomain> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <200503251007.13520.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.011 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/551 X-Sequence-Number: 11256 Jack, > This script can be used to focus tuning attention on the most important > issues. It reports a breakdown of total foreground response time into > four major categories: CPU usage, disk I/O, resource waits, and routine > latencies. These categories are broken down further into sub-categories, > and the component wait events are shown. This would be very nice. And very, very hard to build. No, we don't have anything similar. You can, of course, use profiling tools. -- Josh Berkus Aglio Database Solutions San Francisco