Search Profiler visualization

[Hronom]

Is your feature request related to a problem? Please describe.
Hard to read JSON output of profile API.

Describe the solution you'd like
Add some visualizer like this https://www.elastic.co/guide/en/kibana/current/xpack-profiler.html

[IzekChen]

This is really useful tools when you troubleshooting the bad query or analyze the performance.
Would be great if we can have it
+1

[ahopp]

In general, I think a general profiler would be useful and something we should add to the Dashboard experience.

@Hronom do you any thoughts on what information is most important to capture in a initial profiler?

[Hronom]

@ahopp as for me I'm targeting visual experience, since reading tree of json text not always easy for human, I would say check this screenshots, important for me is times and percentage of how long each item take from total time. This will help to understand what item is heavy.


https://www.elastic.co/guide/en/kibana/current/xpack-profiler.html

So if first version just can have name of item in tree and time how long it take, would be great!
But please, if you can get support of all, what is on screenshot - this will be amazing!!!

[ansjcy]

This could potentially be an interesting task we can plan on as part of the query insight vision :)

While a lot of micro visibility data can be auto collected and displayed to the user by default with the query insight framework (opensearch-project/OpenSearch#11429) and dashboard (#5571), we cannot collect all of them since I imaging there would be a big performance impact. If the user wants to see the detailed time/resource consumption and some detailed profile data for one specific search query, this profiler dashboard would be very handy.