Re: Long running update

Akash Garg <akash.garg@gmail.com> writes:
> I currently running an update statement that updates every row in a
> very large table.  This query will obviously take a long time to run.
> My question -- is there any way to know how much time it will take
> once it starts?  Even something that could help me approximate the
> speed at which it's doing the update would be helpful.

If it's doing a seqscan then strace'ing the backend and noting which
blocks it's reading would give you a good hint.  If it's an indexscan
there's probably no very easy way to tell ...

            regards, tom lane