greenplum gp 数据库锁 查看所有sql

1 获取锁信息：

select * from gp_toolkit.gp_locks_on_relation ;

视图实现：

select pgl.locktype AS lorlocktype, pgl.database AS lordatabase, pgc.relname AS lorrelname, pgl.relation AS lorrelation, pgl.transaction AS lortransaction, pgl.pid AS lorpid, pgl.mode AS lormode, pgl.granted AS lorgranted, pgsa.current_query AS lorcurrentquery
FROM pg_locks pgl
JOIN pg_class pgc ON pgl.relation = pgc.oid
JOIN pg_stat_activity pgsa ON pgl.pid = pgsa.procpid
ORDER BY pgc.relname;

（如果gp_toolkit没有安装，则： psql -f $GPHOME/share/postgresql/gp_toolkit.sql）

2 获取当前正在运行的SQL：

select *from pg_stat_activity;

3 结束SQL进程：

pg_cancel_backend

pg_terminate_backend