ActiveRecord::Base.connection.exec_query(" SELECT pid, age(query_start, clock_timestamp()), state, query FROM pg_stat_activity WHERE query != '' AND query NOT ILIKE '%pg_stat_activity%' and state = 'active' ORDER BY age(query_start, clock_timestamp()) ") #ActiveRecord::Base.connection.exec_query("select pg_cancel_backend(123456)") # Kill by PID