-----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | id | name | dependencies | profiling data | operator info | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 16 | Project | 15 | ver: 0, rows: 3, execTime: 7us, totalTime: 8us | outputVar: [{"name":"__Project_16","colNames":["v1","v2"],"type":"DATASET"}] | | | | | | inputVar: __Filter_15 | | | | | | columns: ["$v1","$v2"] | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 15 | Filter | 14 | ver: 0, rows: 3, execTime: 8us, totalTime: 9us | outputVar: [{"name":"__Filter_15","colNames":["v1","e","v2","__COL_0"],"type":"DATASET"}] | | | | | | inputVar: __Project_14 | | | | | | condition: (hasSameEdgeInPath($-.__COL_0)==false) | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 14 | Project | 13 | ver: 0, rows: 3, execTime: 63us, totalTime: 64us | outputVar: [{"name":"__Project_14","colNames":["v1","e","v2","__COL_0"],"type":"DATASET"}] | | | | | | inputVar: __InnerJoin_13 | | | | | | columns: ["startNode($-._path_0) AS v1","relationships($-._path_0)[0] AS e","startNode($-._path_1) AS v2","PathBuild[PathBuild[$-._path_0,$-._path_1]] AS __COL_0"] | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 13 | InnerJoin | 12 | ver: 0, rows: 3, execTime: 38368us, totalTime: 38371us | outputVar: [{"name":"__InnerJoin_13","colNames":["_path_0","_path_1"],"type":"DATASET"}] | | | | | | inputVar: {"rightVar":{"__Project_12":"0"},"leftVar":{"__Filter_7":"0"}} | | | | | | hashKeys: ["endNode($-._path)._vid"] | | | | | | probeKeys: ["startNode($-._path)._vid"] | | | | | | kind: InnerJoin | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 12 | Project | 11 | ver: 0, rows: 3, execTime: 36us, totalTime: 38us | outputVar: [{"name":"__Project_12","colNames":["_path"],"type":"DATASET"}] | | | | | | inputVar: __Filter_11 | | | | | | columns: ["PathBuild[VERTEX]"] | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 11 | Filter | 19 | ver: 0, rows: 3, execTime: 29993us, totalTime: 29995us | outputVar: [{"name":"__Filter_11","colNames":[],"type":"DATASET"}] | | | | | | inputVar: __GetVertices_10 | | | | | | condition: (VERTEX.firstName=="Abbas") | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 19 | GetVertices | 7 | ver: 0, rows: 18766, execTime: 52423us, totalTime: 413098us | outputVar: [{"name":"__GetVertices_10","colNames":[],"type":"DATASET"}] | | | | | | inputVar: __Filter_7 | | | | | | space: 1 | | | | | | dedup: true | | | | | | limit: 9223372036854775807 | | | | | | filter: | | | | | | orderBy: [] | | | | | | src: endNode($-._path)._vid | | | | | | props: [{"props":["name","url","type","_tag"],"tagId":7},{"props":["type","name","url","_tag"],"tagId":6},{"props":["imageFile","creationDate","locationIP","browserUsed","language","content","length","_tag"],"tagId":5},{"props":["firstName","lastName","gender","birthday","creationDate","locationIP","browserUsed","_tag"],"tagId":4},{"props":["creationDate","locationIP","browserUsed","content","length","_tag"],"tagId":2},{"props":["title","creationDate","_tag"],"tagId":3},{"props":["name","url","_tag"],"tagId":8},{"props":["name","url","_tag"],"tagId":9}] | | | | | | exprs: [] | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7 | Filter | 6 | ver: 0, rows: 44291, execTime: 51740us, totalTime: 51742us | outputVar: [{"name":"__Filter_7","colNames":["_path"],"type":"DATASET"}] | | | | | | inputVar: __Project_6 | | | | | | condition: (length($-._path)>=1) | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6 | Project | 5 | ver: 0, rows: 44291, execTime: 138113us, totalTime: 138115us | outputVar: [{"name":"__Project_6","colNames":["_path"],"type":"DATASET"}] | | | | | | inputVar: __Filter_5 | | | | | | columns: ["PathBuild[VERTEX,EDGE] AS _path"] | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5 | Filter | 21 | ver: 0, rows: 0, execTime: 37863us, totalTime: 37865us | outputVar: [{"name":"__Filter_5","colNames":[],"type":"DATASET"}] | | | | | | inputVar: __GetNeighbors_4 | | | | | | condition: (VERTEX.firstName=="John") | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 21 | GetNeighbors | 17 | ver: 0, rows: 0, execTime: 1107us, totalTime: 77898us | outputVar: [{"name":"__GetNeighbors_4","colNames":[],"type":"DATASET"}] | | | | | | inputVar: __IndexScan_1 | | | | | | space: 1 | | | | | | dedup: true | | | | | | limit: -1 | | | | | | filter: | | | | | | orderBy: [] | | | | | | src: $_vid | | | | | | edgeTypes: [] | | | | | | edgeDirection: OUT_EDGE | | | | | | vertexProps: [] | | | | | | edgeProps: [{"props":["_src","_type","_rank","_dst","creationDate"],"type":"18"}] | | | | | | statProps: | | | | | | exprs: | | | | | | random: false | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 17 | IndexScan | 0 | ver: 0, rows: 1550, execTime: 0us, totalTime: 3779us | outputVar: [{"name":"__IndexScan_1","colNames":["_vid"],"type":"DATASET"}] | | | | | | inputVar: | | | | | | space: 1 | | | | | | dedup: false | | | | | | limit: 9223372036854775807 | | | | | | filter: | | | | | | orderBy: [] | | | | | | schemaId: 4 | | | | | | isEdge: false | | | | | | returnCols: ["_vid"] | | | | | | indexCtx: [{"columnHints":[{"endValue":"__EMPTY__","beginValue":"\"John","column":"firstName","scanType":"PREFIX"}],"index_id":26,"filter":""}] | -----+--------------+--------------+--------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | Start | | ver: 0, rows: 0, execTime: 1us, totalTime: 40us | outputVar: [{"name":"__Start_0","colNames":[],"type":"DATASET"}]