X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 03D7AD1B46D for ; Tue, 25 Nov 2003 22:27:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43363-09 for ; Tue, 25 Nov 2003 18:27:07 -0400 (AST) Received: from mta1.sucs.soton.ac.uk (mta1.sucs.soton.ac.uk [152.78.128.140]) by svr1.postgresql.org (Postfix) with ESMTP id 155BCD1B430 for ; Tue, 25 Nov 2003 18:27:05 -0400 (AST) Received: from russell (ip-002.area-012.loc-245.halls.soton.ac.uk [10.245.12.2]) (authenticated bits=0) by mta1.sucs.soton.ac.uk (8.12.10/8.12.10) with ESMTP id hAPMQi3A008276; Tue, 25 Nov 2003 22:26:44 GMT From: "Russell Garrett" To: "Torsten Schulz" , Subject: Re: [Fwd: Re: Optimize] Date: Tue, 25 Nov 2003 22:27:34 -0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <3FC3D252.1000204@be-a-part.de> X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-ISS-MailScanner: Believed to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/257 X-Sequence-Number: 4817 >>> with this query I see how much queries running, but the field >>> current_query are free, so i can't see which queries are very slow. >> >> >> You must perform that query with permission of super_user. >> > I've made it in root-account with psql -U postgres - but i can't see > the query You must have these lines in your postgresql.conf for the query stats to be collected: stats_start_collector = true stats_command_string = true -------------------------------------------------------------------- Russ Garrett russ@last.fm http://last.fm