Greenplum数据库基本操作命令大全

select * from pg_stat_activity;

datid  --16388 
datname   --hfamlgpdbs  数据库名称
pid  --17001		进程id
sess_id  --1413     会话id
usesysid	--16384	 
usename		--amlapp  用户名
appication_name		--PostgreSQL JDBC Driver
client_addr		--10.198.68.161   客户机地址ip
client_hostname  		客户机主机名
client_port		--45042  客户机端口号
backend_stat    --2021-12-10  14:53:58.7524041+08  
xact_stat
query_stat
stat_change     f
waiting			
state		--idle/active    活动状态
backend_xid
backend_xmin
query     --  select null as table_cat ......    查询语句
waiting_reason
rsgname
rsggueueduration

--删除重复数据

delete from table_name
where gp_segment_id::varchar(100) || ctid::varchar(100)
in (select t.ctid from (
		select gp_segment_id::varchar(100)||ctid::varchar(100) as ctid,
				clo1,
				clo2,
				clo3,
				row_number() over(partition by clo1,clo2,clo3) rows_num
		from table_name) t
	where rows_num >=2
	);