GreenPlum锁表以及解除锁定
?
--GP查看锁SELECT pid,rolname, rsqname, granted,current_query, datnameFROM pg_roles, gp_toolkit.gp_resqueue_status, pg_locks, pg_stat_activityWHERE pg_roles.rolresqueue=pg_locks.objidAND pg_locks.objid=gp_toolkit.gp_resqueue_status.queueidAND pg_stat_activity.procpid=pg_locks.pid;--GP解除锁定pg_cancel_backend(#pid)
