pg kill会话

刚好遇见Mysql / 2023-06-03 / 原文

查看当前用户

select user;

select * from pg_stat_activity where query <> '<insufficient privilege>' and state='active'
SELECT pg_terminate_backend(20056316);