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

发布时间 2023-11-15 14:08:10作者: 小路亚
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 );