nebula 版本:2.0GA
部署方式(单机 ):集群 50台
是否为线上版本:N
硬件信息:
磁盘: SATA 8T*12快盘
CPU: Intel® Xeon® CPU E5-2630 v4 @ 2.20GHz (40core)
内存信息 125g
顶点:8百亿
边:9百亿
- 问题的具体描述
测试MATCH 在limit查询场景特别慢,查询数据范围在5w条,现在limit返回1000,查询时间在MATCH:1.9s,go limit 0.25s,go limit fetch 0.064s
MATCH LIMIT
(a@nebula) [sec_graph]> profile match (v)-[e:subdomain]->(v2) where id(v)=='70f914f5e82f7de736efe2f25c259607' with id(v2) as id limit 1000 return count(*);
+----------+
| COUNT(*) |
+----------+
| 1000 |
+----------+
Got 1 rows (time spent 1894660/1894479 us)
GO LIMIT
(a@nebula) [sec_graph]> profile GO 1 STEPS FROM '70f914f5e82f7de736efe2f25c259607' OVER subdomain BIDIRECT yield $$.domain.name|limit 1000|yield count(*)
+----------+
| COUNT(*) |
+----------+
| 1000 |
+----------+
Got 1 rows (time spent 250324/250809 us)
GO LIMIT FETCH
(a@nebula) [sec_graph]> profile GO 1 STEPS FROM '70f914f5e82f7de736efe2f25c259607' OVER subdomain BIDIRECT yield subdomain._dst as vid|limit 1000|fetch prop on * $-.vid|yield count(*)
+----------+
| COUNT(*) |
+----------+
| 1000 |
+----------+
Got 1 rows (time spent 63300/63762 us)
MATCH查询时间在秒级以上,相较于GO查询时间太长。希望能进行相应优化,nGQL稍微复杂点的查询场景不易编写,比如查询顶点扩展的所有类型边和顶点属性。
希望的优化点:
- LIMIT能够下沉到GetNeighbors阶段
- MATCH能根据RETURN的属性过滤掉不需要的属性字段,减少中间传输数据量
- 优化下InnerJoin,减少不必要操作
执行计划:
MATCH LIMIT
(a@nebula) [sec_graph]> profile match (v)-[e:subdomain]->(v2) where id(v)=='70f914f5e82f7de736efe2f25c259607' with id(v2) as id limit 1000 return count(*);
+----------+
| COUNT(*) |
+----------+
| 1000 |
+----------+
Got 1 rows (time spent 1894660/1894479 us)
Execution Plan (optimize time 85 us)
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| id | name | dependencies | profiling data | operator info |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 17 | Aggregate | 16 | ver: 0, rows: 1, execTime: 214us, totalTime: 215us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "COUNT(*)" |
| | | | | ], |
| | | | | "name": "__Aggregate_17", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Limit_16 |
| | | | | groupKeys: [] |
| | | | | groupItems: [ |
| | | | | { |
| | | | | "expr": "COUNT(*)" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 16 | Limit | 15 | ver: 0, rows: 1000, execTime: 2833us, totalTime: 2834us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "id" |
| | | | | ], |
| | | | | "name": "__Limit_16", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Project_15 |
| | | | | offset: 0 |
| | | | | count: 1000 |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 15 | Project | 14 | ver: 0, rows: 50730, execTime: 43776us, totalTime: 43779us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "id" |
| | | | | ], |
| | | | | "name": "__Project_15", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Filter_14 |
| | | | | columns: [ |
| | | | | "id($v2)" |
| | | | | ] |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 14 | Filter | 13 | ver: 0, rows: 50730, execTime: 35418us, totalTime: 35424us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "v", |
| | | | | "e", |
| | | | | "v2", |
| | | | | "__COL_0" |
| | | | | ], |
| | | | | "name": "__Filter_14", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Filter_13 |
| | | | | condition: (id($v)=="70f914f5e82f7de736efe2f25c259607") |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 13 | Filter | 12 | ver: 0, rows: 50730, execTime: 76894us, totalTime: 76897us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "v", |
| | | | | "e", |
| | | | | "v2", |
| | | | | "__COL_0" |
| | | | | ], |
| | | | | "name": "__Filter_13", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Project_12 |
| | | | | condition: (hasSameEdgeInPath($-.__COL_0)==false) |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 12 | Project | 11 | ver: 0, rows: 50730, execTime: 604512us, totalTime: 604518us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "v", |
| | | | | "e", |
| | | | | "v2", |
| | | | | "__COL_0" |
| | | | | ], |
| | | | | "name": "__Project_12", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __InnerJoin_11 |
| | | | | columns: [ |
| | | | | "startNode($-._path_0) AS v", |
| | | | | "relationships($-._path_0)[0] AS e", |
| | | | | "startNode($-._path_1) AS v2", |
| | | | | "PathBuild[PathBuild[$-._path_0,$-._path_1]] AS __COL_0" |
| | | | | ] |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 11 | InnerJoin | 10 | ver: 0, rows: 50730, execTime: 289764us, totalTime: 289769us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "_path_0", |
| | | | | "_path_1" |
| | | | | ], |
| | | | | "name": "__InnerJoin_11", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: { |
| | | | | "rightVar": { |
| | | | | "__Project_10": "0" |
| | | | | }, |
| | | | | "leftVar": { |
| | | | | "__Filter_6": "0" |
| | | | | } |
| | | | | } |
| | | | | hashKeys: [ |
| | | | | "endNode($-._path)._vid" |
| | | | | ] |
| | | | | probeKeys: [ |
| | | | | "startNode($-._path)._vid" |
| | | | | ] |
| | | | | kind: InnerJoin |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 10 | Project | 19 | ver: 0, rows: 50730, execTime: 76149us, totalTime: 76153us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "_path" |
| | | | | ], |
| | | | | "name": "__Project_10", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __GetVertices_9 |
| | | | | columns: [ |
| | | | | "PathBuild[VERTEX]" |
| | | | | ] |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 19 | GetVertices | 6 | { | outputVar: [ |
| | | | ver: 0, rows: 50730, execTime: 134696us, totalTime: 185916us | { |
| | | | "10.251.11.133":9779 exec/total: 52956(us)/55034(us) | "colNames": [], |
| | | | "10.251.11.113":9779 exec/total: 11686(us)/13480(us) | "name": "__GetVertices_9", |
| | | | total_rpc: 92315(us) | "type": "DATASET" |
| | | | "10.251.11.168":9779 exec/total: 21063(us)/23612(us) | } |
| | | | "10.251.11.145":9779 exec/total: 19603(us)/22565(us) | ] |
| | | | "10.251.11.142":9779 exec/total: 20115(us)/23165(us) | inputVar: __Filter_6 |
| | | | "10.251.11.147":9779 exec/total: 6517(us)/7884(us) | space: 1 |
| | | | "10.251.11.174":9779 exec/total: 14996(us)/17310(us) | dedup: true |
| | | | "10.251.11.143":9779 exec/total: 13760(us)/16573(us) | limit: 9223372036854775807 |
| | | | "10.251.11.171":9779 exec/total: 12945(us)/15490(us) | filter: |
| | | | "10.251.11.139":9779 exec/total: 16520(us)/19432(us) | orderBy: [] |
| | | | "10.251.11.180":9779 exec/total: 28257(us)/32181(us) | src: endNode($-._path)._vid |
| | | | "10.251.11.149":9779 exec/total: 29696(us)/33502(us) | props: [ |
| | | | "10.251.11.172":9779 exec/total: 12264(us)/15250(us) | { |
| | | | "10.251.11.169":9779 exec/total: 15651(us)/18461(us) | "props": [ |
| | | | "10.251.11.165":9779 exec/total: 16080(us)/18413(us) | "name", |
| | | | "10.251.11.111":9779 exec/total: 20751(us)/23758(us) | "_tag" |
| | | | "10.251.11.179":9779 exec/total: 14278(us)/16720(us) | ], |
| | | | "10.251.11.141":9779 exec/total: 9824(us)/11582(us) | "tagId": 2 |
| | | | "10.251.11.167":9779 exec/total: 12532(us)/14180(us) | }, |
| | | | "10.251.11.132":9779 exec/total: 25062(us)/28589(us) | { |
| | | | "10.251.11.178":9779 exec/total: 16853(us)/19338(us) | "props": [ |
| | | | "10.251.11.176":9779 exec/total: 26711(us)/29519(us) | "name", |
| | | | "10.251.11.137":9779 exec/total: 21105(us)/23491(us) | "_tag" |
| | | | "10.251.11.135":9779 exec/total: 33359(us)/36636(us) | ], |
| | | | "10.251.11.110":9779 exec/total: 12629(us)/15055(us) | "tagId": 3 |
| | | | "10.251.11.148":9779 exec/total: 24458(us)/27376(us) | } |
| | | | "10.251.11.131":9779 exec/total: 28942(us)/32241(us) | ] |
| | | | "10.251.11.136":9779 exec/total: 17495(us)/19256(us) | exprs: [] |
| | | | "10.251.11.181":9779 exec/total: 5463(us)/6766(us) | |
| | | | "10.251.11.177":9779 exec/total: 10636(us)/12278(us) | |
| | | | "10.251.11.175":9779 exec/total: 16794(us)/19277(us) | |
| | | | "10.251.11.144":9779 exec/total: 17571(us)/20978(us) | |
| | | | "10.251.11.146":9779 exec/total: 18100(us)/21358(us) | |
| | | | "10.251.11.170":9779 exec/total: 12551(us)/14786(us) | |
| | | | "10.251.11.134":9779 exec/total: 16682(us)/20655(us) | |
| | | | "10.251.11.109":9779 exec/total: 20421(us)/23012(us) | |
| | | | "10.251.11.164":9779 exec/total: 25478(us)/28996(us) | |
| | | | "10.251.11.138":9779 exec/total: 29683(us)/32857(us) | |
| | | | "10.251.11.140":9779 exec/total: 24742(us)/28005(us) | |
| | | | "10.251.11.117":9779 exec/total: 13276(us)/15397(us) | |
| | | | "10.251.11.114":9779 exec/total: 7495(us)/9684(us) | |
| | | | "10.251.11.118":9779 exec/total: 6096(us)/7549(us) | |
| | | | "10.251.11.173":9779 exec/total: 18639(us)/22393(us) | |
| | | | "10.251.11.108":9779 exec/total: 12786(us)/14100(us) | |
| | | | "10.251.11.166":9779 exec/total: 20256(us)/22935(us) | |
| | | | "10.251.11.130":9779 exec/total: 18742(us)/21468(us) | |
| | | | "10.251.11.116":9779 exec/total: 12725(us)/15238(us) | |
| | | | "10.251.11.115":9779 exec/total: 20641(us)/24810(us) | |
| | | | "10.251.11.163":9779 exec/total: 8042(us)/10094(us) | |
| | | | "10.251.11.112":9779 exec/total: 14835(us)/17718(us) | |
| | | | } | |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 6 | Filter | 5 | ver: 0, rows: 50740, execTime: 84699us, totalTime: 84702us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "_path" |
| | | | | ], |
| | | | | "name": "__Filter_6", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Project_5 |
| | | | | condition: (length($-._path)>=1) |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 5 | Project | 21 | ver: 0, rows: 50740, execTime: 291642us, totalTime: 291647us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "_path" |
| | | | | ], |
| | | | | "name": "__Project_5", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __GetNeighbors_4 |
| | | | | columns: [ |
| | | | | "PathBuild[VERTEX,EDGE] AS _path" |
| | | | | ] |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 21 | GetNeighbors | 1 | { | outputVar: [ |
| | | | ver: 0, rows: 0, execTime: 92us, totalTime: 180067us | { |
| | | | "10.251.11.109":9779 exec/total/vertices: 100681(us)/179814(us)/1, | "colNames": [], |
| | | | total_rpc_time: 179929(us) | "name": "__GetNeighbors_4", |
| | | | } | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __VAR_1 |
| | | | | space: 1 |
| | | | | dedup: true |
| | | | | limit: -1 |
| | | | | filter: |
| | | | | orderBy: [] |
| | | | | src: $__VAR_1._vid |
| | | | | edgeTypes: [] |
| | | | | edgeDirection: OUT_EDGE |
| | | | | vertexProps: [] |
| | | | | edgeProps: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "_src", |
| | | | | "_type", |
| | | | | "_rank", |
| | | | | "_dst", |
| | | | | "count", |
| | | | | "updatetime", |
| | | | | "label", |
| | | | | "first_seen", |
| | | | | "type", |
| | | | | "last_seen" |
| | | | | ], |
| | | | | "type": "4" |
| | | | | } |
| | | | | ] |
| | | | | statProps: |
| | | | | exprs: |
| | | | | random: false |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 1 | PassThrough | 0 | ver: 0, rows: 0, execTime: 2us, totalTime: 3us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "_vid" |
| | | | | ], |
| | | | | "name": "__VAR_1", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
| 0 | Start | | ver: 0, rows: 0, execTime: 1us, totalTime: 50us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [], |
| | | | | "name": "__Start_0", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+--------------------------------------------------------------------+-------------------------------------------------------------
GO LIMIT
a@nebula) [sec_graph]> profile GO 1 STEPS FROM '70f914f5e82f7de736efe2f25c259607' OVER subdomain BIDIRECT yield $$.domain.name|limit 1000|yield count(*)
+----------+
| COUNT(*) |
+----------+
| 1000 |
+----------+
Got 1 rows (time spent 250324/250809 us)
Execution Plan (optimize time 43 us)
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| id | name | dependencies | profiling data | operator info |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| 8 | Aggregate | 7 | ver: 0, rows: 1, execTime: 204us, totalTime: 205us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "COUNT(*)" |
| | | | | ], |
| | | | | "name": "__Aggregate_8", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Limit_7 |
| | | | | groupKeys: [] |
| | | | | groupItems: [ |
| | | | | { |
| | | | | "expr": "COUNT(*)" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| 7 | Limit | 6 | ver: 0, rows: 1000, execTime: 2720us, totalTime: 2722us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "$$.domain.name" |
| | | | | ], |
| | | | | "name": "__Limit_7", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Project_6 |
| | | | | offset: 0 |
| | | | | count: 1000 |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| 6 | Project | 5 | ver: 0, rows: 50740, execTime: 8250us, totalTime: 8251us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "$$.domain.name" |
| | | | | ], |
| | | | | "name": "__Project_6", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __LeftJoin_5 |
| | | | | columns: [ |
| | | | | "$-.__COL_0" |
| | | | | ] |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| 5 | LeftJoin | 4 | ver: 0, rows: 50740, execTime: 63314us, totalTime: 63318us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "__COL_1", |
| | | | | "__COL_0", |
| | | | | "__COL_2" |
| | | | | ], |
| | | | | "name": "__LeftJoin_5", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: { |
| | | | | "rightVar": { |
| | | | | "__Project_4": "0" |
| | | | | }, |
| | | | | "leftVar": { |
| | | | | "__Project_2": "0" |
| | | | | } |
| | | | | } |
| | | | | hashKeys: [ |
| | | | | "$__Project_2.__COL_1" |
| | | | | ] |
| | | | | probeKeys: [ |
| | | | | "$__Project_4.__COL_2" |
| | | | | ] |
| | | | | kind: LeftJoin |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| 4 | Project | 3 | ver: 0, rows: 50730, execTime: 24186us, totalTime: 24190us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "__COL_0", |
| | | | | "__COL_2" |
| | | | | ], |
| | | | | "name": "__Project_4", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __GetVertices_3 |
| | | | | columns: [ |
| | | | | "$$.domain.name AS __COL_0", |
| | | | | "$__GetVertices_3._vid AS __COL_2" |
| | | | | ] |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| 3 | GetVertices | 2 | { | outputVar: [ |
| | | | ver: 0, rows: 50730, execTime: 70334us, totalTime: 77932us | { |
| | | | "10.251.11.177":9779 exec/total: 1279(us)/2629(us) | "colNames": [], |
| | | | "10.251.11.141":9779 exec/total: 2707(us)/4689(us) | "name": "__GetVertices_3", |
| | | | "10.251.11.113":9779 exec/total: 2102(us)/3812(us) | "type": "DATASET" |
| | | | "10.251.11.173":9779 exec/total: 3809(us)/6605(us) | } |
| | | | "10.251.11.176":9779 exec/total: 2791(us)/8959(us) | ] |
| | | | "10.251.11.180":9779 exec/total: 4991(us)/11137(us) | inputVar: __Project_2 |
| | | | "10.251.11.111":9779 exec/total: 2786(us)/10720(us) | space: 1 |
| | | | "10.251.11.143":9779 exec/total: 2863(us)/5275(us) | dedup: true |
| | | | "10.251.11.135":9779 exec/total: 2853(us)/10324(us) | limit: 9223372036854775807 |
| | | | "10.251.11.110":9779 exec/total: 2002(us)/4577(us) | filter: |
| | | | "10.251.11.133":9779 exec/total: 2234(us)/4094(us) | orderBy: [] |
| | | | "10.251.11.115":9779 exec/total: 3729(us)/7817(us) | src: $__Project_2.__COL_1 |
| | | | "10.251.11.140":9779 exec/total: 3617(us)/8363(us) | props: [ |
| | | | "10.251.11.146":9779 exec/total: 3408(us)/7768(us) | {} |
| | | | "10.251.11.112":9779 exec/total: 3433(us)/7639(us) | ] |
| | | | "10.251.11.109":9779 exec/total: 4580(us)/12046(us) | exprs: [] |
| | | | "10.251.11.170":9779 exec/total: 1992(us)/4273(us) | |
| | | | "10.251.11.175":9779 exec/total: 2448(us)/5156(us) | |
| | | | "10.251.11.118":9779 exec/total: 979(us)/2712(us) | |
| | | | "10.251.11.181":9779 exec/total: 894(us)/2082(us) | |
| | | | "10.251.11.149":9779 exec/total: 4733(us)/10003(us) | |
| | | | "10.251.11.139":9779 exec/total: 3067(us)/7123(us) | |
| | | | "10.251.11.168":9779 exec/total: 2733(us)/5603(us) | |
| | | | "10.251.11.134":9779 exec/total: 2797(us)/9395(us) | |
| | | | "10.251.11.172":9779 exec/total: 2820(us)/5369(us) | |
| | | | "10.251.11.166":9779 exec/total: 2411(us)/5241(us) | |
| | | | "10.251.11.165":9779 exec/total: 3135(us)/10174(us) | |
| | | | "10.251.11.108":9779 exec/total: 1661(us)/3096(us) | |
| | | | "10.251.11.132":9779 exec/total: 3909(us)/7932(us) | |
| | | | total_rpc: 50262(us) | |
| | | | "10.251.11.164":9779 exec/total: 3446(us)/6690(us) | |
| | | | "10.251.11.178":9779 exec/total: 2943(us)/10516(us) | |
| | | | "10.251.11.117":9779 exec/total: 4089(us)/5847(us) | |
| | | | "10.251.11.136":9779 exec/total: 1957(us)/4307(us) | |
| | | | "10.251.11.163":9779 exec/total: 1718(us)/3129(us) | |
| | | | "10.251.11.167":9779 exec/total: 1883(us)/3586(us) | |
| | | | "10.251.11.171":9779 exec/total: 2159(us)/5744(us) | |
| | | | "10.251.11.116":9779 exec/total: 2173(us)/5503(us) | |
| | | | "10.251.11.179":9779 exec/total: 3013(us)/6657(us) | |
| | | | "10.251.11.142":9779 exec/total: 3870(us)/7819(us) | |
| | | | "10.251.11.145":9779 exec/total: 3406(us)/7805(us) | |
| | | | "10.251.11.114":9779 exec/total: 1219(us)/2673(us) | |
| | | | "10.251.11.144":9779 exec/total: 3520(us)/8167(us) | |
| | | | "10.251.11.138":9779 exec/total: 4020(us)/9091(us) | |
| | | | "10.251.11.148":9779 exec/total: 5123(us)/10638(us) | |
| | | | "10.251.11.137":9779 exec/total: 2539(us)/4710(us) | |
| | | | "10.251.11.169":9779 exec/total: 2840(us)/6722(us) | |
| | | | "10.251.11.147":9779 exec/total: 1348(us)/2487(us) | |
| | | | "10.251.11.174":9779 exec/total: 3367(us)/7593(us) | |
| | | | "10.251.11.131":9779 exec/total: 4099(us)/8484(us) | |
| | | | "10.251.11.130":9779 exec/total: 3494(us)/8248(us) | |
| | | | } | |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| 2 | Project | 1 | ver: 0, rows: 50740, execTime: 18419us, totalTime: 18422us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "__COL_1" |
| | | | | ], |
| | | | | "name": "__Project_2", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __GetNeighbors_1 |
| | | | | columns: [ |
| | | | | "*._dst AS __COL_1" |
| | | | | ] |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| 1 | GetNeighbors | 0 | { | outputVar: [ |
| | | | ver: 0, rows: 0, execTime: 75us, totalTime: 54769us | { |
| | | | "10.251.11.109":9779 exec/total/vertices: 33410(us)/54548(us)/1, | "colNames": [], |
| | | | total_rpc_time: 54665(us) | "name": "__GetNeighbors_1", |
| | | | } | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __VAR_1 |
| | | | | space: 1 |
| | | | | dedup: false |
| | | | | limit: -1 |
| | | | | filter: |
| | | | | orderBy: [] |
| | | | | src: $__VAR_1._vid |
| | | | | edgeTypes: [] |
| | | | | edgeDirection: OUT_EDGE |
| | | | | vertexProps: |
| | | | | edgeProps: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "_dst" |
| | | | | ], |
| | | | | "type": "4" |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_dst" |
| | | | | ], |
| | | | | "type": "-4" |
| | | | | } |
| | | | | ] |
| | | | | statProps: |
| | | | | exprs: |
| | | | | random: false |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
| 0 | Start | | ver: 0, rows: 0, execTime: 1us, totalTime: 33us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [], |
| | | | | "name": "__Start_0", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+------------------------------------------------------------------+---------------------------------------
GO LIMIT FETCH
(a@nebula) [sec_graph]> profile GO 1 STEPS FROM '70f914f5e82f7de736efe2f25c259607' OVER subdomain BIDIRECT yield subdomain._dst as vid|limit 1000|fetch prop on * $-.vid|yield count(*)
+----------+
| COUNT(*) |
+----------+
| 1000 |
+----------+
Got 1 rows (time spent 63300/63762 us)
Execution Plan (optimize time 1067 us)
-----+--------------+--------------+----------------------------------------------------------------+----------------------------------
| id | name | dependencies | profiling data | operator info |
-----+--------------+--------------+----------------------------------------------------------------+----------------------------------
| 6 | Aggregate | 5 | ver: 0, rows: 1, execTime: 200us, totalTime: 200us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "COUNT(*)" |
| | | | | ], |
| | | | | "name": "__Aggregate_6", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Project_5 |
| | | | | groupKeys: [] |
| | | | | groupItems: [ |
| | | | | { |
| | | | | "expr": "COUNT(*)" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------+----------------------------------
| 5 | Project | 4 | ver: 0, rows: 1000, execTime: 1141us, totalTime: 1142us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "vertices_" |
| | | | | ], |
| | | | | "name": "__Project_5", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __GetVertices_4 |
| | | | | columns: [ |
| | | | | "VERTEX AS vertices_" |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------+----------------------------------
| 4 | GetVertices | 7 | { | outputVar: [ |
| | | | ver: 0, rows: 1000, execTime: 2374us, totalTime: 21634us | { |
| | | | "10.251.11.109":9779 exec/total: 1025(us)/1433(us) | "colNames": [ |
| | | | total_rpc: 21004(us) | "_vid", |
| | | | "10.251.11.167":9779 exec/total: 608(us)/994(us) | "domain.name", |
| | | | "10.251.11.132":9779 exec/total: 1668(us)/4020(us) | "domain._tag", |
| | | | "10.251.11.131":9779 exec/total: 1916(us)/4154(us) | "ip.name", |
| | | | "10.251.11.141":9779 exec/total: 716(us)/4083(us) | "ip._tag" |
| | | | "10.251.11.176":9779 exec/total: 1096(us)/3964(us) | ], |
| | | | "10.251.11.140":9779 exec/total: 1706(us)/4302(us) | "name": "__GetVertices_4", |
| | | | "10.251.11.137":9779 exec/total: 774(us)/1460(us) | "type": "DATASET" |
| | | | "10.251.11.177":9779 exec/total: 572(us)/935(us) | } |
| | | | "10.251.11.173":9779 exec/total: 1260(us)/4190(us) | ] |
| | | | "10.251.11.113":9779 exec/total: 428(us)/1410(us) | inputVar: __Limit_3 |
| | | | "10.251.11.144":9779 exec/total: 1120(us)/3999(us) | space: 1 |
| | | | "10.251.11.175":9779 exec/total: 1382(us)/4033(us) | dedup: false |
| | | | "10.251.11.115":9779 exec/total: 1551(us)/4177(us) | limit: 9223372036854775807 |
| | | | "10.251.11.148":9779 exec/total: 5384(us)/6088(us) | filter: |
| | | | "10.251.11.165":9779 exec/total: 1176(us)/4042(us) | orderBy: [] |
| | | | "10.251.11.108":9779 exec/total: 1261(us)/4020(us) | src: $-.vid |
| | | | "10.251.11.130":9779 exec/total: 2952(us)/4220(us) | props: [ |
| | | | "10.251.11.179":9779 exec/total: 951(us)/4210(us) | { |
| | | | "10.251.11.181":9779 exec/total: 510(us)/867(us) | "props": [ |
| | | | "10.251.11.169":9779 exec/total: 1073(us)/4181(us) | "name", |
| | | | "10.251.11.142":9779 exec/total: 1260(us)/4149(us) | "_tag" |
| | | | "10.251.11.178":9779 exec/total: 945(us)/4402(us) | ], |
| | | | "10.251.11.134":9779 exec/total: 1216(us)/4200(us) | "tagId": 2 |
| | | | "10.251.11.133":9779 exec/total: 18172(us)/19585(us) | }, |
| | | | "10.251.11.118":9779 exec/total: 302(us)/723(us) | { |
| | | | "10.251.11.145":9779 exec/total: 2916(us)/4403(us) | "props": [ |
| | | | "10.251.11.147":9779 exec/total: 322(us)/950(us) | "name", |
| | | | "10.251.11.117":9779 exec/total: 1638(us)/4233(us) | "_tag" |
| | | | "10.251.11.174":9779 exec/total: 883(us)/1345(us) | ], |
| | | | "10.251.11.149":9779 exec/total: 1509(us)/4416(us) | "tagId": 3 |
| | | | "10.251.11.143":9779 exec/total: 1513(us)/4391(us) | } |
| | | | "10.251.11.116":9779 exec/total: 1053(us)/3915(us) | ] |
| | | | "10.251.11.172":9779 exec/total: 1008(us)/4153(us) | exprs: [] |
| | | | "10.251.11.168":9779 exec/total: 1369(us)/4193(us) | |
| | | | "10.251.11.136":9779 exec/total: 3710(us)/4388(us) | |
| | | | "10.251.11.180":9779 exec/total: 1340(us)/4060(us) | |
| | | | "10.251.11.166":9779 exec/total: 1445(us)/4045(us) | |
| | | | "10.251.11.139":9779 exec/total: 830(us)/4151(us) | |
| | | | "10.251.11.111":9779 exec/total: 1644(us)/4201(us) | |
| | | | "10.251.11.114":9779 exec/total: 593(us)/1012(us) | |
| | | | "10.251.11.170":9779 exec/total: 722(us)/3823(us) | |
| | | | "10.251.11.146":9779 exec/total: 981(us)/3884(us) | |
| | | | "10.251.11.164":9779 exec/total: 1993(us)/4181(us) | |
| | | | "10.251.11.171":9779 exec/total: 1093(us)/3570(us) | |
| | | | "10.251.11.163":9779 exec/total: 458(us)/827(us) | |
| | | | "10.251.11.110":9779 exec/total: 762(us)/1197(us) | |
| | | | "10.251.11.135":9779 exec/total: 2125(us)/4163(us) | |
| | | | "10.251.11.138":9779 exec/total: 1446(us)/4340(us) | |
| | | | "10.251.11.112":9779 exec/total: 811(us)/3941(us) | |
| | | | } | |
-----+--------------+--------------+----------------------------------------------------------------+----------------------------------
| 7 | Limit | 8 | ver: 0, rows: 1000, execTime: 1us, totalTime: 2us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "vid" |
| | | | | ], |
| | | | | "name": "__Limit_3", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Project_2 |
| | | | | offset: 0 |
| | | | | count: 1000 |
-----+--------------+--------------+----------------------------------------------------------------+----------------------------------
| 8 | Project | 9 | ver: 0, rows: 1000, execTime: 31396us, totalTime: 31401us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "vid" |
| | | | | ], |
| | | | | "name": "__Project_2", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __GetNeighbors_1 |
| | | | | columns: [ |
| | | | | "subdomain._dst AS vid" |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------+----------------------------------
| 9 | GetNeighbors | 0 | { | outputVar: [ |
| | | | ver: 0, rows: 0, execTime: 46us, totalTime: 6958us | { |
| | | | "10.251.11.109":9779 exec/total/vertices: 5880(us)/6815(us)/1, | "colNames": [], |
| | | | total_rpc_time: 6888(us) | "name": "__GetNeighbors_1", |
| | | | } | "type": "DATASET" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __VAR_1 |
| | | | | space: 1 |
| | | | | dedup: false |
| | | | | limit: 1000 |
| | | | | filter: |
| | | | | orderBy: [] |
| | | | | src: $__VAR_1._vid |
| | | | | edgeTypes: [] |
| | | | | edgeDirection: OUT_EDGE |
| | | | | vertexProps: |
| | | | | edgeProps: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "_dst" |
| | | | | ], |
| | | | | "type": "4" |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_dst" |
| | | | | ], |
| | | | | "type": "-4" |
| | | | | } |
| | | | | ] |
| | | | | statProps: |
| | | | | exprs: |
| | | | | random: false |
-----+--------------+--------------+----------------------------------------------------------------+----------------------------------
| 0 | Start | | ver: 0, rows: 0, execTime: 1us, totalTime: 35us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [], |
| | | | | "name": "__Start_0", |
| | | | | "type": "DATASET" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------+----------------------------------