Kibana visualization query very slow compared to console

Using Kibana 7.9.0, with ES 7.9.0.

Running a visualization with date historgram and terms aggregation, the query takes 1800ms according Kibana inspect panel, but the same ES query takes only 20 ms when running on the console app.

In the browser AJAX debug, I can see multiple HTTP calls to /s/qwantcom/internal/search/es , every 100ms, the last give the query response:

id: "Fkp4cW5sd1AxUVlpbVJBZTkzY2J0WHceUm5FOXJvUWVTYk9wSnMtMm5mNkg3dzo5OTY1MzM5"
is_partial: false
is_running: false
loaded: 2
rawResponse: {took: 1829 .....

  1. Why there are 5 HTTP queries for only 1 ES query?
  2. Why this query takes 1829ms whereas the same query (I copy paste the 1st AJAX call request) takes 20ms ?

We found latest Kibana very slow compared to ... version 4, is it possible?

First request to Elasticsearch is the longest, for subsequent requests with the same query, the results are cached in ES. Is the difference of a similar magnitude when refreshing the query after the first load?
Also, for Kibana 7.9.0 being slower, there are a lot more apps now than in 4.x, plus in 7.10.0 there have been a lot of performance improvements (this is one of the main points of the new version release)

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.