Got 200000 rows (time spent 51.349384s/1m49.63829961s) Execution Plan (optimize time 254 us) -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | id | name | dependencies | profiling data | operator info | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 8 | Project | 9 | { | outputVar: { | | | | | "execTime": "1201352(us)", | "colNames": [ | | | | | "rows": 200000, | "p" | | | | | "totalTime": "1201362(us)", | ], | | | | | "version": 0 | "type": "DATASET", | | | | | } | "name": "__Limit_6" | | | | | | } | | | | | | inputVar: __Limit_7 | | | | | | columns: [ | | | | | | "PathBuild[$-._src,$-._edge,$-._dst]" | | | | | | ] | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 9 | AllPaths | 2,3 | { | outputVar: { | | | | | "buildAdjTime reverse step[1]": "92(us)", | "colNames": [ | | | | | "buildAdjTime reverse step[2]": "1999(us)", | "_src", | | | | | "buildAdjTime reverse step[3]": "47445(us)", | "_edge", | | | | | "buildAdjTime reverse step[4]": "635768(us)", | "_dst" | | | | | "buildAdjTime reverse step[5]": "3925719(us)", | ], | | | | | "buildAdjTime step[1]": "164(us)", | "type": "DATASET", | | | | | "buildAdjTime step[2]": "3770(us)", | "name": "__Limit_7" | | | | | "buildAdjTime step[3]": "55306(us)", | } | | | | | "buildAdjTime step[4]": "649608(us)", | inputVar: { | | | | | "buildAdjTime step[5]": "3878170(us)", | "rightVar": "__Dedup_3", | | | | | "build_path_time": "40121646(us)", | "leftVar": "__Dedup_2" | | | | | "conjunct_path_time": "40121612(us)", | } | | | | | "execTime": "98(us)", | noloop : false | | | | | "reverse step[1]": [ | withProp : false | | | | | { | steps: 10 | | | | | "exec": "653(us)", | filter: | | | | | "host": "172.21.120.3:9779", | stepFilter: | | | | | "storage_detail": { | offset: 0 | | | | | "GetNeighborsNode": "236(us)", | limit: 200000 | | | | | "HashJoinNode": "178(us)", | vertexProps: | | | | | "RelNode": "236(us)", | edgeProps: [ | | | | | "SingleEdgeNode": "174(us)" | { | | | | | }, | "props": [ | | | | | "total": "1266(us)", | "_dst", | | | | | "vertices": 1 | "_rank", | | | | | } | "_type" | | | | | ], | ], | | | | | "reverse step[2]": [ | "type": -54 | | | | | { | }, | | | | | "exec": "1723(us)", | { | | | | | "host": "172.21.120.1:9779", | "props": [ | | | | | "storage_detail": { | "_dst", | | | | | "GetNeighborsNode": "3749(us)", | "_rank", | | | | | "HashJoinNode": "3192(us)", | "_type" | | | | | "RelNode": "3754(us)", | ], | | | | | "SingleEdgeNode": "3102(us)" | "type": -55 | | | | | }, | }, | | | | | "total": "2639(us)", | { | | | | | "vertices": 35 | "props": [ | | | | | }, | "_dst", | | | | | { | "_rank", | | | | | "exec": "1154(us)", | "_type" | | | | | "host": "172.21.120.3:9779", | ], | | | | | "storage_detail": { | "type": -57 | | | | | "GetNeighborsNode": "3105(us)", | }, | | | | | "HashJoinNode": "2330(us)", | { | | | | | "RelNode": "3107(us)", | "props": [ | | | | | "SingleEdgeNode": "2258(us)" | "_dst", | | | | | }, | "_rank", | | | | | "total": "2305(us)", | "_type" | | | | | "vertices": 24 | ], | | | | | } | "type": 54 | | | | | ], | }, | | | | | "reverse step[3]": [ | { | | | | | { | "props": [ | | | | | "exec": "10103(us)", | "_dst", | | | | | "host": "172.21.120.3:9779", | "_rank", | | | | | "storage_detail": { | "_type" | | | | | "GetNeighborsNode": "36975(us)", | ], | | | | | "HashJoinNode": "27604(us)", | "type": 55 | | | | | "RelNode": "37026(us)", | }, | | | | | "SingleEdgeNode": "27047(us)" | { | | | | | }, | "props": [ | | | | | "total": "34217(us)", | "_dst", | | | | | "vertices": 429 | "_rank", | | | | | }, | "_type" | | | | | { | ], | | | | | "exec": "14425(us)", | "type": 57 | | | | | "host": "172.21.120.1:9779", | } | | | | | "storage_detail": { | ] | | | | | "GetNeighborsNode": "67919(us)", | | | | | | "HashJoinNode": "51729(us)", | | | | | | "RelNode": "67975(us)", | | | | | | "SingleEdgeNode": "51079(us)" | | | | | | }, | | | | | | "total": "40324(us)", | | | | | | "vertices": 469 | | | | | | } | | | | | | ], | | | | | | "reverse step[4]": [ | | | | | | { | | | | | | "exec": "193911(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "2987437(us)", | | | | | | "HashJoinNode": "2411430(us)", | | | | | | "RelNode": "2988553(us)", | | | | | | "SingleEdgeNode": "2386206(us)" | | | | | | }, | | | | | | "total": "388040(us)", | | | | | | "vertices": 7513 | | | | | | }, | | | | | | { | | | | | | "exec": "264930(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "2527069(us)", | | | | | | "HashJoinNode": "2029135(us)", | | | | | | "RelNode": "2528090(us)", | | | | | | "SingleEdgeNode": "2019886(us)" | | | | | | }, | | | | | | "total": "489696(us)", | | | | | | "vertices": 7516 | | | | | | } | | | | | | ], | | | | | | "reverse step[5]": [ | | | | | | { | | | | | | "exec": "1450212(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "26139802(us)", | | | | | | "HashJoinNode": "20978234(us)", | | | | | | "RelNode": "26262994(us)", | | | | | | "SingleEdgeNode": "20568186(us)" | | | | | | }, | | | | | | "total": "3905424(us)", | | | | | | "vertices": 73105 | | | | | | }, | | | | | | { | | | | | | "exec": "2674101(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "41960359(us)", | | | | | | "HashJoinNode": "34854013(us)", | | | | | | "RelNode": "42173220(us)", | | | | | | "SingleEdgeNode": "34403300(us)" | | | | | | }, | | | | | | "total": "4100680(us)", | | | | | | "vertices": 71020 | | | | | | } | | | | | | ], | | | | | | "rows": 200000, | | | | | | "step[1]": [ | | | | | | { | | | | | | "exec": "699(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "263(us)", | | | | | | "HashJoinNode": "182(us)", | | | | | | "RelNode": "263(us)", | | | | | | "SingleEdgeNode": "176(us)" | | | | | | }, | | | | | | "total": "1237(us)", | | | | | | "vertices": 1 | | | | | | } | | | | | | ], | | | | | | "step[2]": [ | | | | | | { | | | | | | "exec": "2610(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "8357(us)", | | | | | | "HashJoinNode": "6660(us)", | | | | | | "RelNode": "8366(us)", | | | | | | "SingleEdgeNode": "6511(us)" | | | | | | }, | | | | | | "total": "9414(us)", | | | | | | "vertices": 63 | | | | | | }, | | | | | | { | | | | | | "exec": "1540(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "4521(us)", | | | | | | "HashJoinNode": "3442(us)", | | | | | | "RelNode": "4527(us)", | | | | | | "SingleEdgeNode": "3339(us)" | | | | | | }, | | | | | | "total": "5261(us)", | | | | | | "vertices": 42 | | | | | | } | | | | | | ], | | | | | | "step[3]": [ | | | | | | { | | | | | | "exec": "20584(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "100276(us)", | | | | | | "HashJoinNode": "87742(us)", | | | | | | "RelNode": "100400(us)", | | | | | | "SingleEdgeNode": "86544(us)" | | | | | | }, | | | | | | "total": "43901(us)", | | | | | | "vertices": 1020 | | | | | | }, | | | | | | { | | | | | | "exec": "29048(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "144874(us)", | | | | | | "HashJoinNode": "127960(us)", | | | | | | "RelNode": "145009(us)", | | | | | | "SingleEdgeNode": "126611(us)" | | | | | | }, | | | | | | "total": "49153(us)", | | | | | | "vertices": 1026 | | | | | | } | | | | | | ], | | | | | | "step[4]": [ | | | | | | { | | | | | | "exec": "211587(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "2198305(us)", | | | | | | "HashJoinNode": "1691859(us)", | | | | | | "RelNode": "2199400(us)", | | | | | | "SingleEdgeNode": "1626131(us)" | | | | | | }, | | | | | | "total": "335294(us)", | | | | | | "vertices": 8233 | | | | | | }, | | | | | | { | | | | | | "exec": "238810(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "3709712(us)", | | | | | | "HashJoinNode": "2694736(us)", | | | | | | "RelNode": "3710989(us)", | | | | | | "SingleEdgeNode": "2682415(us)" | | | | | | }, | | | | | | "total": "340761(us)", | | | | | | "vertices": 8448 | | | | | | } | | | | | | ], | | | | | | "step[5]": [ | | | | | | { | | | | | | "exec": "2949887(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "40283258(us)", | | | | | | "HashJoinNode": "31662108(us)", | | | | | | "RelNode": "40294125(us)", | | | | | | "SingleEdgeNode": "30977057(us)" | | | | | | }, | | | | | | "total": "3977373(us)", | | | | | | "vertices": 76706 | | | | | | }, | | | | | | { | | | | | | "exec": "1390833(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "25478322(us)", | | | | | | "HashJoinNode": "20769408(us)", | | | | | | "RelNode": "25488100(us)", | | | | | | "SingleEdgeNode": "20317651(us)" | | | | | | }, | | | | | | "total": "2877938(us)", | | | | | | "vertices": 73910 | | | | | | } | | | | | | ], | | | | | | "totalTime": "50007968(us)", | | | | | | "version": 0 | | | | | | } | | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 2 | Dedup | 1 | { | outputVar: { | | | | | "execTime": "8(us)", | "colNames": [ | | | | | "rows": 1, | "_vid" | | | | | "totalTime": "9(us)", | ], | | | | | "version": 0 | "type": "DATASET", | | | | | } | "name": "__Dedup_2" | | | | | | } | | | | | | inputVar: __VAR_0 | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 1 | PassThrough | 0 | { | outputVar: { | | | | | "execTime": "9(us)", | "colNames": [], | | | | | "rows": 0, | "type": "DATASET", | | | | | "totalTime": "26(us)", | "name": "__PassThrough_1" | | | | | "version": 0 | } | | | | | } | inputVar: | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 0 | Start | | { | outputVar: { | | | | | "execTime": "0(us)", | "colNames": [], | | | | | "rows": 0, | "type": "DATASET", | | | | | "totalTime": "50(us)", | "name": "__Start_0" | | | | | "version": 0 | } | | | | | } | | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 3 | Dedup | 1 | { | outputVar: { | | | | | "execTime": "4(us)", | "colNames": [ | | | | | "rows": 1, | "_vid" | | | | | "totalTime": "6(us)", | ], | | | | | "version": 0 | "type": "DATASET", | | | | | } | "name": "__Dedup_3" | | | | | | } | | | | | | inputVar: __VAR_1 | -----+-------------+--------------+--------------------------------------------------+------------------------------------------