Colin McGuigan <cmcguigan@earthcomber.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