现状：
下面是查询的语句
source[{"from":0,"size":10,"timeout":"2000ms","query":{"bool":{"filter":[{"terms":{"is_deleted":[0],"boost":1.0}},{"terms":{"first_report_type":[10,9,5,1,35],"boost":1.0}},{"terms":{"second_report_type":[38,39,90,54,91,55,92,56,94,95,96,97,98,99,208,40,59,41,43,44,41,42,2,35,40],"boost":1.0}},{"terms":{"report_type":[1],"boost":1.0}}],"disable_coord":false,"adjust_pure_negative":true,"minimum_should_match":"0","boost":1.0}},"version":true,"_source":{"includes":[],"excludes":[]},"sort":[{"updated_at":{"order":"desc"}}]}]
耗时2s，分片数20，es版本5.5，second_report_type类型是int，es数据量在5亿+
下面是查询的语句
source[{"from":0,"size":10,"timeout":"2000ms","query":{"bool":{"filter":[{"terms":{"is_deleted":[0],"boost":1.0}},{"terms":{"first_report_type":[10,9,5,1,35],"boost":1.0}},{"terms":{"second_report_type":[38,39,90,54,91,55,92,56,94,95,96,97,98,99,208,40,59,41,43,44,41,42,2,35,40],"boost":1.0}},{"terms":{"report_type":[1],"boost":1.0}}],"disable_coord":false,"adjust_pure_negative":true,"minimum_should_match":"0","boost":1.0}},"version":true,"_source":{"includes":[],"excludes":[]},"sort":[{"updated_at":{"order":"desc"}}]}]
耗时2s，分片数20，es版本5.5，second_report_type类型是int，es数据量在5亿+
2 个回复
liuxg - Elastic
赞同来自:
zhenxianyimeng
赞同来自: