Johann Spies <johann.spies@gmail.com> writes:
> Some of hour queries to extract the data and insert it in other tables runs
> for days and in one case we have created a table with 758million unique
> records.
> Now my question. Is there a way to monitor the progress of a long running
> query like this?
You could watch how fast the target table is physically growing, perhaps.
Or I think contrib/pgstattuple could be used to count uncommitted tuples
in it.
regards, tom lane