- nebula 版本:3.6.0
- 部署方式: 单机
- 是否上生产环境: N
- 硬件信息
- 普通磁盘100g
- 内存8g
- 问题的具体描述
profile go from 'date_2023-11-01' over dateHaveOrder yield dst(edge) as orderVid |
go from $-.orderVid over orderHaveBroker yield properties($$).brokerId as brokerId,$-.orderVid as orderVid |
go from $-.orderVid over orderHaveProduct yield properties($$).productId as productId ,properties($^).orderNo as orderNo,properties($^).productAmount as productAmount ,$-.brokerId as brokerId |
group by $-.brokerId,$-.orderNo,$-.productAmount yield $-.orderNo as orderNo,collect(distinct $-.productId) as productIds,$-.brokerId as brokerId ,$-.productAmount as productAmount |
group by $-.brokerId,$-.productIds,$-.productAmount yield $-.brokerId as keyWordLong,collect(distinct $-.orderNo) as orderNos,$-.productAmount as productAmount,$-.productIds as productIds,count(distinct $-.orderNo) as orderCount |
yield $-.keyWordLong as keyWordLong,$-.orderNos as orderNos,$-.productAmount as productAmount,$-.productIds as productIds where $-.orderCount > 6
上述语句查询大概3.4s左右,图中点12w边48w,如果把group by全部去掉查询出数据大概2.8s,这个查询速度是正常的吗,感觉很慢,是不是有哪些可以优化的地方
执行计划如下