GP 查询sql进程，kill进程

查询当前gp中进程

select * from pg_stat_activity

删除进程

select pg_cancel_backend(procpid);

SELECT pg_terminate_backend(procpid);

已上两个kill不掉 可以用 kill -9 procpid 杀掉进程，但是会导致  segement down掉（亲测）

查询当前client_addr的连接数

select client_addr,count(0) as con_cont,usename, current_timestamp from pg_stat_activity GROUP BY client_addr,usename  order by client_addr;

查询总连接数

select count(0) as con_cont from pg_stat_activity;

 

查询表的列名 字段名

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tablename' ORDER BY ORDINAL_POSITION;

 

查询Gp的配置参数

select * from pg_settings