Percent of update completed - Mailing list pgsql-novice

From Colin McGuigan
Subject Percent of update completed
Date
Msg-id 420782C7.3060003@earthcomber.com
Whole thread Raw
Responses Re: Percent of update completed  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Is there a way to see how many rows of a table have been processed by an
update?  I've got an update on a 13,000,000 row table that's been
running for five days now.  Five days is a good long time, especially
considering the size of the table, so I'm suspecting a problem.  CPU is
pegged at 100%, so I'm relatively sure it's not an I/O bound issue.  But
I'd hate to kill it if it's, say, 90% of the way through.  No way I can
see to tell, though.

--Colin McGuigan

pgsql-novice by date:

Previous
From: "Schuhmacher, Bret"
Date:
Subject: Re: Stuck in "group by" aggregate hell
Next
From: DAVANNE Eric - NTR
Date:
Subject: password expiration interval