pg kill会话

查看当前用户

select user;

select oid from pg_class where relname='t2';
select pid from pg_locks where relation=24627;

select * from pg_stat_activity where state<>'idle' and now()-query_start > interval '5 s' order by query_start ;
SELECT pg_terminate_backend(20056316);

posted @ 2023-06-03 13:26  刚好遇见Mysql  阅读(183)  评论(0)    收藏  举报