m01067@nebula) [orion]> profile format='row' match (v:orion_v)--(v2:orion_v) where id(v)=='160052652042' and v2.orion_v.pk_type==2 match (v2:orion_v)--(v3:orion_v) with v2,size(collect(v3)) as c2 return max(c2) as num +----------+ | num | +----------+ | __NULL__ | +----------+ Got 1 rows (time spent 6523/7071 us) Execution Plan (optimize time 160 us) -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | id | name | dependencies | profiling data | operator info | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 16 | Aggregate | 15 | ver: 0, rows: 1, execTime: 4us, totalTime: 5us | outputVar: { | | | | | | "colNames": [ | | | | | | "num" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__Aggregate_16" | | | | | | } | | | | | | inputVar: __Project_15 | | | | | | groupKeys: [] | | | | | | groupItems: [ | | | | | | { | | | | | | "expr": "max($c2)" | | | | | | } | | | | | | ] | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 15 | Project | 14 | ver: 0, rows: 0, execTime: 1us, totalTime: 2us | outputVar: { | | | | | | "colNames": [ | | | | | | "v2", | | | | | | "c2" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__Project_15" | | | | | | } | | | | | | inputVar: __Aggregate_14 | | | | | | columns: [ | | | | | | "$v2", | | | | | | "size($collect(v3))" | | | | | | ] | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 14 | Aggregate | 13 | ver: 0, rows: 0, execTime: 4us, totalTime: 5us | outputVar: { | | | | | | "colNames": [ | | | | | | "v2", | | | | | | "collect(v3)" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__Aggregate_14" | | | | | | } | | | | | | inputVar: __BiInnerJoin_13 | | | | | | groupKeys: [ | | | | | | "$v2" | | | | | | ] | | | | | | groupItems: [ | | | | | | { | | | | | | "expr": "$v2" | | | | | | }, | | | | | | { | | | | | | "expr": "collect($v3)" | | | | | | } | | | | | | ] | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 13 | BiInnerJoin | 18,12 | ver: 0, rows: 0, execTime: 30us, totalTime: 30us | outputVar: { | | | | | | "colNames": [ | | | | | | "v", | | | | | | "v2", | | | | | | "v2", | | | | | | "v3" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__BiInnerJoin_13" | | | | | | } | | | | | | inputVar: { | | | | | | "rightVar": "__Project_12", | | | | | | "leftVar": "__Filter_7" | | | | | | } | | | | | | hashKeys: [ | | | | | | "id($-.v2)" | | | | | | ] | | | | | | probeKeys: [ | | | | | | "id($-.v2)" | | | | | | ] | | | | | | kind: InnerJoin | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 18 | Project | 17 | ver: 0, rows: 2, execTime: 10us, totalTime: 11us | outputVar: { | | | | | | "colNames": [ | | | | | | "v", | | | | | | "v2" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__Filter_7" | | | | | | } | | | | | | inputVar: __Filter_17 | | | | | | columns: [ | | | | | | "$-.v AS v", | | | | | | "$-.v2 AS v2" | | | | | | ] | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 17 | Filter | 5 | ver: 0, rows: 2, execTime: 42us, totalTime: 42us | outputVar: { | | | | | | "colNames": [ | | | | | | "v", | | | | | | "__VAR_0", | | | | | | "v2" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__Filter_17" | | | | | | } | | | | | | inputVar: __AppendVertices_5 | | | | | | condition: ((id($-.v)=="160052652042") AND (-.v2.orion_v.pk_type==2)) | | | | | | isStable: false | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 5 | AppendVertices | 4 | { | outputVar: { | | | | | ver: 0, rows: 16, execTime: 263us, totalTime: 910us | "colNames": [ | | | | | "172.29.3.10":9779 exec/total: 389(us)/614(us) | "v", | | | | | "172.29.3.12":9779 exec/total: 301(us)/594(us) | "__VAR_0", | | | | | total_rpc: 694(us) | "v2" | | | | | "172.29.3.11":9779 exec/total: 283(us)/555(us) | ], | | | | | } | "type": "DATASET", | | | | | | "name": "__AppendVertices_5" | | | | | | } | | | | | | inputVar: __Traverse_4 | | | | | | space: 172 | | | | | | dedup: true | | | | | | limit: -1 | | | | | | filter: | | | | | | orderBy: [] | | | | | | src: none_direct_dst($-.__VAR_0) | | | | | | props: [ | | | | | | { | | | | | | "props": [ | | | | | | "black_ab", | | | | | | "black_c", | | | | | | "black_d", | | | | | | "black_oper", | | | | | | "black_ts", | | | | | | "cust_name", | | | | | | "id", | | | | | | "id_1", | | | | | | "id_card", | | | | | | "pk", | | | | | | "pk_type", | | | | | | "id_type", | | | | | | "mobile", | | | | | | "tid", | | | | | | "update_ts", | | | | | | "is_external", | | | | | | "cust_org", | | | | | | "black_ts_bk", | | | | | | "insert_ts", | | | | | | "_tag" | | | | | | ], | | | | | | "tagId": 173 | | | | | | } | | | | | | ] | | | | | | exprs: | | | | | | vertex_filter: orion_v._tag IS NOT EMPTY | | | | | | if_track_previous_path: true | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 4 | Traverse | 2 | { | outputVar: { | | | | | ver: 0, rows: 16, execTime: 137us, totalTime: 849us | "colNames": [ | | | | | step 1: { | "v", | | | | | {"172.29.3.11":9779 exec/total/vertices: 317(us)/649(us)/1, | "__VAR_0" | | | | | total_rpc_time: 703(us) | ], | | | | | storage_detail: {GetNeighborsNode:227(us),HashJoinNode:205(us),RelNode:227(us),SingleEdgeNode:113(us),TagNode:79(us)} | "type": "DATASET", | | | | | } | "name": "__Traverse_4" | | | | | } | } | | | | | } | inputVar: __Dedup_2 | | | | | | space: 172 | | | | | | dedup: true | | | | | | limit: -1 | | | | | | filter: | | | | | | orderBy: [] | | | | | | src: $-._vid | | | | | | edgeTypes: [] | | | | | | edgeDirection: BOTH | | | | | | vertexProps: [ | | | | | | { | | | | | | "props": [ | | | | | | "black_ab", | | | | | | "black_c", | | | | | | "black_d", | | | | | | "black_oper", | | | | | | "black_ts", | | | | | | "cust_name", | | | | | | "id", | | | | | | "id_1", | | | | | | "id_card", | | | | | | "pk", | | | | | | "pk_type", | | | | | | "id_type", | | | | | | "mobile", | | | | | | "tid", | | | | | | "update_ts", | | | | | | "is_external", | | | | | | "cust_org", | | | | | | "black_ts_bk", | | | | | | "insert_ts", | | | | | | "_tag" | | | | | | ], | | | | | | "tagId": 173 | | | | | | } | | | | | | ] | | | | | | edgeProps: [ | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "-176" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "176" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "-174" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "174" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "-175" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "175" | | | | | | } | | | | | | ] | | | | | | statProps: | | | | | | exprs: | | | | | | random: false | | | | | | steps: | | | | | | vertex filter: orion_v._tag IS NOT EMPTY | | | | | | edge filter: | | | | | | if_track_previous_path: false | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 2 | Dedup | 1 | ver: 0, rows: 1, execTime: 4us, totalTime: 4us | outputVar: { | | | | | | "colNames": [ | | | | | | "_vid" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__Dedup_2" | | | | | | } | | | | | | inputVar: __VAR_2 | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 1 | PassThrough | 3 | ver: 0, rows: 0, execTime: 4us, totalTime: 5us | outputVar: { | | | | | | "colNames": [ | | | | | | "_vid" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__VAR_2" | | | | | | } | | | | | | inputVar: | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 3 | Start | | ver: 0, rows: 0, execTime: 0us, totalTime: 13us | outputVar: { | | | | | | "colNames": [], | | | | | | "type": "DATASET", | | | | | | "name": "__Start_3" | | | | | | } | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 12 | Project | 11 | ver: 0, rows: 79, execTime: 293us, totalTime: 294us | outputVar: { | | | | | | "colNames": [ | | | | | | "v2", | | | | | | "v3" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__Project_12" | | | | | | } | | | | | | inputVar: __AppendVertices_11 | | | | | | columns: [ | | | | | | "$-.v2 AS v2", | | | | | | "$-.v3 AS v3" | | | | | | ] | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 11 | AppendVertices | 10 | { | outputVar: { | | | | | ver: 0, rows: 79, execTime: 697us, totalTime: 1993us | "colNames": [ | | | | | "172.29.3.10":9779 exec/total: 765(us)/1006(us) | "v2", | | | | | "172.29.3.11":9779 exec/total: 810(us)/1065(us) | "__VAR_1", | | | | | total_rpc: 1397(us) | "v3" | | | | | "172.29.3.12":9779 exec/total: 1005(us)/1334(us) | ], | | | | | } | "type": "DATASET", | | | | | | "name": "__AppendVertices_11" | | | | | | } | | | | | | inputVar: __Traverse_10 | | | | | | space: 172 | | | | | | dedup: true | | | | | | limit: -1 | | | | | | filter: | | | | | | orderBy: [] | | | | | | src: none_direct_dst($-.__VAR_1) | | | | | | props: [ | | | | | | { | | | | | | "props": [ | | | | | | "black_ab", | | | | | | "black_c", | | | | | | "black_d", | | | | | | "black_oper", | | | | | | "black_ts", | | | | | | "cust_name", | | | | | | "id", | | | | | | "id_1", | | | | | | "id_card", | | | | | | "pk", | | | | | | "pk_type", | | | | | | "id_type", | | | | | | "mobile", | | | | | | "tid", | | | | | | "update_ts", | | | | | | "is_external", | | | | | | "cust_org", | | | | | | "black_ts_bk", | | | | | | "insert_ts", | | | | | | "_tag" | | | | | | ], | | | | | | "tagId": 173 | | | | | | } | | | | | | ] | | | | | | exprs: | | | | | | vertex_filter: orion_v._tag IS NOT EMPTY | | | | | | if_track_previous_path: true | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 10 | Traverse | 8 | { | outputVar: { | | | | | ver: 0, rows: 79, execTime: 501us, totalTime: 1664us | "colNames": [ | | | | | step 1: { | "v2", | | | | | {"172.29.3.10":9779 exec/total/vertices: 515(us)/718(us)/3, | "__VAR_1" | | | | | total_rpc_time: 1151(us) | ], | | | | | storage_detail: {GetNeighborsNode:445(us),HashJoinNode:399(us),RelNode:446(us),SingleEdgeNode:325(us),TagNode:47(us)} | "type": "DATASET", | | | | | }{"172.29.3.11":9779 exec/total/vertices: 280(us)/474(us)/2, | "name": "__Traverse_10" | | | | | total_rpc_time: 1151(us) | } | | | | | storage_detail: {GetNeighborsNode:237(us),HashJoinNode:215(us),RelNode:237(us),SingleEdgeNode:187(us),TagNode:19(us)} | inputVar: __Argument_8 | | | | | }{"172.29.3.12":9779 exec/total/vertices: 746(us)/1048(us)/2, | space: 172 | | | | | total_rpc_time: 1151(us) | dedup: true | | | | | storage_detail: {GetNeighborsNode:685(us),HashJoinNode:632(us),RelNode:685(us),SingleEdgeNode:590(us),TagNode:27(us)} | limit: -1 | | | | | } | filter: | | | | | } | orderBy: [] | | | | | } | src: id($-.v2) | | | | | | edgeTypes: [] | | | | | | edgeDirection: BOTH | | | | | | vertexProps: [ | | | | | | { | | | | | | "props": [ | | | | | | "black_ab", | | | | | | "black_c", | | | | | | "black_d", | | | | | | "black_oper", | | | | | | "black_ts", | | | | | | "cust_name", | | | | | | "id", | | | | | | "id_1", | | | | | | "id_card", | | | | | | "pk", | | | | | | "pk_type", | | | | | | "id_type", | | | | | | "mobile", | | | | | | "tid", | | | | | | "update_ts", | | | | | | "is_external", | | | | | | "cust_org", | | | | | | "black_ts_bk", | | | | | | "insert_ts", | | | | | | "_tag" | | | | | | ], | | | | | | "tagId": 173 | | | | | | } | | | | | | ] | | | | | | edgeProps: [ | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "-176" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "176" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "-174" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "174" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "-175" | | | | | | }, | | | | | | { | | | | | | "props": [ | | | | | | "_dst", | | | | | | "_rank", | | | | | | "_type", | | | | | | "_src" | | | | | | ], | | | | | | "type": "175" | | | | | | } | | | | | | ] | | | | | | statProps: | | | | | | exprs: | | | | | | random: false | | | | | | steps: | | | | | | vertex filter: orion_v._tag IS NOT EMPTY | | | | | | edge filter: | | | | | | if_track_previous_path: false | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 8 | Argument | | ver: 0, rows: 7, execTime: 0us, totalTime: 27us | outputVar: { | | | | | | "colNames": [ | | | | | | "v2" | | | | | | ], | | | | | | "type": "DATASET", | | | | | | "name": "__Argument_8" | | | | | | } | | | | | | inputVar: __AppendVertices_5 | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ | 9 | Start | | | outputVar: { | | | | | | "colNames": [], | | | | | | "type": "DATASET", | | | | | | "name": "__Start_9" | | | | | | } | -----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------ Wed, 28 Jun 2023 20:35:45 CST