关于GO语句中limit无法和where condition组合使用的问题

[may11544]

nebula 版本：v3.4.0
部署方式：单机
安装方式：Docker
是否上生产环境：N

语句1：响应结果有20条

GO 1 to 6 STEPS FROM '172.16.33.1' OVER edge_attack where properties(edge).event_time<1679888603187 and properties(edge).event_time > 1679888501000 YIELD DISTINCT edge as s

语句2：无响应数据

GO 1 to 6 STEPS FROM '172.16.33.1' OVER edge_attack where properties(edge).event_time<1679888603187 and properties(edge).event_time > 1679888501000 YIELD DISTINCT edge as s limit [100,100,100,100,100,100]

语句3：响应数据有20条

GO 1 to 6 STEPS FROM '172.16.33.1' OVER edge_attack where properties(edge).event_time<1679888603187 and properties(edge).event_time > 1679888501000 YIELD DISTINCT edge as s limit [1000,100,100,100,100,100]

根据官网描述GO语句时随机选择n条边进行遍历 https://docs.nebula-graph.com.cn/3.4.0/3.ngql-guide/8.clauses-and-options/limit/ 不知道是否考虑了这个情况呢，目前看limit的作用应该是先于了where condition，这完全不符合常识。

需要profile的话我可以贴一下，不过目前看表象时这样的

[steam]

@may11544

需要profile的话我可以贴一下

来，把执行计划贴一下，省的等会还要时间来咨询相关信息。

[may11544]

好的

[may11544]

没有limit的执行计划

Execution Plan (optimize time 155 us)

