Backtrack:  
 
by lunarg on April 15th 2013, at 08:57

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);
 
 
« August 2020»
SunMonTueWedThuFriSat
      1
2345678
9101112131415
16171819202122
23242526272829
3031     
 
Links
 
Quote
« I needed a password with eight characters so I picked Snow White and the Seven Dwarves. »