View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 09:28 PM
Colin McGuigan
 
Posts: n/a
Default Percent of update completed

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote