[SQL] Track query status

[Sumeet]

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