PG資料庫更新刪除卡死現象

-- 查詢連線到目標資料庫的會話
SELECT pid, state, usename, query
FROM pg_stat_activity
WHERE datname = 'db_bigdata';

-- 終止這些會話
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'db_bigdata';


-- 查詢已準備好的事務
 SELECT gid, prepared, owner, database
 FROM pg_prepared_xacts
 WHERE database = 'db_bigdata';

 -- 終止所有已準備好的事務 這個gid指具體的值
 ROLLBACK PREPARED 'gid';