GreenPlum锁表处理

--GP查看锁
SELECT pid,rolname, rsqname, granted,
current_query, datname
FROM pg_roles, gp_toolkit.gp_resqueue_status, pg_locks, pg_stat_activity
WHERE pg_roles.rolresqueue=pg_locks.objid
AND pg_locks.objid=gp_toolkit.gp_resqueue_status.queueid
AND pg_stat_activity.procpid=pg_locks.pid;

--GP解除锁定
pg_cancel_backend(#pid)

 

select * from pg_locks;
select * from gp_dist_random('pg_locks') where locktype='relation' and mode='ExclusiveLock'

--查看锁的进程
select * from pg_stat_activity where procpid in (100685,7935);
--GP解除锁定
select pg_cancel_backend(7935);

select * from gp_dist_random('pg_stat_activity')
where procpid in(
select pid from gp_dist_random('pg_locks') where locktype='relation' and mode='ExclusiveLock'
)
and current_query is not null;

转载于:https://www.cnblogs.com/ljjzh/p/9028361.html