bushiayang的博客

原创 解决postgresql数据库锁表问题

解决postgresql数据库锁表问题 –pgsql锁表查询 select a.pid,b.oid,b.relname,c.state_change,query 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 ‘%ExclusiveLock%’ ORDER BY c.state_change; – pgsql释放锁 select p