SELECT A .* FROM pg_stat_activity A, pg_locks b, pg_class C WHERE A.pid = b.pid AND A.sessionid = b.sessionid AND b.relation = C.oid AND A.datname = 'mes' AND C.relname = 'edcresultitem' -- AND waiting = true ORDER BY query_start ASC; SELECT pg_terminate_backend ( 140560218584832 );
标签:数据库,pid,锁住,sessionid,pg,解决,SELECT From: https://www.cnblogs.com/helloluya/p/17833694.html