my data exists in daily indices and 10-20 milion doc per indice ,with 32G memory for elastic jvm .
when i run a dashboard elastice run at least 20 query that created by visualizes .
, when i set time range between 1 and 7 days, All things are good.
but for more days range, i have multiple issue:
1_ kibana query timed out after 3 minute (seted by elasticsearch.requestTimeout).
2_ elastic Continues to execute query for awhile after that 3 minutes.
3_ breake down status appers.
4_ i added more memory and no benefit.
there is no problem if i set some filters (reduce the number of docs ) .
i need some setting to restrict executing concurrent query count that created by dashboard, eg: 5 cuncurrent from all visualize in dashboard.
and wait bar for another loading visualizes .