数据库表被锁住,如何解决?

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 );

  

posted @ 2023-11-15 14:02  小路亚  阅读(17)  评论(0)    收藏  举报