(root@nebula) [sf0_1]> profile MATCH (s)-[e:WORK_AT]->(d) where id(s)==512 and e.workFrom>2004 return e
+-----------------------------------------+
| e |
+-----------------------------------------+
| [:WORK_AT 512->912 @0 {workFrom: 2005}] |
| [:WORK_AT 512->929 @0 {workFrom: 2005}] |
+-----------------------------------------+
Got 2 rows (time spent 2.055ms/17.153334ms)
Execution Plan (optimize time 402 us)
-----+----------------+--------------+------------------------------------+----------------------------------
| id | name | dependencies | profiling data | operator info |
-----+----------------+--------------+------------------------------------+----------------------------------
| 13 | Project | 12 | { | outputVar: { |
| | | | "execTime": "6(us)", | "colNames": [ |
| | | | "rows": 2, | "e" |
| | | | "totalTime": "7(us)", | ], |
| | | | "version": 0 | "type": "DATASET", |
| | | | } | "name": "__Project_8" |
| | | | | } |
| | | | | inputVar: __Filter_9 |
| | | | | columns: [ |
| | | | | "$-.e[0]" |
| | | | | ] |
-----+----------------+--------------+------------------------------------+----------------------------------
| 12 | AppendVertices | 15 | { | outputVar: { |
| | | | "execTime": "80(us)", | "colNames": [ |
| | | | "resp[0]": { | "s", |
| | | | "exec": "201(us)", | "e", |
| | | | "host": "192.168.15.31:10055", | "d" |
| | | | "total": "534(us)" | ], |
| | | | }, | "type": "DATASET", |
| | | | "rows": 2, | "name": "__Filter_9" |
| | | | "totalTime": "607(us)", | } |
| | | | "total_rpc": "567(us)", | inputVar: __Filter_11 |
| | | | "version": 0 | space: 2 |
| | | | } | dedup: true |
| | | | | limit: -1 |
| | | | | filter: |
| | | | | orderBy: [] |
| | | | | src: none_direct_dst($-.e,$-.s) |
| | | | | props: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 8 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 7 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 9 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 4 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 10 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 6 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 3 |
| | | | | }, |
| | | | | { |
| | | | | "props": [ |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 5 |
| | | | | } |
| | | | | ] |
| | | | | exprs: |
| | | | | vertex_filter: |
| | | | | if_track_previous_path: true |
-----+----------------+--------------+------------------------------------+----------------------------------
| 15 | Filter | 16 | { | outputVar: { |
| | | | "execTime": "7(us)", | "colNames": [ |
| | | | "rows": 2, | "s", |
| | | | "totalTime": "10(us)", | "e" |
| | | | "version": 0 | ], |
| | | | } | "type": "DATASET", |
| | | | | "name": "__Filter_11" |
| | | | | } |
| | | | | inputVar: __Traverse_14 |
| | | | | condition: (id($-.s)==512) |
| | | | | isStable: false |
-----+----------------+--------------+------------------------------------+----------------------------------
| 16 | Traverse | 2 | | outputVar: { |
| | | | | "colNames": [ |
| | | | | "s", |
| | | | | "e" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Traverse_14" |
| | | | | } |
| | | | | inputVar: __Dedup_2 |
| | | | | space: 2 |
| | | | | dedup: true |
| | | | | limit: -1 |
| | | | | filter: (WORK_AT.workFrom>2004) |
| | | | | orderBy: [] |
| | | | | src: $-._vid |
| | | | | edgeTypes: [] |
| | | | | edgeDirection: OUT_EDGE |
| | | | | vertexProps: |
| | | | | edgeProps: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "_src", |
| | | | | "_type", |
| | | | | "_rank", |
| | | | | "_dst", |
| | | | | "workFrom" |
| | | | | ], |
| | | | | "type": 23 |
| | | | | } |
| | | | | ] |
| | | | | statProps: |
| | | | | exprs: |
| | | | | random: false |
| | | | | steps: 1..1 |
| | | | | vertex filter: |
| | | | | edge filter: |
| | | | | if_track_previous_path: false |
| | | | | first step filter: |
| | | | | tag filter: |
-----+----------------+--------------+------------------------------------+----------------------------------
| 2 | Dedup | 1 | { | outputVar: { |
| | | | "execTime": "4(us)", | "colNames": [ |
| | | | "rows": 1, | "_vid" |
| | | | "totalTime": "4(us)", | ], |
| | | | "version": 0 | "type": "DATASET", |
| | | | } | "name": "__Dedup_2" |
| | | | | } |
| | | | | inputVar: __VAR_0 |
-----+----------------+--------------+------------------------------------+----------------------------------
| 1 | PassThrough | 3 | { | outputVar: { |
| | | | "execTime": "4(us)", | "colNames": [ |
| | | | "rows": 0, | "_vid" |
| | | | "totalTime": "7(us)", | ], |
| | | | "version": 0 | "type": "DATASET", |
| | | | } | "name": "__VAR_0" |
| | | | | } |
| | | | | inputVar: |
-----+----------------+--------------+------------------------------------+----------------------------------
| 3 | Start | | { | outputVar: { |
| | | | "execTime": "0(us)", | "colNames": [], |
| | | | "rows": 0, | "type": "DATASET", |
| | | | "totalTime": "17(us)", | "name": "__Start_3" |
| | | | "version": 0 | } |
| | | | } | |
-----+----------------+--------------+------------------------------------+----------------------------------
Fri, 14 Apr 2023 15:13:27 CST
Your Environments (required)
3.5.0-ent rc https://github.com/vesoft-inc/nebula-ent/commit/cc57afc0a052ae73063cefe2678cf9de736ec6cd
graph: 192.168.15.31:10065
space: sf0_1
nebula-console version Git: , Build Time: 2023-02-06T05:22:07+0000
How To Reproduce(required)
Expected behavior
Display the profiling data of the Travers operator