Re: Long SQL Update Question - Mailing list pgsql-sql

From imad
Subject Re: Long SQL Update Question
Date
Msg-id 1f30b80c0611040108n5235c135qe5fff990f1636e76@mail.gmail.com
Whole thread Raw
In response to Long SQL Update Question  ("Dylan Lorimer" <edylan@google.com>)
List pgsql-sql
You can turn on logging ... but your transaction would be even slower
after that.

The following links should give you some pointers:
http://www.postgresql.org/docs/8.1/static/monitoring-stats.html
http://www.postgresql.org/docs/8.1/static/monitoring.html

Also try Nagios monitoring plugins for PostgreSQL. Get it from pgFoundry.

--Imad
www.EnterpriseDB.com


On 11/4/06, Dylan Lorimer <edylan@google.com> wrote:
> 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
>


pgsql-sql by date:

Previous
From: "Dylan Lorimer"
Date:
Subject: Re: Duplicate Fields + Views Questions
Next
From: Mark Simon
Date:
Subject: Create View