这个屌丝很懒，什么也没留下！

PostgreSQL查锁表详情_pg中查看锁表

作者：羊村懒王 | 2024-04-30 05:53:12

select distinct
       'select pg_terminate_backend('||a.pid||');' as unlock_script
      ,c.relname
      ,a.pid, a.state, a.usename, a.query, a.query_start , a.client_addr
  from pg_stat_activity a
      ,pg_locks l
      ,pg_class c
 where a.pid = l.pid
   and l.relation = c.oid
   and c.relkind in ('r','p')
   -- and c.relname =  'tmc_map_all_process_t'
 order by c.relname
;
1
2
3
4
5
6
7
8
9
10
11
12
13

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/羊村懒王/article/detail/511728