It looks like investigating the slow query to identify what is going on is your best bet. If you have the id of your visualisation you can use the Elasticsearch slow log. Or you can pull the query for the visualization via the inspect feature in Kibana and then run the query using the search profiler.
Both of these approaches are documented in this blog post for you to follow along.
Appreciate the update. I've got some clarifications to your additional questions:
I see later on a screenshot for the Inspector with the stats and requests tabs that suggests you have access to the Inspector. To confirm, I'm referring to the Inspect feature available in edit mode for a visualisation:
I would have a look at the request tab, where you should be able to either view the request in the search profiler directly, or copy and run it in the search profiler:
Thanks again for your reply, much appreciate.
When clicking on the Inspect button from the Vizualization, I do have this screen, but the Statistics tab is missing and there is no "Open in Search Profiler":
Cool, do let us know how you get on with setting up your agents.
If you can't see the Search Profiler option in the Request tab you can use the Copy to clipboard option and access the Search Profiler under Dev Tools or using the search bar:
If you think it might be slowness in Kibana over the query I would have a look at investigating via either APM or the Chrome Developer tools. They are covered in the same blog listed above.
Hi Carly,
I want to go with APM solution since it looks a more elegant one. I have followed this guide to install the node.js agent (since I've read here this is what is needed for debugging Kibana: Debugging Kibana | Kibana Guide [8.8] | Elastic)
Here I can see that at least one agent is running, despite the fact that I didn't do the configuration part (I don't know where to add that config):
PS. I also had to do "apt install npm" (I'm on Ubuntu), but I have some doubts that the node.js agent is what I'm looking for, do I maybe need the Java one?
If I click on Launch APM at the bottom, it gets me back here (as if I don't have any active agent):
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.