GP解除表锁定

1.查询当前为‘lock’状态的pid

　　select pid from pg_stat_activity where waiting_reason ='lock';

2.取消正在运行的query

　　select pg_cancel_backend(pid);

3.清理session

　　select pg_terminate_backend(pid);