We have an Oracle Linux Server 9.2 with ELK Stack version 8.18.3 deployed.
In Elasticsearch, we store information about web resource activity (each resource is a separate daily index, with approximately 45 indices and an average volume of 1GB per index). A dashboard with 16 different charts is built based on this stored data.
The problem is the long duration of chart generation when selecting a period longer than 7 days, which can take up to 3-5 minutes for a 14-day period.
CPU: 8
RAM: 16 GB
JVM heap size: -Xms8g, -Xmx8g
We've changed the disk type to SSD and increased the amount of RAM for Elastic according to the following link: Tune for search speed | Elastic Docs
How can we diagnose what else can be changed to reduce the search execution time for indices and decrease the dashboard build time?