-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
| id | name         | dependencies | profiling data                            | operator info                                                                                            |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  9 | DataCollect  | 8            | {                                         | outputVar: {                                                                                             |
|    |              |              |   "execTime": "250(us)",                  |   "colNames": [                                                                                          |
|    |              |              |   "rows": 20,                             |     "s"                                                                                                  |
|    |              |              |   "totalTime": "257(us)",                 |   ],                                                                                                     |
|    |              |              |   "version": 0                            |   "type": "DATASET",                                                                                     |
|    |              |              | }                                         |   "name": "__DataCollect_9"                                                                              |
|    |              |              |                                           | }                                                                                                        |
|    |              |              |                                           | inputVar: [                                                                                              |
|    |              |              |                                           |   {                                                                                                      |
|    |              |              |                                           |     "colNames": [                                                                                        |
|    |              |              |                                           |       "s"                                                                                                |
|    |              |              |                                           |     ],                                                                                                   |
|    |              |              |                                           |     "type": "DATASET",                                                                                   |
|    |              |              |                                           |     "name": "__Dedup_7"                                                                                  |
|    |              |              |                                           |   }                                                                                                      |
|    |              |              |                                           | ]                                                                                                        |
|    |              |              |                                           | distinct: true                                                                                           |
|    |              |              |                                           | kind: M TO N                                                                                             |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  8 | Loop         | 0            | [                                         | outputVar: {                                                                                             |
|    |              |              |   {                                       |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "15(us)",                 |   "type": "DATASET",                                                                                     |
|    |              |              |     "rows": 1,                            |   "name": "__Loop_8"                                                                                     |
|    |              |              |     "totalTime": "21(us)",                | }                                                                                                        |
|    |              |              |     "version": 0                          | inputVar:                                                                                                |
|    |              |              |   },                                      | condition: ((++($__VAR_1)<=6) AND (($__VAR_0==__EMPTY__) OR (size($__VAR_0)!=0)))                        |
|    |              |              |   {                                       | loopBody: 7                                                                                              |
|    |              |              |     "execTime": "11(us)",                 |                                                                                                          |
|    |              |              |     "rows": 1,                            |                                                                                                          |
|    |              |              |     "totalTime": "14(us)",                |                                                                                                          |
|    |              |              |     "version": 1                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "7(us)",                  |                                                                                                          |
|    |              |              |     "rows": 1,                            |                                                                                                          |
|    |              |              |     "totalTime": "8(us)",                 |                                                                                                          |
|    |              |              |     "version": 2                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "11(us)",                 |                                                                                                          |
|    |              |              |     "rows": 1,                            |                                                                                                          |
|    |              |              |     "totalTime": "13(us)",                |                                                                                                          |
|    |              |              |     "version": 3                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "9(us)",                  |                                                                                                          |
|    |              |              |     "rows": 1,                            |                                                                                                          |
|    |              |              |     "totalTime": "10(us)",                |                                                                                                          |
|    |              |              |     "version": 4                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "9(us)",                  |                                                                                                          |
|    |              |              |     "rows": 1,                            |                                                                                                          |
|    |              |              |     "totalTime": "11(us)",                |                                                                                                          |
|    |              |              |     "version": 5                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "98653(us)",              |                                                                                                          |
|    |              |              |     "rows": 1,                            |                                                                                                          |
|    |              |              |     "totalTime": "98664(us)",             |                                                                                                          |
|    |              |              |     "version": 6                          |                                                                                                          |
|    |              |              |   }                                       |                                                                                                          |
|    |              |              | ]                                         |                                                                                                          |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  7 | Dedup        | 6            | [                                         | branch: true, nodeId: 8                                                                                  |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "20(us)",                 | outputVar: {                                                                                             |
|    |              |              |     "rows": 20,                           |   "colNames": [                                                                                          |
|    |              |              |     "totalTime": "21(us)",                |     "s"                                                                                                  |
|    |              |              |     "version": 0                          |   ],                                                                                                     |
|    |              |              |   },                                      |   "type": "DATASET",                                                                                     |
|    |              |              |   {                                       |   "name": "__Dedup_7"                                                                                    |
|    |              |              |     "execTime": "3(us)",                  | }                                                                                                        |
|    |              |              |     "rows": 0,                            | inputVar: __Project_6                                                                                    |
|    |              |              |     "totalTime": "5(us)",                 |                                                                                                          |
|    |              |              |     "version": 1                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "24(us)",                 |                                                                                                          |
|    |              |              |     "rows": 20,                           |                                                                                                          |
|    |              |              |     "totalTime": "27(us)",                |                                                                                                          |
|    |              |              |     "version": 2                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "10(us)",                 |                                                                                                          |
|    |              |              |     "rows": 20,                           |                                                                                                          |
|    |              |              |     "totalTime": "12(us)",                |                                                                                                          |
|    |              |              |     "version": 3                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "20(us)",                 |                                                                                                          |
|    |              |              |     "rows": 20,                           |                                                                                                          |
|    |              |              |     "totalTime": "24(us)",                |                                                                                                          |
|    |              |              |     "version": 4                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "35(us)",                 |                                                                                                          |
|    |              |              |     "rows": 20,                           |                                                                                                          |
|    |              |              |     "totalTime": "39(us)",                |                                                                                                          |
|    |              |              |     "version": 5                          |                                                                                                          |
|    |              |              |   }                                       |                                                                                                          |
|    |              |              | ]                                         |                                                                                                          |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  6 | Project      | 5            | [                                         | outputVar: {                                                                                             |
|    |              |              |   {                                       |   "colNames": [                                                                                          |
|    |              |              |     "execTime": "268(us)",                |     "s"                                                                                                  |
|    |              |              |     "rows": 20,                           |   ],                                                                                                     |
|    |              |              |     "totalTime": "272(us)",               |   "type": "DATASET",                                                                                     |
|    |              |              |     "version": 0                          |   "name": "__Project_6"                                                                                  |
|    |              |              |   },                                      | }                                                                                                        |
|    |              |              |   {                                       | inputVar: __Filter_5                                                                                     |
|    |              |              |     "execTime": "24(us)",                 | columns: [                                                                                               |
|    |              |              |     "rows": 0,                            |   "EDGE AS s"                                                                                            |
|    |              |              |     "totalTime": "25(us)",                | ]                                                                                                        |
|    |              |              |     "version": 1                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "289(us)",                |                                                                                                          |
|    |              |              |     "rows": 20,                           |                                                                                                          |
|    |              |              |     "totalTime": "294(us)",               |                                                                                                          |
|    |              |              |     "version": 2                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "245(us)",                |                                                                                                          |
|    |              |              |     "rows": 20,                           |                                                                                                          |
|    |              |              |     "totalTime": "249(us)",               |                                                                                                          |
|    |              |              |     "version": 3                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "269(us)",                |                                                                                                          |
|    |              |              |     "rows": 20,                           |                                                                                                          |
|    |              |              |     "totalTime": "273(us)",               |                                                                                                          |
|    |              |              |     "version": 4                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "317(us)",                |                                                                                                          |
|    |              |              |     "rows": 20,                           |                                                                                                          |
|    |              |              |     "totalTime": "320(us)",               |                                                                                                          |
|    |              |              |     "version": 5                          |                                                                                                          |
|    |              |              |   }                                       |                                                                                                          |
|    |              |              | ]                                         |                                                                                                          |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  5 | Filter       | 4            | [                                         | outputVar: {                                                                                             |
|    |              |              |   {                                       |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "151450(us)",             |   "type": "DATASET",                                                                                     |
|    |              |              |     "rows": 24441,                        |   "name": "__Filter_5"                                                                                   |
|    |              |              |     "totalTime": "151454(us)",            | }                                                                                                        |
|    |              |              |     "version": 0                          | inputVar: __GetNeighbors_2                                                                               |
|    |              |              |   },                                      | condition: ((properties(EDGE).event_time<1679888603187) AND (properties(EDGE).event_time>1679888501000)) |
|    |              |              |   {                                       | isStable: false                                                                                          |
|    |              |              |     "execTime": "7446(us)",               |                                                                                                          |
|    |              |              |     "rows": 1210,                         |                                                                                                          |
|    |              |              |     "totalTime": "7449(us)",              |                                                                                                          |
|    |              |              |     "version": 1                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "187260(us)",             |                                                                                                          |
|    |              |              |     "rows": 25167,                        |                                                                                                          |
|    |              |              |     "totalTime": "187266(us)",            |                                                                                                          |
|    |              |              |     "version": 2                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "192273(us)",             |                                                                                                          |
|    |              |              |     "rows": 25651,                        |                                                                                                          |
|    |              |              |     "totalTime": "192279(us)",            |                                                                                                          |
|    |              |              |     "version": 3                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "192135(us)",             |                                                                                                          |
|    |              |              |     "rows": 25651,                        |                                                                                                          |
|    |              |              |     "totalTime": "192142(us)",            |                                                                                                          |
|    |              |              |     "version": 4                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "176318(us)",             |                                                                                                          |
|    |              |              |     "rows": 25651,                        |                                                                                                          |
|    |              |              |     "totalTime": "176324(us)",            |                                                                                                          |
|    |              |              |     "version": 5                          |                                                                                                          |
|    |              |              |   }                                       |                                                                                                          |
|    |              |              | ]                                         |                                                                                                          |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  4 | Dedup        | 3            | [                                         | outputVar: {                                                                                             |
|    |              |              |   {                                       |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "3378(us)",               |   "type": "DATASET",                                                                                     |
|    |              |              |     "rows": 7,                            |   "name": "__VAR_0"                                                                                      |
|    |              |              |     "totalTime": "3381(us)",              | }                                                                                                        |
|    |              |              |     "version": 0                          | inputVar: __Project_3                                                                                    |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "170(us)",                |                                                                                                          |
|    |              |              |     "rows": 4,                            |                                                                                                          |
|    |              |              |     "totalTime": "172(us)",               |                                                                                                          |
|    |              |              |     "version": 1                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "3847(us)",               |                                                                                                          |
|    |              |              |     "rows": 8,                            |                                                                                                          |
|    |              |              |     "totalTime": "3851(us)",              |                                                                                                          |
|    |              |              |     "version": 2                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "4360(us)",               |                                                                                                          |
|    |              |              |     "rows": 8,                            |                                                                                                          |
|    |              |              |     "totalTime": "4362(us)",              |                                                                                                          |
|    |              |              |     "version": 3                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "3940(us)",               |                                                                                                          |
|    |              |              |     "rows": 8,                            |                                                                                                          |
|    |              |              |     "totalTime": "3944(us)",              |                                                                                                          |
|    |              |              |     "version": 4                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "3944(us)",               |                                                                                                          |
|    |              |              |     "rows": 8,                            |                                                                                                          |
|    |              |              |     "totalTime": "3948(us)",              |                                                                                                          |
|    |              |              |     "version": 5                          |                                                                                                          |
|    |              |              |   }                                       |                                                                                                          |
|    |              |              | ]                                         |                                                                                                          |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  3 | Project      | 2            | [                                         | outputVar: {                                                                                             |
|    |              |              |   {                                       |   "colNames": [                                                                                          |
|    |              |              |     "execTime": "12628(us)",              |     "_vid"                                                                                               |
|    |              |              |     "rows": 24441,                        |   ],                                                                                                     |
|    |              |              |     "totalTime": "12634(us)",             |   "type": "DATASET",                                                                                     |
|    |              |              |     "version": 0                          |   "name": "__Project_3"                                                                                  |
|    |              |              |   },                                      | }                                                                                                        |
|    |              |              |   {                                       | inputVar: __GetNeighbors_2                                                                               |
|    |              |              |     "execTime": "779(us)",                | columns: [                                                                                               |
|    |              |              |     "rows": 1210,                         |   "*._dst AS _vid"                                                                                       |
|    |              |              |     "totalTime": "782(us)",               | ]                                                                                                        |
|    |              |              |     "version": 1                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "13092(us)",              |                                                                                                          |
|    |              |              |     "rows": 25167,                        |                                                                                                          |
|    |              |              |     "totalTime": "13098(us)",             |                                                                                                          |
|    |              |              |     "version": 2                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "15730(us)",              |                                                                                                          |
|    |              |              |     "rows": 25651,                        |                                                                                                          |
|    |              |              |     "totalTime": "15735(us)",             |                                                                                                          |
|    |              |              |     "version": 3                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "13715(us)",              |                                                                                                          |
|    |              |              |     "rows": 25651,                        |                                                                                                          |
|    |              |              |     "totalTime": "13720(us)",             |                                                                                                          |
|    |              |              |     "version": 4                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "11914(us)",              |                                                                                                          |
|    |              |              |     "rows": 25651,                        |                                                                                                          |
|    |              |              |     "totalTime": "11919(us)",             |                                                                                                          |
|    |              |              |     "version": 5                          |                                                                                                          |
|    |              |              |   }                                       |                                                                                                          |
|    |              |              | ]                                         |                                                                                                          |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  2 | GetNeighbors | 1            | [                                         | outputVar: {                                                                                             |
|    |              |              |   {                                       |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "86(us)",                 |   "type": "DATASET",                                                                                     |
|    |              |              |     "resp[0]": {                          |   "name": "__GetNeighbors_2"                                                                             |
|    |              |              |       "exec": "127380(us)",               | }                                                                                                        |
|    |              |              |       "host": "storaged:9779",            | inputVar: __VAR_0                                                                                        |
|    |              |              |       "storage_detail": {                 | space: 330                                                                                               |
|    |              |              |         "GetNeighborsNode": "127167(us)", | dedup: false                                                                                             |
|    |              |              |         "HashJoinNode": "147(us)",        | limit: -1                                                                                                |
|    |              |              |         "RelNode": "127168(us)",          | filter:                                                                                                  |
|    |              |              |         "SingleEdgeNode": "145(us)"       | orderBy: []                                                                                              |
|    |              |              |       },                                  | src: COLUMN[0]                                                                                           |
|    |              |              |       "total": "211490(us)",              | edgeTypes: []                                                                                            |
|    |              |              |       "vertices": 1                       | edgeDirection: OUT_EDGE                                                                                  |
|    |              |              |     },                                    | vertexProps:                                                                                             |
|    |              |              |     "rows": 24441,                        | edgeProps: [                                                                                             |
|    |              |              |     "totalTime": "211687(us)",            |   {                                                                                                      |
|    |              |              |     "total_rpc_time": "211578(us)",       |     "props": [                                                                                           |
|    |              |              |     "version": 0                          |       "_dst",                                                                                            |
|    |              |              |   },                                      |       "_rank",                                                                                           |
|    |              |              |   {                                       |       "_src",                                                                                            |
|    |              |              |     "execTime": "70(us)",                 |       "_type",                                                                                           |
|    |              |              |     "resp[0]": {                          |       "app_proto",                                                                                       |
|    |              |              |       "exec": "6527(us)",                 |       "attacker_port",                                                                                   |
|    |              |              |       "host": "storaged:9779",            |       "event_time",                                                                                      |
|    |              |              |       "storage_detail": {                 |       "flow_id",                                                                                         |
|    |              |              |         "GetNeighborsNode": "6072(us)",   |       "name",                                                                                            |
|    |              |              |         "HashJoinNode": "284(us)",        |       "phase",                                                                                           |
|    |              |              |         "RelNode": "6073(us)",            |       "proto",                                                                                           |
|    |              |              |         "SingleEdgeNode": "278(us)"       |       "result",                                                                                          |
|    |              |              |       },                                  |       "severity",                                                                                        |
|    |              |              |       "total": "11586(us)",               |       "tag",                                                                                             |
|    |              |              |       "vertices": 7                       |       "tool",                                                                                            |
|    |              |              |     },                                    |       "victim_port"                                                                                      |
|    |              |              |     "rows": 1210,                         |     ],                                                                                                   |
|    |              |              |     "totalTime": "11719(us)",             |     "type": 334                                                                                          |
|    |              |              |     "total_rpc_time": "11633(us)",        |   }                                                                                                      |
|    |              |              |     "version": 1                          | ]                                                                                                        |
|    |              |              |   },                                      | statProps:                                                                                               |
|    |              |              |   {                                       | exprs:                                                                                                   |
|    |              |              |     "execTime": "66(us)",                 | random: false                                                                                            |
|    |              |              |     "resp[0]": {                          |                                                                                                          |
|    |              |              |       "exec": "132362(us)",               |                                                                                                          |
|    |              |              |       "host": "storaged:9779",            |                                                                                                          |
|    |              |              |       "storage_detail": {                 |                                                                                                          |
|    |              |              |         "GetNeighborsNode": "132249(us)", |                                                                                                          |
|    |              |              |         "HashJoinNode": "91(us)",         |                                                                                                          |
|    |              |              |         "RelNode": "132250(us)",          |                                                                                                          |
|    |              |              |         "SingleEdgeNode": "87(us)"        |                                                                                                          |
|    |              |              |       },                                  |                                                                                                          |
|    |              |              |       "total": "223137(us)",              |                                                                                                          |
|    |              |              |       "vertices": 4                       |                                                                                                          |
|    |              |              |     },                                    |                                                                                                          |
|    |              |              |     "rows": 25167,                        |                                                                                                          |
|    |              |              |     "totalTime": "223303(us)",            |                                                                                                          |
|    |              |              |     "total_rpc_time": "223220(us)",       |                                                                                                          |
|    |              |              |     "version": 2                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "73(us)",                 |                                                                                                          |
|    |              |              |     "resp[0]": {                          |                                                                                                          |
|    |              |              |       "exec": "123305(us)",               |                                                                                                          |
|    |              |              |       "host": "storaged:9779",            |                                                                                                          |
|    |              |              |       "storage_detail": {                 |                                                                                                          |
|    |              |              |         "GetNeighborsNode": "122866(us)", |                                                                                                          |
|    |              |              |         "HashJoinNode": "311(us)",        |                                                                                                          |
|    |              |              |         "RelNode": "122868(us)",          |                                                                                                          |
|    |              |              |         "SingleEdgeNode": "304(us)"       |                                                                                                          |
|    |              |              |       },                                  |                                                                                                          |
|    |              |              |       "total": "212276(us)",              |                                                                                                          |
|    |              |              |       "vertices": 8                       |                                                                                                          |
|    |              |              |     },                                    |                                                                                                          |
|    |              |              |     "rows": 25651,                        |                                                                                                          |
|    |              |              |     "totalTime": "212435(us)",            |                                                                                                          |
|    |              |              |     "total_rpc_time": "212342(us)",       |                                                                                                          |
|    |              |              |     "version": 3                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "81(us)",                 |                                                                                                          |
|    |              |              |     "resp[0]": {                          |                                                                                                          |
|    |              |              |       "exec": "129866(us)",               |                                                                                                          |
|    |              |              |       "host": "storaged:9779",            |                                                                                                          |
|    |              |              |       "storage_detail": {                 |                                                                                                          |
|    |              |              |         "GetNeighborsNode": "129383(us)", |                                                                                                          |
|    |              |              |         "HashJoinNode": "378(us)",        |                                                                                                          |
|    |              |              |         "RelNode": "129384(us)",          |                                                                                                          |
|    |              |              |         "SingleEdgeNode": "364(us)"       |                                                                                                          |
|    |              |              |       },                                  |                                                                                                          |
|    |              |              |       "total": "209017(us)",              |                                                                                                          |
|    |              |              |       "vertices": 8                       |                                                                                                          |
|    |              |              |     },                                    |                                                                                                          |
|    |              |              |     "rows": 25651,                        |                                                                                                          |
|    |              |              |     "totalTime": "209195(us)",            |                                                                                                          |
|    |              |              |     "total_rpc_time": "209092(us)",       |                                                                                                          |
|    |              |              |     "version": 4                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "103(us)",                |                                                                                                          |
|    |              |              |     "resp[0]": {                          |                                                                                                          |
|    |              |              |       "exec": "123943(us)",               |                                                                                                          |
|    |              |              |       "host": "storaged:9779",            |                                                                                                          |
|    |              |              |       "storage_detail": {                 |                                                                                                          |
|    |              |              |         "GetNeighborsNode": "123474(us)", |                                                                                                          |
|    |              |              |         "HashJoinNode": "307(us)",        |                                                                                                          |
|    |              |              |         "RelNode": "123476(us)",          |                                                                                                          |
|    |              |              |         "SingleEdgeNode": "300(us)"       |                                                                                                          |
|    |              |              |       },                                  |                                                                                                          |
|    |              |              |       "total": "201797(us)",              |                                                                                                          |
|    |              |              |       "vertices": 8                       |                                                                                                          |
|    |              |              |     },                                    |                                                                                                          |
|    |              |              |     "rows": 25651,                        |                                                                                                          |
|    |              |              |     "totalTime": "201997(us)",            |                                                                                                          |
|    |              |              |     "total_rpc_time": "201867(us)",       |                                                                                                          |
|    |              |              |     "version": 5                          |                                                                                                          |
|    |              |              |   }                                       |                                                                                                          |
|    |              |              | ]                                         |                                                                                                          |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  1 | Start        |              | [                                         | outputVar: {                                                                                             |
|    |              |              |   {                                       |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "0(us)",                  |   "type": "DATASET",                                                                                     |
|    |              |              |     "rows": 0,                            |   "name": "__Start_1"                                                                                    |
|    |              |              |     "totalTime": "14(us)",                | }                                                                                                        |
|    |              |              |     "version": 0                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "0(us)",                  |                                                                                                          |
|    |              |              |     "rows": 0,                            |                                                                                                          |
|    |              |              |     "totalTime": "11(us)",                |                                                                                                          |
|    |              |              |     "version": 1                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "0(us)",                  |                                                                                                          |
|    |              |              |     "rows": 0,                            |                                                                                                          |
|    |              |              |     "totalTime": "10(us)",                |                                                                                                          |
|    |              |              |     "version": 2                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "0(us)",                  |                                                                                                          |
|    |              |              |     "rows": 0,                            |                                                                                                          |
|    |              |              |     "totalTime": "12(us)",                |                                                                                                          |
|    |              |              |     "version": 3                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "0(us)",                  |                                                                                                          |
|    |              |              |     "rows": 0,                            |                                                                                                          |
|    |              |              |     "totalTime": "11(us)",                |                                                                                                          |
|    |              |              |     "version": 4                          |                                                                                                          |
|    |              |              |   },                                      |                                                                                                          |
|    |              |              |   {                                       |                                                                                                          |
|    |              |              |     "execTime": "0(us)",                  |                                                                                                          |
|    |              |              |     "rows": 0,                            |                                                                                                          |
|    |              |              |     "totalTime": "10(us)",                |                                                                                                          |
|    |              |              |     "version": 5                          |                                                                                                          |
|    |              |              |   }                                       |                                                                                                          |
|    |              |              | ]                                         |                                                                                                          |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------
|  0 | Start        |              | {                                         | outputVar: {                                                                                             |
|    |              |              |   "execTime": "0(us)",                    |   "colNames": [],                                                                                        |
|    |              |              |   "rows": 0,                              |   "type": "DATASET",                                                                                     |
|    |              |              |   "totalTime": "21(us)",                  |   "name": "__Start_0"                                                                                    |
|    |              |              |   "version": 0                            | }                                                                                                        |
|    |              |              | }                                         |                                                                                                          |
-----+--------------+--------------+-------------------------------------------+-----------------------------------------------------------------------------------------------------------

