X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B27119DD2E7 for ; Tue, 21 Mar 2006 06:55:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38038-07 for ; Tue, 21 Mar 2006 06:55:32 -0400 (AST) X-Greylist: delayed 02:14:45.38211 by SQLgrey- Received: from mail.rp-online.de (mail.rp-online.de [149.221.1.199]) by postgresql.org (Postfix) with ESMTP id EE5119DCE58 for ; Tue, 21 Mar 2006 06:55:27 -0400 (AST) Received: from idefix.d.rp-online.de (idefix.d.rp-online.de [149.221.100.194]) by mail.rp-online.de (Postfix) with ESMTP id 25E741FB64 for ; Tue, 21 Mar 2006 11:55:30 +0100 (CET) From: Thomas Pundt Reply-To: Thomas Pundt Organization: RP Online Verlagsgesellschaft mbH To: pgsql-performance@postgresql.org Subject: Re: Query Feromance Date: Tue, 21 Mar 2006 11:58:43 +0100 User-Agent: KMail/1.9.1 References: <441EC34D.1000901@bluestudio.it> <200603210943.57454.mlists@rp-online.de> <441FCDD2.8010905@bluestudio.it> In-Reply-To: <441FCDD2.8010905@bluestudio.it> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200603211158.43887.mlists@rp-online.de> X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.3/RELEASE, bases: 21032006 #172113, status: clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/377 X-Sequence-Number: 17814 Hi, On Tuesday 21 March 2006 10:56, Marco Furetto wrote: | ok, I enable query duration logging in postgresql.conf. | | where is the instruments for analyze the statistics queries executing on | my =A0db? | | Eg.: Number of query executing, total time for executing a single query, | etc... I don't know if there are tools or settings available for PostgreSQL that do such number-of-query-accounting; but you can set the=20 log_min_duration_statement value to 0 to log all statements with their duration. See http://www.postgresql.org/docs/8.1/interactive/runtime-config.html for more options on runtime configuration, especially 17.7 and 17.8 might be of interest for you. Ciao, Thomas =2D-=20 Thomas Pundt ---- http://rp-online.de/ ----