Johann Spies <johann.spies@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