Mon, 27 Mar 2023 06:15:59 UTC

[may11544]

各步limit 100之后

Execution Plan (optimize time 649 us)

-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
| id | name         | dependencies | profiling data                         | operator info                                                                                            |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
| 10 | DataCollect  | 9            | {                                      | outputVar: {                                                                                             |
|    |              |              |   "execTime": "13(us)",                |   "colNames": [                                                                                          |
|    |              |              |   "rows": 0,                           |     "s"                                                                                                  |
|    |              |              |   "totalTime": "17(us)",               |   ],                                                                                                     |
|    |              |              |   "version": 0                         |   "type": "DATASET",                                                                                     |
|    |              |              | }                                      |   "name": "__DataCollect_10"                                                                             |
|    |              |              |                                        | }                                                                                                        |
|    |              |              |                                        | inputVar: [                                                                                              |
|    |              |              |                                        |   {                                                                                                      |
|    |              |              |                                        |     "colNames": [                                                                                        |
|    |              |              |                                        |       "s"                                                                                                |
|    |              |              |                                        |     ],                                                                                                   |
|    |              |              |                                        |     "type": "DATASET",                                                                                   |
|    |              |              |                                        |     "name": "__Dedup_8"                                                                                  |
|    |              |              |                                        |   }                                                                                                      |
|    |              |              |                                        | ]                                                                                                        |
|    |              |              |                                        | distinct: true                                                                                           |
|    |              |              |                                        | kind: M TO N                                                                                             |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
|  9 | Loop         | 0            | [                                      | outputVar: {                                                                                             |
|    |              |              |   {                                    |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "10(us)",              |   "type": "DATASET",                                                                                     |
|    |              |              |     "rows": 1,                         |   "name": "__Loop_9"                                                                                     |
|    |              |              |     "totalTime": "11(us)",             | }                                                                                                        |
|    |              |              |     "version": 0                       | inputVar:                                                                                                |
|    |              |              |   },                                   | condition: ((++($__VAR_1)<=6) AND (($__VAR_0==__EMPTY__) OR (size($__VAR_0)!=0)))                        |
|    |              |              |   {                                    | loopBody: 8                                                                                              |
|    |              |              |     "execTime": "5(us)",               |                                                                                                          |
|    |              |              |     "rows": 1,                         |                                                                                                          |
|    |              |              |     "totalTime": "6(us)",              |                                                                                                          |
|    |              |              |     "version": 1                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "6(us)",               |                                                                                                          |
|    |              |              |     "rows": 1,                         |                                                                                                          |
|    |              |              |     "totalTime": "7(us)",              |                                                                                                          |
|    |              |              |     "version": 2                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "4(us)",               |                                                                                                          |
|    |              |              |     "rows": 1,                         |                                                                                                          |
|    |              |              |     "totalTime": "5(us)",              |                                                                                                          |
|    |              |              |     "version": 3                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "8(us)",               |                                                                                                          |
|    |              |              |     "rows": 1,                         |                                                                                                          |
|    |              |              |     "totalTime": "10(us)",             |                                                                                                          |
|    |              |              |     "version": 4                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "4(us)",               |                                                                                                          |
|    |              |              |     "rows": 1,                         |                                                                                                          |
|    |              |              |     "totalTime": "5(us)",              |                                                                                                          |
|    |              |              |     "version": 5                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "712(us)",             |                                                                                                          |
|    |              |              |     "rows": 1,                         |                                                                                                          |
|    |              |              |     "totalTime": "715(us)",            |                                                                                                          |
|    |              |              |     "version": 6                       |                                                                                                          |
|    |              |              |   }                                    |                                                                                                          |
|    |              |              | ]                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
|  8 | Dedup        | 7            | [                                      | branch: true, nodeId: 9                                                                                  |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "4(us)",               | outputVar: {                                                                                             |
|    |              |              |     "rows": 0,                         |   "colNames": [                                                                                          |
|    |              |              |     "totalTime": "8(us)",              |     "s"                                                                                                  |
|    |              |              |     "version": 0                       |   ],                                                                                                     |
|    |              |              |   },                                   |   "type": "DATASET",                                                                                     |
|    |              |              |   {                                    |   "name": "__Dedup_8"                                                                                    |
|    |              |              |     "execTime": "2(us)",               | }                                                                                                        |
|    |              |              |     "rows": 0,                         | inputVar: __Project_7                                                                                    |
|    |              |              |     "totalTime": "4(us)",              |                                                                                                          |
|    |              |              |     "version": 1                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "2(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "4(us)",              |                                                                                                          |
|    |              |              |     "version": 2                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "1(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "2(us)",              |                                                                                                          |
|    |              |              |     "version": 3                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "3(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "6(us)",              |                                                                                                          |
|    |              |              |     "version": 4                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "1(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "2(us)",              |                                                                                                          |
|    |              |              |     "version": 5                       |                                                                                                          |
|    |              |              |   }                                    |                                                                                                          |
|    |              |              | ]                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
|  7 | Project      | 6            | [                                      | outputVar: {                                                                                             |
|    |              |              |   {                                    |   "colNames": [                                                                                          |
|    |              |              |     "execTime": "6(us)",               |     "s"                                                                                                  |
|    |              |              |     "rows": 0,                         |   ],                                                                                                     |
|    |              |              |     "totalTime": "7(us)",              |   "type": "DATASET",                                                                                     |
|    |              |              |     "version": 0                       |   "name": "__Project_7"                                                                                  |
|    |              |              |   },                                   | }                                                                                                        |
|    |              |              |   {                                    | inputVar: __Filter_6                                                                                     |
|    |              |              |     "execTime": "26(us)",              | columns: [                                                                                               |
|    |              |              |     "rows": 0,                         |   "EDGE AS s"                                                                                            |
|    |              |              |     "totalTime": "27(us)",             | ]                                                                                                        |
|    |              |              |     "version": 1                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "9(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "10(us)",             |                                                                                                          |
|    |              |              |     "version": 2                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "6(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "7(us)",              |                                                                                                          |
|    |              |              |     "version": 3                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "9(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "10(us)",             |                                                                                                          |
|    |              |              |     "version": 4                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "10(us)",              |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "13(us)",             |                                                                                                          |
|    |              |              |     "version": 5                       |                                                                                                          |
|    |              |              |   }                                    |                                                                                                          |
|    |              |              | ]                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
|  6 | Filter       | 5            | [                                      | outputVar: {                                                                                             |
|    |              |              |   {                                    |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "1352(us)",            |   "type": "DATASET",                                                                                     |
|    |              |              |     "rows": 100,                       |   "name": "__Filter_6"                                                                                   |
|    |              |              |     "totalTime": "1354(us)",           | }                                                                                                        |
|    |              |              |     "version": 0                       | inputVar: __Limit_3                                                                                      |
|    |              |              |   },                                   | condition: ((properties(EDGE).event_time<1679888603187) AND (properties(EDGE).event_time>1679888501000)) |
|    |              |              |   {                                    | isStable: false                                                                                          |
|    |              |              |     "execTime": "681(us)",             |                                                                                                          |
|    |              |              |     "rows": 155,                       |                                                                                                          |
|    |              |              |     "totalTime": "684(us)",            |                                                                                                          |
|    |              |              |     "version": 1                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "911(us)",             |                                                                                                          |
|    |              |              |     "rows": 153,                       |                                                                                                          |
|    |              |              |     "totalTime": "912(us)",            |                                                                                                          |
|    |              |              |     "version": 2                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "731(us)",             |                                                                                                          |
|    |              |              |     "rows": 155,                       |                                                                                                          |
|    |              |              |     "totalTime": "733(us)",            |                                                                                                          |
|    |              |              |     "version": 3                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "1376(us)",            |                                                                                                          |
|    |              |              |     "rows": 153,                       |                                                                                                          |
|    |              |              |     "totalTime": "1378(us)",           |                                                                                                          |
|    |              |              |     "version": 4                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "716(us)",             |                                                                                                          |
|    |              |              |     "rows": 155,                       |                                                                                                          |
|    |              |              |     "totalTime": "718(us)",            |                                                                                                          |
|    |              |              |     "version": 5                       |                                                                                                          |
|    |              |              |   }                                    |                                                                                                          |
|    |              |              | ]                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
|  5 | Dedup        | 4            | [                                      | outputVar: {                                                                                             |
|    |              |              |   {                                    |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "20(us)",              |   "type": "DATASET",                                                                                     |
|    |              |              |     "rows": 4,                         |   "name": "__VAR_0"                                                                                      |
|    |              |              |     "totalTime": "21(us)",             | }                                                                                                        |
|    |              |              |     "version": 0                       | inputVar: __Project_4                                                                                    |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "24(us)",              |                                                                                                          |
|    |              |              |     "rows": 2,                         |                                                                                                          |
|    |              |              |     "totalTime": "26(us)",             |                                                                                                          |
|    |              |              |     "version": 1                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "19(us)",              |                                                                                                          |
|    |              |              |     "rows": 5,                         |                                                                                                          |
|    |              |              |     "totalTime": "20(us)",             |                                                                                                          |
|    |              |              |     "version": 2                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "19(us)",              |                                                                                                          |
|    |              |              |     "rows": 3,                         |                                                                                                          |
|    |              |              |     "totalTime": "20(us)",             |                                                                                                          |
|    |              |              |     "version": 3                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "19(us)",              |                                                                                                          |
|    |              |              |     "rows": 4,                         |                                                                                                          |
|    |              |              |     "totalTime": "21(us)",             |                                                                                                          |
|    |              |              |     "version": 4                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "21(us)",              |                                                                                                          |
|    |              |              |     "rows": 2,                         |                                                                                                          |
|    |              |              |     "totalTime": "23(us)",             |                                                                                                          |
|    |              |              |     "version": 5                       |                                                                                                          |
|    |              |              |   }                                    |                                                                                                          |
|    |              |              | ]                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
|  4 | Project      | 11           | [                                      | outputVar: {                                                                                             |
|    |              |              |   {                                    |   "colNames": [                                                                                          |
|    |              |              |     "execTime": "80(us)",              |     "_vid"                                                                                               |
|    |              |              |     "rows": 100,                       |   ],                                                                                                     |
|    |              |              |     "totalTime": "82(us)",             |   "type": "DATASET",                                                                                     |
|    |              |              |     "version": 0                       |   "name": "__Project_4"                                                                                  |
|    |              |              |   },                                   | }                                                                                                        |
|    |              |              |   {                                    | inputVar: __Limit_3                                                                                      |
|    |              |              |     "execTime": "99(us)",              | columns: [                                                                                               |
|    |              |              |     "rows": 100,                       |   "*._dst AS _vid"                                                                                       |
|    |              |              |     "totalTime": "101(us)",            | ]                                                                                                        |
|    |              |              |     "version": 1                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "60(us)",              |                                                                                                          |
|    |              |              |     "rows": 100,                       |                                                                                                          |
|    |              |              |     "totalTime": "62(us)",             |                                                                                                          |
|    |              |              |     "version": 2                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "75(us)",              |                                                                                                          |
|    |              |              |     "rows": 100,                       |                                                                                                          |
|    |              |              |     "totalTime": "77(us)",             |                                                                                                          |
|    |              |              |     "version": 3                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "61(us)",              |                                                                                                          |
|    |              |              |     "rows": 100,                       |                                                                                                          |
|    |              |              |     "totalTime": "63(us)",             |                                                                                                          |
|    |              |              |     "version": 4                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "87(us)",              |                                                                                                          |
|    |              |              |     "rows": 100,                       |                                                                                                          |
|    |              |              |     "totalTime": "89(us)",             |                                                                                                          |
|    |              |              |     "version": 5                       |                                                                                                          |
|    |              |              |   }                                    |                                                                                                          |
|    |              |              | ]                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
| 11 | Limit        | 12           | [                                      | outputVar: {                                                                                             |
|    |              |              |   {                                    |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "20(us)",              |   "type": "DATASET",                                                                                     |
|    |              |              |     "rows": 100,                       |   "name": "__Limit_3"                                                                                    |
|    |              |              |     "totalTime": "23(us)",             | }                                                                                                        |
|    |              |              |     "version": 0                       | inputVar: __GetNeighbors_12                                                                              |
|    |              |              |   },                                   | offset: 0                                                                                                |
|    |              |              |   {                                    | count: $__VAR_2[($__VAR_1-1)]                                                                            |
|    |              |              |     "execTime": "20(us)",              |                                                                                                          |
|    |              |              |     "rows": 155,                       |                                                                                                          |
|    |              |              |     "totalTime": "24(us)",             |                                                                                                          |
|    |              |              |     "version": 1                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "14(us)",              |                                                                                                          |
|    |              |              |     "rows": 153,                       |                                                                                                          |
|    |              |              |     "totalTime": "17(us)",             |                                                                                                          |
|    |              |              |     "version": 2                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "12(us)",              |                                                                                                          |
|    |              |              |     "rows": 155,                       |                                                                                                          |
|    |              |              |     "totalTime": "14(us)",             |                                                                                                          |
|    |              |              |     "version": 3                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "17(us)",              |                                                                                                          |
|    |              |              |     "rows": 153,                       |                                                                                                          |
|    |              |              |     "totalTime": "30(us)",             |                                                                                                          |
|    |              |              |     "version": 4                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "12(us)",              |                                                                                                          |
|    |              |              |     "rows": 155,                       |                                                                                                          |
|    |              |              |     "totalTime": "13(us)",             |                                                                                                          |
|    |              |              |     "version": 5                       |                                                                                                          |
|    |              |              |   }                                    |                                                                                                          |
|    |              |              | ]                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
| 12 | GetNeighbors | 1            | [                                      | outputVar: {                                                                                             |
|    |              |              |   {                                    |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "63(us)",              |   "type": "DATASET",                                                                                     |
|    |              |              |     "resp[0]": {                       |   "name": "__GetNeighbors_12"                                                                            |
|    |              |              |       "exec": "1626(us)",              | }                                                                                                        |
|    |              |              |       "host": "storaged:9779",         | inputVar: __VAR_0                                                                                        |
|    |              |              |       "storage_detail": {              | space: 330                                                                                               |
|    |              |              |         "GetNeighborsNode": "703(us)", | dedup: false                                                                                             |
|    |              |              |         "HashJoinNode": "145(us)",     | limit: $__VAR_2[($__VAR_1-1)]                                                                            |
|    |              |              |         "RelNode": "703(us)",          | filter:                                                                                                  |
|    |              |              |         "SingleEdgeNode": "142(us)"    | orderBy: []                                                                                              |
|    |              |              |       },                               | src: COLUMN[0]                                                                                           |
|    |              |              |       "total": "2748(us)",             | edgeTypes: []                                                                                            |
|    |              |              |       "vertices": 1                    | edgeDirection: OUT_EDGE                                                                                  |
|    |              |              |     },                                 | vertexProps:                                                                                             |
|    |              |              |     "rows": 100,                       | edgeProps: [                                                                                             |
|    |              |              |     "totalTime": "2913(us)",           |   {                                                                                                      |
|    |              |              |     "total_rpc_time": "2832(us)",      |     "props": [                                                                                           |
|    |              |              |     "version": 0                       |       "_dst",                                                                                            |
|    |              |              |   },                                   |       "_rank",                                                                                           |
|    |              |              |   {                                    |       "_src",                                                                                            |
|    |              |              |     "execTime": "40(us)",              |       "_type",                                                                                           |
|    |              |              |     "resp[0]": {                       |       "app_proto",                                                                                       |
|    |              |              |       "exec": "863(us)",               |       "attacker_port",                                                                                   |
|    |              |              |       "host": "storaged:9779",         |       "event_time",                                                                                      |
|    |              |              |       "storage_detail": {              |       "flow_id",                                                                                         |
|    |              |              |         "GetNeighborsNode": "787(us)", |       "name",                                                                                            |
|    |              |              |         "HashJoinNode": "103(us)",     |       "phase",                                                                                           |
|    |              |              |         "RelNode": "787(us)",          |       "proto",                                                                                           |
|    |              |              |         "SingleEdgeNode": "99(us)"     |       "result",                                                                                          |
|    |              |              |       },                               |       "severity",                                                                                        |
|    |              |              |       "total": "2016(us)",             |       "tag",                                                                                             |
|    |              |              |       "vertices": 4                    |       "tool",                                                                                            |
|    |              |              |     },                                 |       "victim_port"                                                                                      |
|    |              |              |     "rows": 155,                       |     ],                                                                                                   |
|    |              |              |     "totalTime": "2100(us)",           |     "type": 334                                                                                          |
|    |              |              |     "total_rpc_time": "2046(us)",      |   }                                                                                                      |
|    |              |              |     "version": 1                       | ]                                                                                                        |
|    |              |              |   },                                   | statProps:                                                                                               |
|    |              |              |   {                                    | exprs:                                                                                                   |
|    |              |              |     "execTime": "61(us)",              | random: false                                                                                            |
|    |              |              |     "resp[0]": {                       |                                                                                                          |
|    |              |              |       "exec": "738(us)",               |                                                                                                          |
|    |              |              |       "host": "storaged:9779",         |                                                                                                          |
|    |              |              |       "storage_detail": {              |                                                                                                          |
|    |              |              |         "GetNeighborsNode": "661(us)", |                                                                                                          |
|    |              |              |         "HashJoinNode": "59(us)",      |                                                                                                          |
|    |              |              |         "RelNode": "661(us)",          |                                                                                                          |
|    |              |              |         "SingleEdgeNode": "57(us)"     |                                                                                                          |
|    |              |              |       },                               |                                                                                                          |
|    |              |              |       "total": "1837(us)",             |                                                                                                          |
|    |              |              |       "vertices": 2                    |                                                                                                          |
|    |              |              |     },                                 |                                                                                                          |
|    |              |              |     "rows": 153,                       |                                                                                                          |
|    |              |              |     "totalTime": "1942(us)",           |                                                                                                          |
|    |              |              |     "total_rpc_time": "1866(us)",      |                                                                                                          |
|    |              |              |     "version": 2                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "40(us)",              |                                                                                                          |
|    |              |              |     "resp[0]": {                       |                                                                                                          |
|    |              |              |       "exec": "1082(us)",              |                                                                                                          |
|    |              |              |       "host": "storaged:9779",         |                                                                                                          |
|    |              |              |       "storage_detail": {              |                                                                                                          |
|    |              |              |         "GetNeighborsNode": "930(us)", |                                                                                                          |
|    |              |              |         "HashJoinNode": "171(us)",     |                                                                                                          |
|    |              |              |         "RelNode": "931(us)",          |                                                                                                          |
|    |              |              |         "SingleEdgeNode": "166(us)"    |                                                                                                          |
|    |              |              |       },                               |                                                                                                          |
|    |              |              |       "total": "1866(us)",             |                                                                                                          |
|    |              |              |       "vertices": 5                    |                                                                                                          |
|    |              |              |     },                                 |                                                                                                          |
|    |              |              |     "rows": 155,                       |                                                                                                          |
|    |              |              |     "totalTime": "1957(us)",           |                                                                                                          |
|    |              |              |     "total_rpc_time": "1904(us)",      |                                                                                                          |
|    |              |              |     "version": 3                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "47(us)",              |                                                                                                          |
|    |              |              |     "resp[0]": {                       |                                                                                                          |
|    |              |              |       "exec": "790(us)",               |                                                                                                          |
|    |              |              |       "host": "storaged:9779",         |                                                                                                          |
|    |              |              |       "storage_detail": {              |                                                                                                          |
|    |              |              |         "GetNeighborsNode": "717(us)", |                                                                                                          |
|    |              |              |         "HashJoinNode": "68(us)",      |                                                                                                          |
|    |              |              |         "RelNode": "717(us)",          |                                                                                                          |
|    |              |              |         "SingleEdgeNode": "67(us)"     |                                                                                                          |
|    |              |              |       },                               |                                                                                                          |
|    |              |              |       "total": "1530(us)",             |                                                                                                          |
|    |              |              |       "vertices": 3                    |                                                                                                          |
|    |              |              |     },                                 |                                                                                                          |
|    |              |              |     "rows": 153,                       |                                                                                                          |
|    |              |              |     "totalTime": "1625(us)",           |                                                                                                          |
|    |              |              |     "total_rpc_time": "1562(us)",      |                                                                                                          |
|    |              |              |     "version": 4                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "43(us)",              |                                                                                                          |
|    |              |              |     "resp[0]": {                       |                                                                                                          |
|    |              |              |       "exec": "765(us)",               |                                                                                                          |
|    |              |              |       "host": "storaged:9779",         |                                                                                                          |
|    |              |              |       "storage_detail": {              |                                                                                                          |
|    |              |              |         "GetNeighborsNode": "689(us)", |                                                                                                          |
|    |              |              |         "HashJoinNode": "67(us)",      |                                                                                                          |
|    |              |              |         "RelNode": "690(us)",          |                                                                                                          |
|    |              |              |         "SingleEdgeNode": "64(us)"     |                                                                                                          |
|    |              |              |       },                               |                                                                                                          |
|    |              |              |       "total": "1699(us)",             |                                                                                                          |
|    |              |              |       "vertices": 4                    |                                                                                                          |
|    |              |              |     },                                 |                                                                                                          |
|    |              |              |     "rows": 155,                       |                                                                                                          |
|    |              |              |     "totalTime": "1778(us)",           |                                                                                                          |
|    |              |              |     "total_rpc_time": "1724(us)",      |                                                                                                          |
|    |              |              |     "version": 5                       |                                                                                                          |
|    |              |              |   }                                    |                                                                                                          |
|    |              |              | ]                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
|  1 | Start        |              | [                                      | outputVar: {                                                                                             |
|    |              |              |   {                                    |   "colNames": [],                                                                                        |
|    |              |              |     "execTime": "0(us)",               |   "type": "DATASET",                                                                                     |
|    |              |              |     "rows": 0,                         |   "name": "__Start_1"                                                                                    |
|    |              |              |     "totalTime": "14(us)",             | }                                                                                                        |
|    |              |              |     "version": 0                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "0(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "11(us)",             |                                                                                                          |
|    |              |              |     "version": 1                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "0(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "8(us)",              |                                                                                                          |
|    |              |              |     "version": 2                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "1(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "13(us)",             |                                                                                                          |
|    |              |              |     "version": 3                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "0(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "10(us)",             |                                                                                                          |
|    |              |              |     "version": 4                       |                                                                                                          |
|    |              |              |   },                                   |                                                                                                          |
|    |              |              |   {                                    |                                                                                                          |
|    |              |              |     "execTime": "0(us)",               |                                                                                                          |
|    |              |              |     "rows": 0,                         |                                                                                                          |
|    |              |              |     "totalTime": "10(us)",             |                                                                                                          |
|    |              |              |     "version": 5                       |                                                                                                          |
|    |              |              |   }                                    |                                                                                                          |
|    |              |              | ]                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------
|  0 | Start        |              | {                                      | outputVar: {                                                                                             |
|    |              |              |   "execTime": "0(us)",                 |   "colNames": [],                                                                                        |
|    |              |              |   "rows": 0,                           |   "type": "DATASET",                                                                                     |
|    |              |              |   "totalTime": "22(us)",               |   "name": "__Start_0"                                                                                    |
|    |              |              |   "version": 0                         | }                                                                                                        |
|    |              |              | }                                      |                                                                                                          |
-----+--------------+--------------+----------------------------------------+-----------------------------------------------------------------------------------------------------------

