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);
 
 
« April 2021»
SunMonTueWedThuFriSat
    123
45678910
11121314151617
18192021222324
252627282930
 
Links
 
Quote
« When a bird does poo poo in your eye, be happy elephants don't fly. »