[GreenPlum] 锁的查看与解除

1.GreenPlum的锁
–GP查看锁

select pid,rolname,rsqname,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解除锁定


select pg_cancel_backend(#pid)

 

分类上一篇:     分类下一篇:

Leave a Reply