GaussDB

--查询锁表
select oid from pg_class where relname='可能锁表了的表'
select pid from pg_locks where relation='上面查出的oid'
--如果查询到了结果，表示该表被锁 则需要释放锁定
select pg_cancel_backend(上面查到的pid)

--表赋权
grant select on 表名 to 用户名;

--查看任务状态===============================================================
select * from pg_stat_activity where state='active' and query like '%111053%';
select * from pg_stat_activity where state='active' and query like '%100291%';
select * from pg_stat_activity where state='active' and query_id = '291889550882008369';
select * from pgxc_thread_wait_STATUS where wait_status !='wait cmd' and wait_status !='none' and node_name like 'cn%' and thread_name='PostgreSQL JDBC Driver';



--杀任务====================================================================
ALTER SYSTEM KILL SESSION '140136638949120, 0' IMMEDIATE ;


--数据库中查找表================================================================
SELECT table_name FROM information_schema.tables WHERE table_schema = 'tpi_rpt' and table_name like '%100300%';