Mon, 27 Mar 2023 06:16:39 UTC

[wey]

@may11544

where properties(edge).event_time<1679888603187

改成
where edge_attack.event_time<1679888603187 ...
再 profile 看下

ref: https://www.siwei.io/ngql-execution-plan/

[yee]

目前 GO 中每步 limit 的语意实现确实如你所说，先执行的 LIMIT 再做的过滤，这个是个 known issue, 确实是有些不合理的地方。我们在新版本中正在考虑把这个行为纠正过来。

[may11544]

一样的效果哈

[may11544]

好的，希望可以尽快修复。limit作用在where condition前面狮是在有点反直觉
可以贴一下issue地址吗，我关注一下

[yee]

这个问题有些历史原因了，其实 GO 在当初设计每步的 LIMIT 这个语法时，是兼容了当时的 filter 的做法，GO M TO N 中的 where 语意是只在最后(M to N)步做 filter，而不是每一步做 filter，所以每步的 limit 先于 filter 来执行了。

其实我们内部讨论下来还是倾向于不改变原有的行为，更值得的做法是在 match 中添加每步 filter 的优化，比如：match (v)-[e:like*1..5]-(v2) where all(i in e where i.likeness > 30) return * 现在没有做 all filter 下退，这个优化可以支持

[may11544]

