- nebula 版本:v3.2.0
- 部署方式:分布式
- 安装方式:RPM
- 是否为线上版本:Y
- 硬件信息
- 磁盘( 推荐使用 SSD)
- CPU、内存信息
- 问题的具体描述
用了最新版的find path 优化后的版本,做了测试,发现这个find path 性能还是很不理想和neo4j 差了数量级的。
profile 之后如下:
(root@nebula) [Relation]> profile FIND SHORTEST PATH FROM 6708325840852936710 TO 657274819696178340 OVER Employ, Invest, Legal, Branch, HisEmploy, HisLegal, HisInvest BIDIRECT UPTO 10 Steps yield path as p
+---+
| p |
+---+
+---+
Empty set (time spent 10799860/10796632 us)
Execution Plan (optimize time 55 us)
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| id | name | dependencies | profiling data | operator info |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| 7 | DataCollect | 6 | ver: 0, rows: 0, execTime: 16us, totalTime: 17us | outputVar: { |
| | | | | "colNames": [ |
| | | | | "p" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__DataCollect_7" |
| | | | | } |
| | | | | inputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "_path" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__BFSShortest_5"
|
| | | | | }
|
| | | | | ]
|
| | | | | kind: BFS SHORTEST
|
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| 6 | Loop | 0 | ver: 0, rows: 1, execTime: 12us, totalTime: 13us | outputVar: {
|
| | | | ver: 1, rows: 1, execTime: 9us, totalTime: 10us | "colNames": [],
|
| | | | ver: 2, rows: 1, execTime: 9us, totalTime: 10us | "type": "DATASET",
|
| | | | ver: 3, rows: 1, execTime: 11us, totalTime: 12us | "name": "__Loop_6"
|
| | | | ver: 4, rows: 1, execTime: 12us, totalTime: 13us | }
|
| | | | ver: 5, rows: 1, execTime: 255256us, totalTime: 255259us | inputVar:
|
| | | | | condition: ((++($__VAR_2)<=5) AND (($__BFSShortest_5==__EMPTY__) OR (size($__BFSShortest_5)==0))) |
| | | | | loopBody: 5
|
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| 5 | BFSShortest | 3,4 | ver: 0, rows: 0, execTime: 20us, totalTime: 5781us | branch: true, nodeId: 6
|
| | | | ver: 1, rows: 0, execTime: 12us, totalTime: 17859us |
|
| | | | ver: 2, rows: 0, execTime: 9us, totalTime: 130085us | outputVar: {
|
| | | | ver: 3, rows: 0, execTime: 11us, totalTime: 639233us | "colNames": [
|
| | | | ver: 4, rows: 0, execTime: 11us, totalTime: 3752116us | "_path"
|
| | | | | ],
|
| | | | | "type": "DATASET",
|
| | | | | "name": "__BFSShortest_5"
|
| | | | | }
|
| | | | | inputVar: {
|
| | | | | "rightVar": "__GetNeighbors_4", |
| | | | | "leftVar": "__GetNeighbors_3" |
| | | | | }
|
| | | | | LeftNextVidVar: "__VAR_0"
|
| | | | | RightNextVidVar: "__VAR_1"
|
| | | | | steps: 10
|
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| 3 | GetNeighbors | 2 | { | outputVar: {
|
| | | | ver: 0, rows: 4, execTime: 50us, totalTime: 1569us | "colNames": [],
|
| | | | storage_detail: {GetNeighborsNode:697(us),HashJoinNode:689(us),RelNode:697(us),SingleEdgeNode:678(us)} | "type": "DATASET",
|
| | | | total_rpc_time: 1511(us) | "name": "__GetNeighbors_3"
|
| | | | "10.0.7.142":9779 exec/total/vertices: 995(us)/1464(us)/1, | }
|
| | | | } | inputVar: __VAR_0
|
| | | | { | space: 2
|
| | | | ver: 1, rows: 7, execTime: 46us, totalTime: 1118us | dedup: true
|
| | | | "10.0.7.142":9779 exec/total/vertices: 643(us)/1034(us)/2, | limit: -1
|
| | | | storage_detail: {GetNeighborsNode:1014(us),HashJoinNode:1003(us),RelNode:1015(us),SingleEdgeNode:985(us)} | filter:
|
| | | | total_rpc_time: 1066(us) | orderBy: []
|
| | | | } | src: COLUMN[0]
|
| | | | { | edgeTypes: []
|
| | | | ver: 2, rows: 4, execTime: 70us, totalTime: 1057us | edgeDirection: OUT_EDGE
|
| | | | storage_detail: {GetNeighborsNode:517(us),HashJoinNode:508(us),RelNode:517(us),SingleEdgeNode:497(us)} | vertexProps:
|
| | | | total_rpc_time: 975(us) | edgeProps: [
|
| | | | "10.0.7.89":9779 exec/total/vertices: 639(us)/920(us)/1, | {
|
| | | | } | "props": [
|
| | | | { | "_dst",
|
| | | | ver: 3, rows: 5, execTime: 56us, totalTime: 1275us | "_type",
|
| | | | total_rpc_time: 1208(us) | "_rank"
|
| | | | "10.0.7.100":9779 exec/total/vertices: 708(us)/1155(us)/1, | ],
|
| | | | storage_detail: {GetNeighborsNode:575(us),HashJoinNode:566(us),RelNode:575(us),SingleEdgeNode:559(us)} | "type": -8
|
| | | | } | },
|
| | | | { | {
|
| | | | ver: 4, rows: 8, execTime: 97us, totalTime: 1525us | "props": [
|
| | | | "10.0.7.93":9779 exec/total/vertices: 779(us)/1294(us)/1, | "_dst",
|
| | | | storage_detail: {GetNeighborsNode:604(us),HashJoinNode:596(us),RelNode:605(us),SingleEdgeNode:585(us)} | "_type",
|
| | | | total_rpc_time: 1416(us) | "_rank"
|
| | | | "10.0.7.100":9779 exec/total/vertices: 822(us)/1291(us)/1, | ],
|
| | | | } | "type": -6
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -7
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -9
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -10
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -12
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -11
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 8
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 6
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 7
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 9
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 10
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 12
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 11
|
| | | | | }
|
| | | | | ]
|
| | | | | statProps:
|
| | | | | exprs:
|
| | | | | random: false
|
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| 2 | PassThrough | 1 | ver: 0, rows: 0, execTime: 3us, totalTime: 3us | outputVar: {
|
| | | | ver: 1, rows: 0, execTime: 1us, totalTime: 2us | "colNames": [],
|
| | | | ver: 2, rows: 0, execTime: 4us, totalTime: 5us | "type": "DATASET",
|
| | | | ver: 3, rows: 0, execTime: 4us, totalTime: 4us | "name": "__PassThrough_2"
|
| | | | ver: 4, rows: 0, execTime: 3us, totalTime: 4us | }
|
| | | | | inputVar: __Start_1
|
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| 1 | Start | | ver: 0, rows: 0, execTime: 0us, totalTime: 7us | outputVar: {
|
| | | | ver: 1, rows: 0, execTime: 0us, totalTime: 5us | "colNames": [],
|
| | | | ver: 2, rows: 0, execTime: 0us, totalTime: 5us | "type": "DATASET",
|
| | | | ver: 3, rows: 0, execTime: 0us, totalTime: 4us | "name": "__Start_1"
|
| | | | ver: 4, rows: 0, execTime: 0us, totalTime: 4us | }
|
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| 4 | GetNeighbors | 2 | { | outputVar: {
|
| | | | ver: 0, rows: 4024, execTime: 39us, totalTime: 5481us | "colNames": [],
|
| | | | storage_detail: {GetNeighborsNode:2814(us),HashJoinNode:936(us),RelNode:2815(us),SingleEdgeNode:927(us)} | "type": "DATASET",
|
| | | | total_rpc_time: 5434(us) | "name": "__GetNeighbors_4"
|
| | | | "10.0.7.142":9779 exec/total/vertices: 3162(us)/5388(us)/1, | }
|
| | | | } | inputVar: __VAR_1
|
| | | | { | space: 2
|
| | | | ver: 1, rows: 16852, execTime: 7208us, totalTime: 128290us | dedup: true
|
| | | | "10.0.7.93":9779 exec/total/vertices: 69724(us)/79631(us)/628, | limit: -1
|
| | | | storage_detail: {GetNeighborsNode:373190(us),HashJoinNode:370777(us),RelNode:373280(us),SingleEdgeNode:369557(us)} | filter:
|
| | | | "10.0.7.142":9779 exec/total/vertices: 70331(us)/76286(us)/681, | orderBy: []
|
| | | | "10.0.7.92":9779 exec/total/vertices: 85122(us)/93837(us)/687, | src: COLUMN[0]
|
| | | | "10.0.7.95":9779 exec/total/vertices: 67512(us)/74396(us)/641, | edgeTypes: []
|
| | | | "10.0.7.89":9779 exec/total/vertices: 99680(us)/102421(us)/705, | edgeDirection: OUT_EDGE
|
| | | | "10.0.7.100":9779 exec/total/vertices: 78735(us)/85103(us)/654, | vertexProps:
|
| | | | total_rpc_time: 121068(us) | edgeProps: [
|
| | | | } | {
|
| | | | { | "props": [
|
| | | | ver: 2, rows: 96408, execTime: 3007us, totalTime: 174999us | "_dst",
|
| | | | "10.0.7.93":9779 exec/total/vertices: 153024(us)/164061(us)/1407, | "_type",
|
| | | | storage_detail: {GetNeighborsNode:702286(us),HashJoinNode:693062(us),RelNode:702483(us),SingleEdgeNode:690823(us)} | "_rank"
|
| | | | "10.0.7.95":9779 exec/total/vertices: 150819(us)/159393(us)/1331, | ],
|
| | | | "10.0.7.142":9779 exec/total/vertices: 129589(us)/137649(us)/1310, | "type": 8
|
| | | | "10.0.7.92":9779 exec/total/vertices: 148675(us)/158667(us)/1379, | },
|
| | | | "10.0.7.100":9779 exec/total/vertices: 146083(us)/155448(us)/1305, | {
|
| | | | total_rpc_time: 171972(us) | "props": [
|
| | | | "10.0.7.89":9779 exec/total/vertices: 134598(us)/140936(us)/1415, | "_dst",
|
| | | | } | "_type",
|
| | | | { | "_rank"
|
| | | | ver: 3, rows: 439300, execTime: 22287us, totalTime: 1313485us | ],
|
| | | | storage_detail: {GetNeighborsNode:5813538(us),HashJoinNode:5765338(us),RelNode:5815198(us),SingleEdgeNode:5747447(us)} | "type": 6
|
| | | | "10.0.7.93":9779 exec/total/vertices: 1168882(us)/1223324(us)/11041, | },
|
| | | | "10.0.7.89":9779 exec/total/vertices: 1155649(us)/1196535(us)/10901, | {
|
| | | | "10.0.7.92":9779 exec/total/vertices: 1109186(us)/1153860(us)/10942, | "props": [
|
| | | | "10.0.7.142":9779 exec/total/vertices: 1029007(us)/1075543(us)/11061, | "_dst",
|
| | | | "10.0.7.100":9779 exec/total/vertices: 1201273(us)/1255532(us)/11018, | "_type",
|
| | | | total_rpc_time: 1291176(us) | "_rank"
|
| | | | "10.0.7.95":9779 exec/total/vertices: 1154702(us)/1205242(us)/11108, | ],
|
| | | | } | "type": 7
|
| | | | { | },
|
| | | | ver: 4, rows: 2169568, execTime: 73265us, totalTime: 4372360us | {
|
| | | | total_rpc_time: 4299066(us) | "props": [
|
| | | | "10.0.7.95":9779 exec/total/vertices: 3591425(us)/3797658(us)/35501, | "_dst",
|
| | | | storage_detail: {GetNeighborsNode:15973325(us),HashJoinNode:15790565(us),RelNode:15977855(us),SingleEdgeNode:15736586(us)} | "_type",
|
| | | | "10.0.7.93":9779 exec/total/vertices: 3931124(us)/4138709(us)/35359, | "_rank"
|
| | | | "10.0.7.92":9779 exec/total/vertices: 3696592(us)/3909380(us)/35655, | ],
|
| | | | "10.0.7.142":9779 exec/total/vertices: 3287892(us)/3496840(us)/35136, | "type": 9
|
| | | | "10.0.7.89":9779 exec/total/vertices: 3279175(us)/3474221(us)/35300, | },
|
| | | | "10.0.7.100":9779 exec/total/vertices: 3900756(us)/4110543(us)/35366, | {
|
| | | | } | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 10
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 12
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": 11
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -8
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -6
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -7
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -9
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -10
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -12
|
| | | | | },
|
| | | | | {
|
| | | | | "props": [
|
| | | | | "_dst",
|
| | | | | "_type",
|
| | | | | "_rank"
|
| | | | | ],
|
| | | | | "type": -11
|
| | | | | }
|
| | | | | ]
|
| | | | | statProps:
|
| | | | | exprs:
|
| | | | | random: false
|
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
| 0 | Start | | ver: 0, rows: 0, execTime: 0us, totalTime: 12us | outputVar: {
|
| | | | | "colNames": [],
|
| | | | | "type": "DATASET",
|
| | | | | "name": "__Start_0"
|
| | | | | }
|
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------
Thu, 01 Sep 2022 16:44:09 CST