# run in your psql console # # test=# SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE query='SELECT "posts".* FROM "posts"';