关于第一点，如果按照现在这种设计的话，那我觉得where condition和limit是不能同时使用的。至少是有背所有数据库的做法，不太理解这样去做的初衷。
第二就是，测试是发现很多match语句性能不太行所以才改写的GO语句，现在的状况就比较尴尬，match语句大部分场景性能不足，GO语句又有很多场景支持不足。可以求教下相关的规划吗，是以优化match语句为主还是丰富GO语句的特性为主？

总之使用到现在，nebula有很多非常绕并且反直觉的“特性”。这些特性让人感觉只是为了有某个功能而存在，但是却和实际的使用场景背道而驰。

举个例子：既然limit已经有了“随机选择“的特性，那么使用者再加where condition的意思在哪里呢？

[yee]

关于 GO 语句的语意，确实对用户而言有些使用上的困扰，尤其是配合了 where 之后，具体的语意可以看下这里的注释。

我看你们已经在使用 3.4.0 版本的 nebula，你提到的 MATCH 语句的性能问题，这个能否展开描述一下，因为上个版本确实已经做了许多有关 match 的优化，后续也希望能在这块进一步提升。

如果有具体的语句的对比，可以把相关的 profile 信息提供一下，便于优化 match 的实现。

[kyle]

@may11544

总之使用到现在，nebula有很多非常绕并且反直觉的“特性”。这些特性让人感觉只是为了有某个功能而存在，但是却和实际的使用场景背道而驰。

