补充一下stats和语句的profile
(root@nebula) [Twitter2010wp]> show stats
+---------+------------+------------+
| Type | Name | Count |
+---------+------------+------------+
| "Tag" | "Person" | 41652230 |
| "Edge" | "Know" | 1468365182 |
| "Space" | "vertices" | 41652230 |
| "Space" | "edges" | 1468365182 |
+---------+------------+------------+
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| id | name | dependencies | profiling data | operator info |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 10 | Aggregate | 9 | ver: 0, rows: 1, execTime: 3654us, totalTime: 3654us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "COUNT($-.id)" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Aggregate_10" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Aggregate_9 |
| | | | | groupKeys: [ |
| | | | | "$-.id" |
| | | | | ] |
| | | | | groupItems: [ |
| | | | | { |
| | | | | "expr": "COUNT($-.id)" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 9 | Aggregate | 8 | ver: 0, rows: 17236, execTime: 24661us, totalTime: 24664us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "id" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Aggregate_9" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __DataCollect_8 |
| | | | | groupKeys: [ |
| | | | | "$-.vid" |
| | | | | ] |
| | | | | groupItems: [ |
| | | | | { |
| | | | | "expr": "1" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 8 | DataCollect | 7 | ver: 0, rows: 18014, execTime: 2332us, totalTime: 2337us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "vid" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__DataCollect_8" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "vid" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Project_6" |
| | | | | } |
| | | | | ] |
| | | | | kind: M TO N |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 7 | Loop | 0 | ver: 0, rows: 1, execTime: 16us, totalTime: 18us | outputVar: [ |
| | | | ver: 1, rows: 1, execTime: 9us, totalTime: 9us | { |
| | | | ver: 2, rows: 1, execTime: 4us, totalTime: 4us | "colNames": [], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Loop_7" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: |
| | | | | condition: ((++($__VAR_1)<=2) AND (($__GetNeighbors_2==__EMPTY__) OR (size($__GetNeighbors_2)!=0))) |
| | | | | loopBody: 6 |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 6 | Project | 5 | ver: 0, rows: 104, execTime: 69us, totalTime: 70us | branch: true, nodeId: 7 |
| | | | ver: 1, rows: 17910, execTime: 4512us, totalTime: 4514us | |
| | | | | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "vid" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Project_6" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Filter_5 |
| | | | | columns: [ |
| | | | | "Know._dst AS vid" |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 5 | Filter | 4 | ver: 0, rows: 0, execTime: 827us, totalTime: 829us | outputVar: [ |
| | | | ver: 1, rows: 0, execTime: 43333us, totalTime: 43335us | { |
| | | | | "colNames": [], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Filter_5" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __GetNeighbors_2 |
| | | | | condition: ((Know._dst!=21415375) AND (Know.level==5)) |
| | | | | isStable: false |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 4 | Dedup | 3 | ver: 0, rows: 1000, execTime: 325us, totalTime: 326us | outputVar: [ |
| | | | ver: 1, rows: 143001, execTime: 27528us, totalTime: 27531us | { |
| | | | | "colNames": [], |
| | | | | "type": "DATASET", |
| | | | | "name": "__VAR_0" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Project_3 |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 3 | Project | 2 | ver: 0, rows: 1000, execTime: 613us, totalTime: 614us | outputVar: [ |
| | | | ver: 1, rows: 179294, execTime: 42764us, totalTime: 42767us | { |
| | | | | "colNames": [ |
| | | | | "_vid" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Project_3" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __GetNeighbors_2 |
| | | | | columns: [ |
| | | | | "*._dst AS _vid" |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 2 | GetNeighbors | 1 | { | outputVar: [ |
| | | | ver: 0, rows: 0, execTime: 72us, totalTime: 3665us | { |
| | | | storage_detail: {GetNeighborsNode:1564(us),HashJoinNode:347(us),RelNode:1565(us),SingleEdgeNode:343(us)} | "colNames": [], |
| | | | total_rpc_time: 3558(us) | "type": "DATASET", |
| | | | "192.168.20.71":9779 exec/total/vertices: 1688(us)/3265(us)/1, | "name": "__GetNeighbors_2" |
| | | | } | } |
| | | | { | ] |
| | | | ver: 1, rows: 0, execTime: 401us, totalTime: 163705us | inputVar: __VAR_0 |
| | | | storage_detail: {GetNeighborsNode:92323(us),HashJoinNode:14489(us),RelNode:92368(us),SingleEdgeNode:14309(us)} | space: 5 |
| | | | total_rpc_time: 163268(us) | dedup: false |
| | | | "192.168.20.71":9779 exec/total/vertices: 93012(us)/162216(us)/1000, | limit: -1 |
| | | | } | filter: |
| | | | | orderBy: [] |
| | | | | src: COLUMN[0] |
| | | | | edgeTypes: [] |
| | | | | edgeDirection: OUT_EDGE |
| | | | | vertexProps: |
| | | | | edgeProps: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "_dst", |
| | | | | "level" |
| | | | | ], |
| | | | | "type": "7" |
| | | | | } |
| | | | | ] |
| | | | | statProps: |
| | | | | exprs: |
| | | | | random: false |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 1 | Start | | ver: 0, rows: 0, execTime: 0us, totalTime: 21us | outputVar: [ |
| | | | ver: 1, rows: 0, execTime: 0us, totalTime: 18us | { |
| | | | | "colNames": [], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Start_1" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
| 0 | Start | | ver: 0, rows: 0, execTime: 0us, totalTime: 24us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Start_0" |
| | | | | } |
| | | | | ] |
-----+--------------+--------------+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------