SELECT T
.PID,
T.STATE,
T.QUERY,
T.WAIT_EVENT_TYPE,
T.WAIT_EVENT,
T.QUERY_START
FROM
PG_STAT_ACTIVITY T
WHERE
T.DATNAME = 'colystdb'
AND T.WAIT_EVENT_TYPE = 'Lock';
select PG_CANCEL_BACKEND('10242');
select pg_terminate_backend ('21967')
查询PG 库 哪个表锁了
最新推荐文章于 2024-03-18 16:42:37 发布