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 D24F553875 for ; Fri, 25 Mar 2005 15:12:11 +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 95341-09 for ; Fri, 25 Mar 2005 15:12:06 +0000 (GMT) Received: from rgmail.regenstrief.org (rgmail.regenstrief.org [134.68.31.125]) by svr1.postgresql.org (Postfix) with ESMTP id 7A9C7537A4 for ; Fri, 25 Mar 2005 15:12:03 +0000 (GMT) Received: from [172.31.0.53] ([172.31.0.53]) by rgmail.regenstrief.org (8.12.8/8.12.8) with ESMTP id j2PFC5cX017753; Fri, 25 Mar 2005 10:12:06 -0500 Subject: Script for getting a table of reponse-time breakdown From: Jack Xue To: jxue@regenstrief.org Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Organization: Message-Id: <1111763525.18036.15.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-4) Date: 25 Mar 2005 10:12:05 -0500 Content-Transfer-Encoding: 7bit X-Antivirus: Scanned by Vexira Antivirus 1.0.5 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: 200503/543 X-Sequence-Number: 11248 Hi, I am thinking about how to continuously monitor the performance of a PostgreSQL 8 database. I am interested in two things: (1) the growth of tables with TOAST and indexes; and (2) the respond time breakdown for a query. In Chapters 23 and 24 of the big manual, I found enough materials to teach me how to do the 1st job. But I have difficulty with the 2nd one. I found some script for Oracle (http://www.ixora.com.au/scripts/waits.htm). Do we have something that can do the same job for PostgreSQL 8? Thanks. -Jack