Re: [PERFORM] Long running query: How to monitor the progress

2015-08-25 Thread Tom Lane
Johann Spies 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 h

[PERFORM] Long running query: How to monitor the progress

2015-08-25 Thread Johann Spies
Working with 9.4. We are in the process of unpacking complicated XML-data into tables. XML-data are already in a table with two fields (id, xml) - 47+ million records. 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