Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
Track query status
- From: Sumeet <asumeet(at)gmail(dot)com>
- To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
- Subject: Track query status
- Date: Wed, 28 Mar 2007 16:59:24 -0400
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
- Follow-Ups:
- Re: Track query status
- From: Andrew Sullivan
- Re: Track query status
- Prev by Date: How too select different views using a IF/THEN/ELSE procedure ?
- Next by Date: Re: Track query status
- Previous by thread: How too select different views using a IF/THEN/ELSE procedure ?
- Next by thread: Re: Track query status
- Indexes: