Aggregation performance

Elastic Stack Elasticsearch
1

hello,

Can anyone please advice how to improve a query performance?

  • the bool filter takes 50ms.

  • filter dates: last 7 days

  • total search documents : 20075

  • total index documents : 79m

  • searched indices: 1

  • index primary shard size: 9.2gb

  • primary shards: 2

  • replica:1

  • storage tier: hot

thank you!

image
image1866×839 97.4 KB

2

How much faster do you want it?

3

Usually I'm used to much better performance.
I'm trying to keep 2 seconds as target number

4

If your index is only 9.2GB in size, why have 2 primary shards? What is the hardware specification of the cluster? What is the full output of the cluster stats API?

5

I can decrease the shards via ilm, and do rollover..
attached below, thanks!

https://jsonblob.com/b6777ebd-cf36-11eb-a671-7b947ffb5d48

6

@Christian_Dahlqvist @warkolm any tips you can think of? Is 90 million too many documents per index?