Got 20 rows (time spent 50.506286s/50.499417859s) Execution Plan (optimize time 254 us) -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | id | name | dependencies | profiling data | operator info | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 8 | Project | 9 | { | outputVar: { | | | | | "execTime": "155(us)", | "colNames": [ | | | | | "rows": 20, | "p" | | | | | "totalTime": "159(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]": "142(us)", | "colNames": [ | | | | | "buildAdjTime reverse step[2]": "1907(us)", | "_src", | | | | | "buildAdjTime reverse step[3]": "31447(us)", | "_edge", | | | | | "buildAdjTime reverse step[4]": "500069(us)", | "_dst" | | | | | "buildAdjTime reverse step[5]": "4129726(us)", | ], | | | | | "buildAdjTime step[1]": "179(us)", | "type": "DATASET", | | | | | "buildAdjTime step[2]": "3524(us)", | "name": "__Limit_7" | | | | | "buildAdjTime step[3]": "42049(us)", | } | | | | | "buildAdjTime step[4]": "503716(us)", | inputVar: { | | | | | "buildAdjTime step[5]": "3864277(us)", | "rightVar": "__Dedup_3", | | | | | "build_path_time": "40512617(us)", | "leftVar": "__Dedup_2" | | | | | "conjunct_path_time": "40512577(us)", | } | | | | | "execTime": "10712(us)", | noloop : false | | | | | "reverse step[1]": [ | withProp : false | | | | | { | steps: 10 | | | | | "exec": "585(us)", | filter: | | | | | "host": "172.21.120.3:9779", | stepFilter: | | | | | "storage_detail": { | offset: 0 | | | | | "GetNeighborsNode": "449(us)", | limit: 20 | | | | | "HashJoinNode": "407(us)", | vertexProps: | | | | | "RelNode": "449(us)", | edgeProps: [ | | | | | "SingleEdgeNode": "401(us)" | { | | | | | }, | "props": [ | | | | | "total": "10605(us)", | "_dst", | | | | | "vertices": 1 | "_rank", | | | | | } | "_type" | | | | | ], | ], | | | | | "reverse step[2]": [ | "type": -54 | | | | | { | }, | | | | | "exec": "3420(us)", | { | | | | | "host": "172.21.120.1:9779", | "props": [ | | | | | "storage_detail": { | "_dst", | | | | | "GetNeighborsNode": "3530(us)", | "_rank", | | | | | "HashJoinNode": "2969(us)", | "_type" | | | | | "RelNode": "3534(us)", | ], | | | | | "SingleEdgeNode": "2879(us)" | "type": -55 | | | | | }, | }, | | | | | "total": "4528(us)", | { | | | | | "vertices": 35 | "props": [ | | | | | }, | "_dst", | | | | | { | "_rank", | | | | | "exec": "2216(us)", | "_type" | | | | | "host": "172.21.120.3:9779", | ], | | | | | "storage_detail": { | "type": -57 | | | | | "GetNeighborsNode": "3197(us)", | }, | | | | | "HashJoinNode": "2426(us)", | { | | | | | "RelNode": "3200(us)", | "props": [ | | | | | "SingleEdgeNode": "2352(us)" | "_dst", | | | | | }, | "_rank", | | | | | "total": "4443(us)", | "_type" | | | | | "vertices": 24 | ], | | | | | } | "type": 54 | | | | | ], | }, | | | | | "reverse step[3]": [ | { | | | | | { | "props": [ | | | | | "exec": "10092(us)", | "_dst", | | | | | "host": "172.21.120.3:9779", | "_rank", | | | | | "storage_detail": { | "_type" | | | | | "GetNeighborsNode": "36612(us)", | ], | | | | | "HashJoinNode": "27435(us)", | "type": 55 | | | | | "RelNode": "36661(us)", | }, | | | | | "SingleEdgeNode": "26868(us)" | { | | | | | }, | "props": [ | | | | | "total": "19978(us)", | "_dst", | | | | | "vertices": 429 | "_rank", | | | | | }, | "_type" | | | | | { | ], | | | | | "exec": "38256(us)", | "type": 57 | | | | | "host": "172.21.120.1:9779", | } | | | | | "storage_detail": { | ] | | | | | "GetNeighborsNode": "124440(us)", | | | | | | "HashJoinNode": "41908(us)", | | | | | | "RelNode": "124499(us)", | | | | | | "SingleEdgeNode": "41237(us)" | | | | | | }, | | | | | | "total": "46219(us)", | | | | | | "vertices": 469 | | | | | | } | | | | | | ], | | | | | | "reverse step[4]": [ | | | | | | { | | | | | | "exec": "238282(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "2627271(us)", | | | | | | "HashJoinNode": "2153544(us)", | | | | | | "RelNode": "2628339(us)", | | | | | | "SingleEdgeNode": "2139528(us)" | | | | | | }, | | | | | | "total": "452188(us)", | | | | | | "vertices": 7513 | | | | | | }, | | | | | | { | | | | | | "exec": "293594(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "3596740(us)", | | | | | | "HashJoinNode": "2925897(us)", | | | | | | "RelNode": "3597714(us)", | | | | | | "SingleEdgeNode": "2916750(us)" | | | | | | }, | | | | | | "total": "483417(us)", | | | | | | "vertices": 7516 | | | | | | } | | | | | | ], | | | | | | "reverse step[5]": [ | | | | | | { | | | | | | "exec": "1428550(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "24298074(us)", | | | | | | "HashJoinNode": "19941769(us)", | | | | | | "RelNode": "24307993(us)", | | | | | | "SingleEdgeNode": "19741511(us)" | | | | | | }, | | | | | | "total": "3918316(us)", | | | | | | "vertices": 73105 | | | | | | }, | | | | | | { | | | | | | "exec": "2410111(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "36716104(us)", | | | | | | "HashJoinNode": "31337772(us)", | | | | | | "RelNode": "36789154(us)", | | | | | | "SingleEdgeNode": "30744186(us)" | | | | | | }, | | | | | | "total": "3936468(us)", | | | | | | "vertices": 71020 | | | | | | } | | | | | | ], | | | | | | "rows": 20, | | | | | | "step[1]": [ | | | | | | { | | | | | | "exec": "881(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "563(us)", | | | | | | "HashJoinNode": "490(us)", | | | | | | "RelNode": "564(us)", | | | | | | "SingleEdgeNode": "484(us)" | | | | | | }, | | | | | | "total": "1444(us)", | | | | | | "vertices": 1 | | | | | | } | | | | | | ], | | | | | | "step[2]": [ | | | | | | { | | | | | | "exec": "3450(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "6771(us)", | | | | | | "HashJoinNode": "4933(us)", | | | | | | "RelNode": "6786(us)", | | | | | | "SingleEdgeNode": "4796(us)" | | | | | | }, | | | | | | "total": "5191(us)", | | | | | | "vertices": 63 | | | | | | }, | | | | | | { | | | | | | "exec": "2127(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "3896(us)", | | | | | | "HashJoinNode": "2853(us)", | | | | | | "RelNode": "3904(us)", | | | | | | "SingleEdgeNode": "2754(us)" | | | | | | }, | | | | | | "total": "4646(us)", | | | | | | "vertices": 42 | | | | | | } | | | | | | ], | | | | | | "step[3]": [ | | | | | | { | | | | | | "exec": "21612(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "104010(us)", | | | | | | "HashJoinNode": "82705(us)", | | | | | | "RelNode": "104145(us)", | | | | | | "SingleEdgeNode": "81450(us)" | | | | | | }, | | | | | | "total": "63692(us)", | | | | | | "vertices": 1020 | | | | | | }, | | | | | | { | | | | | | "exec": "27234(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "166724(us)", | | | | | | "HashJoinNode": "138313(us)", | | | | | | "RelNode": "166863(us)", | | | | | | "SingleEdgeNode": "136911(us)" | | | | | | }, | | | | | | "total": "47245(us)", | | | | | | "vertices": 1026 | | | | | | } | | | | | | ], | | | | | | "step[4]": [ | | | | | | { | | | | | | "exec": "248519(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "3232692(us)", | | | | | | "HashJoinNode": "2687038(us)", | | | | | | "RelNode": "3233747(us)", | | | | | | "SingleEdgeNode": "2481467(us)" | | | | | | }, | | | | | | "total": "348480(us)", | | | | | | "vertices": 8233 | | | | | | }, | | | | | | { | | | | | | "exec": "210957(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "2955372(us)", | | | | | | "HashJoinNode": "2407490(us)", | | | | | | "RelNode": "2956647(us)", | | | | | | "SingleEdgeNode": "2384114(us)" | | | | | | }, | | | | | | "total": "326101(us)", | | | | | | "vertices": 8448 | | | | | | } | | | | | | ], | | | | | | "step[5]": [ | | | | | | { | | | | | | "exec": "2561835(us)", | | | | | | "host": "172.21.120.1:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "39280875(us)", | | | | | | "HashJoinNode": "32827320(us)", | | | | | | "RelNode": "39411699(us)", | | | | | | "SingleEdgeNode": "32204331(us)" | | | | | | }, | | | | | | "total": "3736857(us)", | | | | | | "vertices": 76706 | | | | | | }, | | | | | | { | | | | | | "exec": "1401102(us)", | | | | | | "host": "172.21.120.3:9779", | | | | | | "storage_detail": { | | | | | | "GetNeighborsNode": "23080330(us)", | | | | | | "HashJoinNode": "19729881(us)", | | | | | | "RelNode": "23123471(us)", | | | | | | "SingleEdgeNode": "19221962(us)" | | | | | | }, | | | | | | "total": "2593433(us)", | | | | | | "vertices": 73910 | | | | | | } | | | | | | ], | | | | | | "totalTime": "50505468(us)", | | | | | | "version": 0 | | | | | | } | | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 2 | Dedup | 1 | { | outputVar: { | | | | | "execTime": "9(us)", | "colNames": [ | | | | | "rows": 1, | "_vid" | | | | | "totalTime": "16(us)", | ], | | | | | "version": 0 | "type": "DATASET", | | | | | } | "name": "__Dedup_2" | | | | | | } | | | | | | inputVar: __VAR_0 | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 1 | PassThrough | 0 | { | outputVar: { | | | | | "execTime": "3(us)", | "colNames": [], | | | | | "rows": 0, | "type": "DATASET", | | | | | "totalTime": "4(us)", | "name": "__PassThrough_1" | | | | | "version": 0 | } | | | | | } | inputVar: | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 0 | Start | | { | outputVar: { | | | | | "execTime": "0(us)", | "colNames": [], | | | | | "rows": 0, | "type": "DATASET", | | | | | "totalTime": "18(us)", | "name": "__Start_0" | | | | | "version": 0 | } | | | | | } | | -----+-------------+--------------+--------------------------------------------------+------------------------------------------ | 3 | Dedup | 1 | { | outputVar: { | | | | | "execTime": "6(us)", | "colNames": [ | | | | | "rows": 1, | "_vid" | | | | | "totalTime": "7(us)", | ], | | | | | "version": 0 | "type": "DATASET", | | | | | } | "name": "__Dedup_3" | | | | | | } | | | | | | inputVar: __VAR_1 | -----+-------------+--------------+--------------------------------------------------+------------------------------------------