Track query status

From: Sumeet <asumeet(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Track query status
Date: 2007-03-28 20:59:24
Message-ID: 7539aebb0703281359v5b56cc59xf9e80ad4a74e51d7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

I have ran a update query on a dataset which has about 48 million records
and the query is already running for the third day....im so tempted to the
kill this query now....is there a way to know if the query is running??
here is the query i've ran

UPDATE ma SET av=to_tsvector('default',coalesce(name_first,'') ||' '||
coalesce(name_last,''));

Thanks,
Sumeet

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-03-28 21:49:54 Re: Track query status
Previous Message Wilkinson, Jim 2007-03-28 19:04:30 How too select different views using a IF/THEN/ELSE procedure ?