PostgreSQL死锁表查询及杀死死锁进程命令
一、PostgreSQL中查询死锁的表WITHt_wait AS (SELECTa.mode,a.locktype,a.databASe,a.relation,a.page,a.tuple,a.clASsid,a.granted,a.objid,a.objsubid,a.pid,a.virtualtransaction,a.virtualxid,a.transactionid,a.fAStpath,b.state,b.query,b.xact_start,b.query_start,b.usen
原创
2020-10-12 09:58:14 ·
2261 阅读 ·
0 评论