3.0.2简单查询超时

  • nebula 版本:3.0.2
  • 部署方式:分布式
  • 安装方式:源码编译
  • 是否为线上版本: N
  • 硬件信息
    • 磁盘 hdd
    • CPU、内存信息 16核 24g
  • 问题的具体描述 简单查询超时 MATCH (v:item) RETURN v LIMIT 10
    profile
"id","name","dependencies","profiling data","operator info"
"7","DataCollect","10","ver: 0, rows: 100, execTime: 9623us, totalTime: 9629us","outputVar: [
  {
    ""colNames"": [
      ""v""
    ],
    ""type"": ""DATASET"",
    ""name"": ""__DataCollect_7""
  }
]
inputVar: [
  {
    ""colNames"": [
      ""v""
    ],
    ""type"": ""DATASET"",
    ""name"": ""__Limit_6""
  }
]
kind: ROW"
"10","Project","9","ver: 0, rows: 100, execTime: 24978us, totalTime: 24983us","outputVar: [
  {
    ""colNames"": [
      ""v""
    ],
    ""type"": ""DATASET"",
    ""name"": ""__Limit_6""
  }
]
inputVar: __Project_5
columns: [
  ""$-.v AS v""
]"
"9","Limit","3","ver: 0, rows: 100, execTime: 6499043us, totalTime: 6499047us","outputVar: [
  {
    ""colNames"": [
      ""v""
    ],
    ""type"": ""DATASET"",
    ""name"": ""__Project_5""
  }
]
inputVar: __AppendVertices_3
offset: 0
count: 100"
"3","AppendVertices","1","{
ver: 0, rows: 9510000, execTime: 35938517us, totalTime: 84974629us
""192.168.120.18"":9779 exec/total: 31180862(us)/34788055(us)
total_rpc: 51180344(us)
""192.168.120.12"":9779 exec/total: 37839481(us)/41503008(us)
""192.168.120.13"":9779 exec/total: 37607691(us)/41142893(us)
""192.168.120.14"":9779 exec/total: 37066421(us)/41170802(us)
""192.168.120.17"":9779 exec/total: 42276201(us)/46338954(us)
""192.168.120.19"":9779 exec/total: 44856115(us)/49344355(us)
}","outputVar: [
  {
    ""colNames"": [
      ""v""
    ],
    ""type"": ""DATASET"",
    ""name"": ""__AppendVertices_3""
  }
]
inputVar: __IndexScan_1
space: 2
dedup: true
limit: 0
filter: 
orderBy: []
src: $_vid
props: [
  {
    ""props"": [
      ""id"",
      ""enDescription"",
      ""enAliases"",
      ""enLabel"",
      ""zhDescription"",
      ""zhAliases"",
      ""zhLabel"",
      ""_tag""
    ],
    ""tagId"": 5
  },
  {
    ""props"": [
      ""id"",
      ""enDescription"",
      ""enAliases"",
      ""enLabel"",
      ""zhDescription"",
      ""zhAliases"",
      ""zhLabel"",
      ""_tag""
    ],
    ""tagId"": 6
  }
]
exprs: 
vertex_filter: item._tag IS NOT EMPTY
if_track_previous_path: false"
"1","IndexScan","2","{
ver: 0, rows: 9510000, execTime: 0us, totalTime: 4195028us
""192.168.120.12"":9779 exec/total: 1991973(us)/2321552(us)
""192.168.120.17"":9779 exec/total: 2391651(us)/2766414(us)
storage_detail: {IndexLimitNode(limit=9223372036854775807):1840914(us),IndexProjectionNode(projectColumn=[_vid]):1762215(us),IndexVertexScanNode(IndexID=14, Path=()):1440447(us)}
""192.168.120.14"":9779 exec/total: 2280103(us)/2656064(us)
""192.168.120.13"":9779 exec/total: 1960891(us)/2275470(us)
""192.168.120.19"":9779 exec/total: 2516376(us)/2911123(us)
""192.168.120.18"":9779 exec/total: 2002055(us)/2314404(us)
}","outputVar: [
  {
    ""colNames"": [
      ""_vid""
    ],
    ""type"": ""DATASET"",
    ""name"": ""__IndexScan_1""
  }
]
inputVar: 
space: 2
dedup: false
limit: 9223372036854775807
filter: 
orderBy: []
schemaId: 6
isEdge: false
returnCols: [
  ""_vid""
]
indexCtx: [
  {
    ""columnHints"": [],
    ""filter"": """",
    ""index_id"": 14
  }
]"
"2","Start","","ver: 0, rows: 0, execTime: 0us, totalTime: 20us","outputVar: [
  {
    ""colNames"": [],
    ""type"": ""DATASET"",
    ""name"": ""__Start_2""
  }
]"

你好, limit下推的优化规则只有企业版有

Lookup 的 limit 下推优化是有的哈!

explain lookup on item yield vertex as v | limit 1
1 个赞

也就是说先match limit会导致扫全表吗

是的

3.1.0在这块是有优化吗,我上周试3.1.0的时候match limit好像还挺快的

3.1社区版也是没有的

此话题已在最后回复的 30 天后被自动关闭。不再允许新回复。