pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLong SQL Update Question
2+ messages / 2 participants
[nested] [flat]
* Long SQL Update Question
@ 2006-11-03 22:21 Dylan Lorimer <edylan@google.com>
2006-11-04 09:08 ` Re: Long SQL Update Question imad <immaad@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Dylan Lorimer @ 2006-11-03 22:21 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Long SQL Update Question
2006-11-03 22:21 Long SQL Update Question Dylan Lorimer <edylan@google.com>
@ 2006-11-04 09:08 ` imad <immaad@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: imad @ 2006-11-04 09:08 UTC (permalink / raw)
To: Dylan Lorimer <edylan@google.com>; +Cc: 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
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-11-04 09:08 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-03 22:21 Long SQL Update Question Dylan Lorimer <edylan@google.com>
2006-11-04 09:08 ` imad <immaad@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox