--进程查看

select * from pg_stat_activity where current_query not like'<IDLE>%';
-- 取消进程
select pg_cancel_backend(procpid);
-- 终止进程 
select pg_terminate_backend(procpid);
-- 查询是否锁表
select * from gp_toolkit.gp_locks_on_relation where lorrelname ='qd_5g_info_202104';