(root@nebula) [haina]> MATCH (ser:Service) where ser.Service.invalid == 0 RETURN ser limit 5;
[ERROR (-1005)]: Storage Error: part: 5, error: E_RPC_FAILURE(-3).
来试试上面的方法，如果问题没解决的话，可以来更新下帖子哈
当前的查询效率太低了。
查询一：
MATCH (ser:Service) where ser.Service.invalid == 0 RETURN ser limit 5;
这种方式需要23s
Got 5 rows (time spent 23654508/23658446 us)
Mon, 11 Apr 2022 20:18:57 CST
查询二：
LOOKUP ON service YIELD id(vertex) | YIELD COUNT(*) AS counts;
这种方式需要20s
(root@nebula) [haina]> LOOKUP ON service YIELD id(vertex) | YIELD COUNT(*) AS counts;
+---------+
| counts |
+---------+
| 1909673 |
+---------+
Got 1 rows (time spent 21208961/21249199 us)
如何能加快检索效率
我编辑了下格式，可以在 2 条语句前面加个 profile，看下执行计划吗？记得贴一下执行计划
执行计划如下
(root@nebula) [haina]> profile LOOKUP ON service YIELD id(vertex) | YIELD COUNT(*) AS counts;
+---------+
| counts |
+---------+
| 1909673 |
+---------+
Got 1 rows (time spent 27481233/27472755 us)
Execution Plan (optimize time 1595 us)
-----+------------------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------
| id | name | dependencies | profiling data | operator info |
-----+------------------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------
| 3 | Aggregate | 2 | ver: 0, rows: 1, execTime: 355626us, totalTime: 355636us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "counts" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Aggregate_3" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Project_2 |
| | | | | groupKeys: [] |
| | | | | groupItems: [ |
| | | | | { |
| | | | | "expr": "COUNT(*)" |
| | | | | } |
| | | | | ] |
-----+------------------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------
| 2 | Project | 4 | ver: 0, rows: 1909673, execTime: 8677338us, totalTime: 8677369us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "id(VERTEX)" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Project_2" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __TagIndexFullScan_1 |
| | | | | columns: [ |
| | | | | "id(VERTEX)" |
| | | | | ] |
-----+------------------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------
| 4 | TagIndexFullScan | 0 | { | outputVar: [ |
| | | | ver: 0, rows: 1909673, execTime: 0us, totalTime: 18430724us | { |
| | | | storage_detail: {IndexLimitNode(limit=9223372036854775807):40434429(us),IndexProjectionNode(projectColumn=[_vid,_tag,businessType,createdTime,dataPermissionId,extInfo,host,importance,invalid,isPublicPort,name,node,port,protocol,protocolType,serialNumber,sort,source,sourceType,unowned,updatedTime,version]):40434366(us),IndexVertexScanNode(IndexID=24, Path=()):40434154(us)} | "colNames": [ |
| | | | "127.0.0.1":9779 exec/total: 11103116(us)/16515358(us) | "_vid", |
| | | | } | "service._tag", |
| | | | | "service.businessType", |
| | | | | "service.createdTime", |
| | | | | "service.dataPermissionId", |
| | | | | "service.extInfo", |
| | | | | "service.host", |
| | | | | "service.importance", |
| | | | | "service.invalid", |
| | | | | "service.isPublicPort", |
| | | | | "service.name", |
| | | | | "service.node", |
| | | | | "service.port", |
| | | | | "service.protocol", |
| | | | | "service.protocolType", |
| | | | | "service.serialNumber", |
| | | | | "service.sort", |
| | | | | "service.source", |
| | | | | "service.sourceType", |
| | | | | "service.unowned", |
| | | | | "service.updatedTime", |
| | | | | "service.version" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__TagIndexFullScan_1" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: |
| | | | | space: 22 |
| | | | | dedup: false |
| | | | | limit: 9223372036854775807 |
| | | | | filter: |
| | | | | orderBy: [] |
| | | | | schemaId: 23 |
| | | | | isEdge: false |
| | | | | returnCols: [ |
| | | | | "_vid", |
| | | | | "_tag", |
| | | | | "businessType", |
| | | | | "createdTime", |
| | | | | "dataPermissionId", |
| | | | | "extInfo", |
| | | | | "host", |
| | | | | "importance", |
| | | | | "invalid", |
| | | | | "isPublicPort", |
| | | | | "name", |
| | | | | "node", |
| | | | | "port", |
| | | | | "protocol", |
| | | | | "protocolType", |
| | | | | "serialNumber", |
| | | | | "sort", |
| | | | | "source", |
| | | | | "sourceType", |
| | | | | "unowned", |
| | | | | "updatedTime", |
| | | | | "version" |
| | | | | ] |
| | | | | indexCtx: [ |
| | | | | { |
| | | | | "columnHints": [], |
| | | | | "filter": "", |
| | | | | "index_id": 24 |
| | | | | } |
| | | | | ] |
-----+------------------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------
| 0 | Start | | ver: 0, rows: 0, execTime: 0us, totalTime: 29us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Start_0" |
| | | | | } |
| | | | | ] |
-----+------------------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------
Tue, 12 Apr 2022 11:02:35 CST
(root@nebula) [haina]>
还有 match 的哈
(root@nebula) [haina]> profile MATCH (ser:Service) where ser.Service.invalid == 0 RETURN ser limit 5;
Got 5 rows (time spent 25355854/25362551 us)
Execution Plan (optimize time 454 us)
-----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------
| id | name | dependencies | profiling data | operator info |
-----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------
| 8 | DataCollect | 14 | ver: 0, rows: 5, execTime: 59us, totalTime: 66us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "ser" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__DataCollect_8" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "ser" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Limit_7" |
| | | | | } |
| | | | | ] |
| | | | | kind: ROW |
-----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------
| 14 | Project | 13 | ver: 0, rows: 5, execTime: 47696us, totalTime: 47704us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "ser" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Limit_7" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Project_6 |
| | | | | columns: [ |
| | | | | "$-.ser AS ser" |
| | | | | ] |
-----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------
| 13 | Limit | 11 | ver: 0, rows: 5, execTime: 3025606us, totalTime: 3025610us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "ser" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Project_6" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __Filter_11 |
| | | | | offset: 0 |
| | | | | count: 5 |
-----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------
| 11 | Filter | 3 | ver: 0, rows: 1909673, execTime: 757153us, totalTime: 757156us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [ |
| | | | | "ser" |
| | | | | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Filter_11" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __AppendVertices_3 |
| | | | | condition: (-.ser.service.invalid==0) |
| | | | | isStable: false |
-----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------
| 3 | AppendVertices | 9 | { | outputVar: [ |
| | | | ver: 0, rows: 1909673, execTime: 10462450us, totalTime: 20434689us | { |
| | | | "127.0.0.1":9779 exec/total: 4691725(us)/9972503(us) | "colNames": [ |
| | | | total_rpc: 10435337(us) | "ser" |
| | | | } | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__AppendVertices_3" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: __IndexScan_1 |
| | | | | space: 2 |
| | | | | dedup: true |
| | | | | limit: 0 |
| | | | | filter: |
| | | | | orderBy: [] |
| | | | | src: $_vid |
| | | | | props: [ |
| | | | | { |
| | | | | "props": [ |
| | | | | "name", |
| | | | | "host", |
| | | | | "port", |
| | | | | "protocol", |
| | | | | "protocolType", |
| | | | | "version", |
| | | | | "isPublicPort", |
| | | | | "createdTime", |
| | | | | "updatedTime", |
| | | | | "businessType", |
| | | | | "importance", |
| | | | | "extInfo", |
| | | | | "source", |
| | | | | "serialNumber", |
| | | | | "sort", |
| | | | | "invalid", |
| | | | | "node", |
| | | | | "sourceType", |
| | | | | "unowned", |
| | | | | "dataPermissionId", |
| | | | | "_tag" |
| | | | | ], |
| | | | | "tagId": 3 |
| | | | | } |
| | | | | ] |
| | | | | exprs: |
| | | | | vertex_filter: service._tag IS NOT EMPTY |
| | | | | if_track_previous_path: false |
-----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------
| 9 | IndexScan | 2 | { | outputVar: [ |
| | | | ver: 0, rows: 1909673, execTime: 0us, totalTime: 1089001us | { |
| | | | storage_detail: {IndexLimitNode(limit=9223372036854775807):1630779(us),IndexProjectionNode(projectColumn=[_vid]):1630767(us),IndexVertexScanNode(IndexID=4, Path=()):1630718(us)} | "colNames": [ |
| | | | "127.0.0.1":9779 exec/total: 536437(us)/923941(us) | "_vid" |
| | | | } | ], |
| | | | | "type": "DATASET", |
| | | | | "name": "__IndexScan_1" |
| | | | | } |
| | | | | ] |
| | | | | inputVar: |
| | | | | space: 2 |
| | | | | dedup: false |
| | | | | limit: 9223372036854775807 |
| | | | | filter: |
| | | | | orderBy: [] |
| | | | | schemaId: 3 |
| | | | | isEdge: false |
| | | | | returnCols: [ |
| | | | | "_vid" |
| | | | | ] |
| | | | | indexCtx: [ |
| | | | | { |
| | | | | "columnHints": [], |
| | | | | "filter": "", |
| | | | | "index_id": 4 |
| | | | | } |
| | | | | ] |
-----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------
| 2 | Start | | ver: 0, rows: 0, execTime: 0us, totalTime: 36us | outputVar: [ |
| | | | | { |
| | | | | "colNames": [], |
| | | | | "type": "DATASET", |
| | | | | "name": "__Start_2" |
| | | | | } |
| | | | | ] |
-----+----------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------
Tue, 12 Apr 2022 11:23:02 CST
查询一在企业版是有limit下推的。
查询二当前还没有优化。