是的。
早期的 ngql 语法设计意图比较单纯(比如 GO 语句只是做简单的拓展而没有考虑路径重复计算的问题)，其中很多基本语言元素也没有经过严格的定义和形式证明，加之一些工程实现的问题，语言的自洽性、完备性、易用性甚至可优化程度都较难保证，包括你这里所说的“反直觉特性”、“无法契合更多的实际场景”，等等。但由于 “只是为了某个功能而设计” 而不考虑通用性，在某些具体场景下，GO 语句性能会比较好。
对于 cypher 语法来说，因为尽可能地追随了 cypher 标准，上述语言设计相关问题有了较好地解决。随着几个版本迭代下来，性能也做了很多优化。性能方面我的观点是，MATCH 的性能可优化性要好于 GO，但对于用户来说，目前 MATCH 语句的写法还是很可能对性能影响很大(比如 pattern 顺序、索引选取等等)，需要 DBA 依据具体的执行计划进行分析优化。

[may11544]

Match很多场景都很不堪啊，就比如你上面举的那个例子

当我改写为

match (v)-[e:edge_attack*1..6]->(v2) where id(v)== "172.16.33.1" and all(i in e where i.event_time >= 1679888501000 and i.event_time<=1679888603187) return e limit 10

查询会一直阻塞的，然后nebula-graphd就重启了，看起来又去全表扫了。

