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 lorcurrentqueryFROM pg_locks pglJOIN pg_class pgc ON pgl.relation = pgc.oidJOIN pg_stat_activity pgsa ON pgl.pid = pgsa.procpidORDER 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