Postgresql Check if query is still running
<p>At my work, I needed to build a new join table in a postgresql database that involved doing a lot of computations on two existing tables.  The process was supposed to take a long time so I set it up to run over the weekend before I left on Friday.  Now, I want to check to see if the query finished or not.</p>

<p>How can I check if an INSERT command has finished yet while not being at the computer I ran it on? (No, I don't know how many rows it was suppose to add.)</p>