查询并杀掉Postgresql相应的进程

select c.pid,a.relname,c.* from
pg_class a,
pg_locks b,
pg_stat_activity c
where b.relation = a.oid
and b.pid = c.pid
and a.relname='table_name';--表名

select pg_terminate_backend(上面pid);