Long SQL Update Question

From: "Dylan Lorimer" <edylan(at)google(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Long SQL Update Question
Date: 2006-11-03 22:21:23
Message-ID: 3ddac38d0611031421s3c3f48ffoeea9a9bd1f86a71c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Anonymous 2006-11-03 23:52:20 Re: Function to reset sequence.....
Previous Message imad 2006-11-03 19:48:27 Re: Index + View Question