随笔分类 -  GreenPlum

摘要:1.查询当前为‘lock’状态的pid select pid from pg_stat_activity where waiting_reason ='lock'; 2.取消正在运行的query select pg_cancel_backend(pid); 3.清理session select pg 阅读全文
posted @ 2022-06-28 17:20 &清风明月& 阅读(352) 评论(0) 推荐(0)