Kibana: How to get the Elasticsearch query forged by Kibana

[HRonan]

Hi,

I am seeking how to get the Elasticsearch query forged by Kibana with the interface. May be there is a javascript function used to create the query, or a variable where the query is saved?

For example when a dashboard is created with its different search parameters, a query is sent to elasticsearch. I would to know if it is possible to get this query with javascript function or variable.

Thank you for your time and consideration.
Ronan

[stigdescamps]

Hi,

Once you created your Kibana searches, go to the "DOCUMENTS" panel where you see the results and then click on the "i" on the top right of this panel.
Here, you will see appear what you are looking: a window with the elasticsearch query named "Last Elasticsearch Query".

Regards,
SD

[HRonan]

Thank you.
I have noticed a little bug with this option. The "i" disappears when a scripting dashboard (script/dashboard.js) is used (with options in url...).

[spalger]

Thanks for your help @stigdescamps

[mikee805]

Is there away to do this in Kibana 4 ?

Thanks,
Mike

[spalger]

@mikee805 hopefully you found the little caret at the bottom of visualizations, which shows more information about how the data was fetched.

[ajferrick]

@spalger :trophy: perfect explanation.

[mikee805]

@spalger Thanks that's exactly what i needed maybe we can get some hover text on the carrot, please?

[jansegre]

What about Kibana 5 (5.4)? I can't find any documentation on this.

[Grundlefleck]

@jansegre I found this for Kibana 5. It's very similar to what @spalger said, except it looks slightly different:

Hit the little grey caret at the bottom left, then select Request.

[ianina9395]

How to do it if index does not contain time-based events?
I do not have any visualisation on Discover page, just query results.
Kibana 5.4.

[bw2]

I don't see a way to do this in the current version - in terms of how to see the query that was sent to elasticsearch to get the results:

[OliwiaW]

Works perfectly for Discover page, but does anyone know how about Timelion page? Is there a possibility to see its queries? Thanks !

[thethomp]

I'm also interested in finding the queries generated by a Timelion visualization!

[thorro]

Was this functionality removed from Discover? There's no caret anymore.

[PhilNoir]

Can't find caret, too. Using Kibana Version: 6.4.2

[rainiera]

In Kibana 6.5.0, from the Discover and Visualize pages, you can get the underlying query by clicking on Inspect button on the top-right:

and then navigating to View: Requests > Request tab on the pane that pops up on the right:

and scrolling down to find the query.

[maozi07]

Hey,how to get query for the visualize type is Visual Builder in kibana 6.6X

[avnerbarr]

I don't have the "inspect" button in 6.4.2

How do I get that?

[alnutile]

I had to go into Management -> Saved Objects