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
);
Original: https://www.cnblogs.com/Boyka1/p/15673998.html
Author: 程胥员
Title: Greenplum数据库基本操作命令大全-完善ing
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/598500/
转载文章受原作者版权保护。转载请注明原作者出处！