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 6BBEE5E46C8 for ; Thu, 12 Aug 2004 19:52:44 -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 82974-03 for ; Thu, 12 Aug 2004 22:52:41 +0000 (GMT) Received: from smtp3.adl2.internode.on.net (smtp3.adl2.internode.on.net [203.16.214.203]) by svr1.postgresql.org (Postfix) with ESMTP id 24BE25E46CA for ; Thu, 12 Aug 2004 19:52:38 -0300 (ADT) Received: from [192.168.0.114] (ppp226-68.lns1.bne1.internode.on.net [203.122.226.68]) by smtp3.adl2.internode.on.net (8.12.9/8.12.9) with ESMTP id i7CMqdHY041260 for ; Fri, 13 Aug 2004 08:22:40 +0930 (CST) Message-ID: <411BF429.1090106@wildcash.com> Date: Fri, 13 Aug 2004 08:50:17 +1000 From: Rudi Starcevic Reply-To: tech@wildcash.com Organization: Internet Media Productions User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7) Gecko/20040616 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: [GENERAL] How to know which queries are to be optimised? References: <4110CFE7.9000202@relevanttraffic.se> <20040811162701.GA9992@wolff.to> <411B4878.4090804@relevanttraffic.se> <411B5184.6090106@archonet.com> In-Reply-To: <411B5184.6090106@archonet.com> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/195 X-Sequence-Number: 7831 Hi, >> But is there a tool that could compile a summary out of the log? The >> log grows awefully big after a short time. There's also pg_analyzer to check out. http://www.samse.fr/GPL/pg_analyzer/ Some of it's features are: written in Perl and produces HTML output. > You might want to look at the "Practical Query Analyser" - haven't used > it myself yet, but it seems a sensible idea. > > http://pqa.projects.postgresql.org/ Cheers, Rudi.