Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 166DD9FB4E0 for ; Wed, 28 Mar 2007 18:50:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 84098-05 for ; Wed, 28 Mar 2007 18:49:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 4E37C9FB461 for ; Wed, 28 Mar 2007 18:50:01 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1HWh2P-00068m-4X for pgsql-sql@postgresql.org; Wed, 28 Mar 2007 17:54:41 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id A955F4050; Wed, 28 Mar 2007 17:49:54 -0400 (EDT) Date: Wed, 28 Mar 2007 17:49:54 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Track query status Message-ID: <20070328214954.GA17104@phlogiston.dyndns.org> References: <7539aebb0703281359v5b56cc59xf9e80ad4a74e51d7@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7539aebb0703281359v5b56cc59xf9e80ad4a74e51d7@mail.gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/340 X-Sequence-Number: 27978 On Wed, Mar 28, 2007 at 04:59:24PM -0400, Sumeet wrote: > Hi all, > > I have ran a update query on a dataset which has about 48 million records > and the query is already running for the third day....im so tempted to the > kill this query now....is there a way to know if the query is running?? > here is the query i've ran 48 million records is a lot. You oughta see activity with iostat or something. A -- Andrew Sullivan | ajs@crankycanuck.ca When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes