摘要:查询哪些表、哪些进程被锁住了 select * from pg_locks a join pg_class b on a.relation = b.oid join pg_stat_activity c on a.pid = c.pid where a.mode like '%ExclusiveLo
阅读全文
posted @ 2021-09-16 09:53
wank
随笔分类 - Posrgre SQL
摘要:查询哪些表、哪些进程被锁住了 select * from pg_locks a join pg_class b on a.relation = b.oid join pg_stat_activity c on a.pid = c.pid where a.mode like '%ExclusiveLo
阅读全文
posted @ 2021-09-16 09:53
|