X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E19BD6D71 for ; Tue, 11 Oct 2005 06:58:55 -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 90886-03 for ; Tue, 11 Oct 2005 09:58:51 +0000 (GMT) Received: from kraid.nerim.net (smtp-102-tuesday.nerim.net [62.4.16.102]) by svr1.postgresql.org (Postfix) with ESMTP id 68525D6E97 for ; Tue, 11 Oct 2005 06:58:51 -0300 (ADT) Received: from jobmare.clarisys.lan (claridsl512.net1.nerim.net [213.41.148.137]) by kraid.nerim.net (Postfix) with ESMTP id B01174103D; Tue, 11 Oct 2005 11:58:52 +0200 (CEST) Received: from day by jobmare.clarisys.lan with local (Exim 4.52) id 1EPGuv-0003ko-Oo; Tue, 11 Oct 2005 11:59:29 +0200 Date: Tue, 11 Oct 2005 11:59:29 +0200 From: David Pradier To: pgsql-admin@postgresql.org Subject: A tool to extract the problematic points of the postgresl log. Message-ID: <20051011095929.GD12162@clarisys.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[AWL=-0.000, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/120 X-Sequence-Number: 19192 Hi everybody, i'd like to know if my database (settings, indexes, materialized views, etc) is correctly tuned. To do this, i think the best way is to watch the queries actually processed and the time needed. The postgres log is the right way to do this, i think. But well, it's a bit dense. Nothing i can't go through, but would you know a better tool than grep to parse the file and extract the problematic points ? As it might be a common problem, maybe somebody as already written a generic tool to do this ? Thanks in advance, David -- David Pradier -- Directeur Technique de Clarisys Informatique -- Chef de projet logiciels libres / open-source