Skip site navigation (1) Skip section navigation (2)

Re: Percent of update completed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Colin McGuigan <cmcguigan(at)earthcomber(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Percent of update completed
Date: 2005-02-07 16:00:00
Message-ID: 27311.1107792000@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Colin McGuigan <cmcguigan(at)earthcomber(dot)com> writes:
> 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.

Not directly, but if you use the contrib/pgstattuple module you can get
readings on the numbers of committed and uncommitted tuples in the
table.  The rate at which the uncommitted-tuples count increases would
tell you how fast the update is proceeding.  (You should probably not
assume that you started with zero uncommitted tuples, unless you know
you'd vacuumed the table just beforehand.)

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Michael FuhrDate: 2005-02-07 16:26:32
Subject: Re: simple query question
Previous:From: Tom LaneDate: 2005-02-07 15:54:46
Subject: Re: multiple sampling from tables and saving output

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group