I have some Kibana Dashboards, while they aren't necessarily used all the time, do require some very heavy queries (Each timelion dashboard with a heavy query X the number of visualizations on the dashbards)..... Right now, I have master only nodes and data only nodes. The data only nodes are fronted by an AWS ELB and Kibana points to that ELB.
Would standing up Coordinating nodes and have Kibana point to coordinating nodes be a good idea in terms of offloading some of the aggregations compute from the data nodes? I could not find much documentation in regards to how much work is done on the searching/pulling data vs the aggregation part... just wondering whether that will help.