Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6AE489FB1D6 for ; Fri, 3 Nov 2006 18:21:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 02285-05 for ; Fri, 3 Nov 2006 18:21:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 594BE9FB20F for ; Fri, 3 Nov 2006 18:21:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp-out.google.com (smtp-out.google.com [216.239.33.17]) by svr4.postgresql.org (Postfix) with ESMTP id A75025AF9ED for ; Fri, 3 Nov 2006 22:21:30 +0000 (GMT) Received: from spaceape13.eur.corp.google.com (spaceape13.eur.corp.google.com [172.28.16.147]) by smtp-out.google.com with ESMTP id kA3MLSph002286 for ; Fri, 3 Nov 2006 22:21:28 GMT DomainKey-Signature: a=rsa-sha1; s=beta; d=google.com; c=nofws; q=dns; h=received:message-id:date:from:to:subject:mime-version:content-type; b=SVJrs6/Fc7gYnKNxuiH47f4EzLvPoyDjUO3464U2U/dWUGEToYqr+us7+DEVfWM6Q WMKTjc5oQRwDbZtA5ZSEQ== Received: from nf-out-0910.google.com (nfed4.prod.google.com [10.48.156.4]) by spaceape13.eur.corp.google.com with ESMTP id kA3MLN2o017582 for ; Fri, 3 Nov 2006 22:21:23 GMT Received: by nf-out-0910.google.com with SMTP id d4so553207nfe for ; Fri, 03 Nov 2006 14:21:23 -0800 (PST) Received: by 10.78.203.13 with SMTP id a13mr3536915hug.1162592483185; Fri, 03 Nov 2006 14:21:23 -0800 (PST) Received: by 10.78.140.8 with HTTP; Fri, 3 Nov 2006 14:21:23 -0800 (PST) Message-ID: <3ddac38d0611031421s3c3f48ffoeea9a9bd1f86a71c@mail.gmail.com> Date: Fri, 3 Nov 2006 14:21:23 -0800 From: "Dylan Lorimer" To: pgsql-sql@postgresql.org Subject: Long SQL Update Question MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23992_27348140.1162592483108" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/46 X-Sequence-Number: 26698 ------=_Part_23992_27348140.1162592483108 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline So I kicked off a SQL transaction that has been running for 30+ minutes. Is there any way to monitor it to know if it has possibly hanged or not? To be fair, it is an update on 4+ million rows, so I expect it to run for a bit. But any stats or metrics I can get would be helpful. Cheers, dylan ------=_Part_23992_27348140.1162592483108 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline So I kicked off a SQL transaction that has been running for 30+ minutes. Is there any way to monitor it to know if it has possibly hanged or not? To be fair, it is an update on 4+ million rows, so I expect it to run for a bit. But any stats or metrics I can get would be helpful.
Cheers,
dylan
------=_Part_23992_27348140.1162592483108--