X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 72283D1B49E for ; Tue, 17 Feb 2004 13:35:30 +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 40760-10 for ; Tue, 17 Feb 2004 09:35:29 -0400 (AST) Received: from fep03-mail.bloor.is.net.cable.rogers.com (fep03-mail.bloor.is.net.cable.rogers.com [66.185.86.73]) by svr1.postgresql.org (Postfix) with ESMTP id F2437D1B484 for ; Tue, 17 Feb 2004 09:35:24 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep03-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040217133528.FJLV189272.fep03-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Tue, 17 Feb 2004 08:35:28 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 6E1803F3F; Tue, 17 Feb 2004 08:35:27 -0500 (EST) Date: Tue, 17 Feb 2004 08:35:27 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Trace for postgreSQL Message-ID: <20040217133527.GF6363@phlogiston.dyndns.org> Mail-Followup-To: pgsql-sql@postgresql.org References: <4F6ABED0-5BC1-11D8-B55E-0003938366A4@ntlworld.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4F6ABED0-5BC1-11D8-B55E-0003938366A4@ntlworld.com> User-Agent: Mutt/1.5.4i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep03-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Tue, 17 Feb 2004 08:35:28 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/207 X-Sequence-Number: 16897 On Tue, Feb 10, 2004 at 12:04:42PM +0000, beyaNet Consultancy wrote: > Hi, > can anyone tell me whether there is a trace facility (application) > available for postgreSQL version 7.4.1 which will enable me to see all > incoming requests being made to the database (ala SQL Server)? Sure. Alter your configuration to echo queries, and then watch your log file. Alternatively, you can enable the command string statistics function, and then you get the queries in near to real time in pg_stat_activity. A -- Andrew Sullivan | ajs@crankycanuck.ca The plural of anecdote is not data. --Roger Brinner