hexuxu110 commented on issue #2869:
URL:
https://github.com/apache/incubator-hugegraph/issues/2869#issuecomment-3280284525
@dosu
我本就是主键id查询 不需要二级索引 这是我的执行计划 {
"requestId": "adf4464d-f2a6-4f49-942a-21442622b0c4",
"status": {
"message": "",
"code": 200,
"attributes": {}
},
"result": {
"data": [
{
"original": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[TraversalFilterStep([NotStep([PropertiesStep([status],value)])])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[[IdStep],
[VertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label, create_time,
update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree, cnt],[[SideEffectCapStep([tree])],
[SideEffectCapStep([cnt])]])"
],
"intermediate": [
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[TraversalFilterStep([NotStep([PropertiesStep([status],value)])])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "ConnectiveStrategy",
"category": "DecorationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[TraversalFilterStep([NotStep([PropertiesStep([status],value)])])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "IdentityRemovalStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[TraversalFilterStep([NotStep([PropertiesStep([status],value)])])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "MatchPredicateStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[TraversalFilterStep([NotStep([PropertiesStep([status],value)])])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "FilterRankingStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],value)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "InlineFilterStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],value)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "IncidentToAdjacentStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "AdjacentToIncidentStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "CountStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "RepeatUnrollStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id,
cntMap],[[IdStep], [VertexStep(BOTH,[user_id_card, user_phone, user_bank_card,
user_email, user_device, user_openid],edge), GroupCountStep([LabelStep])]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[[IdStep], [LabelStep],
[PropertiesStep([relation_create_time],value)],
[PropertiesStep([relation_update_time],value)]])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "PathRetractionStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[VertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "ByModulatorOptimizationStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[VertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "EarlyLimitStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[VertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "LazyBarrierStrategy",
"category": "OptimizationStrategy"
},
{
"traversal": [
"GraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[VertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "HugePrimaryKeyStrategy",
"category": "ProviderOptimizationStrategy"
},
{
"traversal": [
"HugeGraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[VertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "HugeGraphStepStrategy",
"category": "ProviderOptimizationStrategy"
},
{
"traversal": [
"HugeGraphStep(vertex,[650910907213576])",
"VertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[VertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"VertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[VertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "HugeCountStepStrategy",
"category": "ProviderOptimizationStrategy"
},
{
"traversal": [
"HugeGraphStep(vertex,[650910907213576])",
"HugeVertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[HugeVertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"HugeVertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[HugeVertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "HugeVertexStepStrategy",
"category": "ProviderOptimizationStrategy"
},
{
"traversal": [
"HugeGraphStep(vertex,[650910907213576])",
"HugeVertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[HugeVertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"HugeVertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[HugeVertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "ProfileStrategy",
"category": "FinalizationStrategy"
},
{
"traversal": [
"HugeGraphStep(vertex,[650910907213576])",
"HugeVertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[HugeVertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"HugeVertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[HugeVertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label,
create_time, update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree,
cnt],[[SideEffectCapStep([tree])], [SideEffectCapStep([cnt])]])"
],
"strategy": "StandardVerificationStrategy",
"category": "VerificationStrategy"
}
],
"final": [
"HugeGraphStep(vertex,[650910907213576])",
"HugeVertexStep(OUT,[user_id_card, user_phone,
user_bank_card, user_email, user_device, user_openid],edge)",
"TraversalFilterStep([EdgeOtherVertexStep,
AndStep([[HugeVertexStep(IN,edge), RangeGlobalStep(0,100),
TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])]),
RangeGlobalStep(0,2), CountGlobalStep, IsStep(gte(2))],
[OrStep([[NotStep([PropertiesStep([status],property)])],
[HasStep([status.without([dirty_node(link_user>1500),
dirty_node(link_diff_country_user_and_link_user>1000),
dirty_node(orings=7_label=device_link_user>=100_reg_city>=5)])])]])]])])",
"AggregateGlobalStep(res)",
"EdgeOtherVertexStep",
"HugeVertexStep(IN,edge)",
"WherePredicateStep(without([res]))",
"TraversalFilterStep([EdgeOtherVertexStep,
TraversalFilterStep([PropertiesStep([country_code],value), IsStep(eq(br))])])",
"RangeGlobalStep(0,100)",
"AggregateGlobalStep(res)",
"SideEffectCapStep([res])",
"UnfoldStep",
"EdgeVertexStep(BOTH)",
"DedupGlobalStep",
"RangeGlobalStep(0,200)",
"TraversalMapStep([ProjectStep([id, cntMap],[id,
[HugeVertexStep(BOTH,[user_id_card, user_phone, user_bank_card, user_email,
user_device, user_openid],edge), GroupCountStep(label)]])])",
"AggregateGlobalStep(cnt)",
"SideEffectCapStep([res])",
"UnfoldStep",
"TraversalMapStep([ProjectStep([id, label, create_time,
update_time],[id, label, value(relation_create_time),
value(relation_update_time)])])",
"AggregateGlobalStep(tree)",
"FoldStep",
"ProjectStep([tree, cnt],[[SideEffectCapStep([tree])],
[SideEffectCapStep([cnt])]])"
]
}
],
"meta": {}
}
}
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@hugegraph.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@hugegraph.apache.org
For additional commands, e-mail: issues-h...@hugegraph.apache.org