我只能说现在的match语句的状态在生产中基本处于不可用状态。微信群里也不只有一个人反馈过match语句的问题了

[yee]

上面这个 match 语句慢的原因是 all 中的表达式没能推到 storage，如果就是这个 case 的话，我们可以讲这个表达式优化掉，因为这里的 all 表达式是可以下推的。

对应的 issue 记录在了这里：https://github.com/vesoft-inc/nebula/issues/5441

[may11544]

上面这个只是一个例子，关于match的问题，我觉得可以开个专题去讨论了

比如就算没有all函数

match (v)-[e:edge_attack*1..6]->(v2) where id(v)== "172.16.33.1" return e limit 100

类似这种根据某个点去匹配的limit也会长阻塞。大概率是因为之前说过的limit无法early stop的原因。

[yee]

期望能够见到更多的 match 不满足要求的场景，如果有需要可以联系我们的社区同学，后面我们做重点的支持和优化。后续会把 match 的性能做的不输于 GO。

@nbot

上面 limit 是不能 early stop 的，因为与原来的语意不同了，当然有其他的优化是改广搜为深搜。
这个也是 cypher 语意上缺失的地方。在新的 GQL 中会有允许用户更方便表达的方式。

[may11544]

不是很多，是现在的match处于不可用的状态

数据量一旦稍微大点（只有百万数量级），很多match语句都会全表扫描导致graphd的内存爆掉然后一直重启。

[may11544]

我理解这个语句是最最常见的query了吧。所以我能“安全”的用match的场景是？

[yee]

全表扫出现的情况是说有选不到合适索引的查询吗？ 还是什么其他的情况。能否提供些语句和相关的 schema？

关于内存这块，如果 3.4 的版本的话，应该有较大的改善，还是期望能提供下具体的场景为好。