Re: Percent of update completed

Tom Lane wrote:
> 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.)

Thanks, Tom.

I've run it, and I see the dead_tuple_count, but I don't see an 
uncommitted count.  The dead_tuple_count seems to oscillate, too -- it 
increases slowly, but sometimes decreases immediately after.  Is that 
normal?

I don't see an uncommitted tuples count, though.

--Colin McGuigan