Email this to a friend
 
posted on April 15th 2013, at 08:57
by lunarg

To get a list of running SQL queries, log into the PostgreSQL CLI:

psql -U username database

Replace username and database with the proper values. Then run this query:

SELECT procpid,datname,usename,client_addr,waiting,query_start,current_query FROM pg_stat_activity;

Inside the list is also the procpid, which you will need to kill a running query. To kill, run this query, substituting with the proper procpid:

SELECT pg_cancel_backend(procpid);

Send a link to this post to yourself or a friend.

Send to e-mail:
Your name:
Your e-mail:
Captcha:
Type the letters and numbers as shown.
/get/captcha/1597507556
Not readable? Get another.
 
Information entered is solely used for sending a one-time e-mail, and is not retained and/or passed on to a third party.
 
 
 
 
« August 2020»
SunMonTueWedThuFriSat
      1
2345678
9101112131415
16171819202122
23242526272829
3031     
 
Links
 
Quote
« You only find out who is swimming naked when the tide goes out. »
Warren Buffett