查询当前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