# Slow Kibana Dashboard

**URL:** <https://discuss.elastic.co/t/slow-kibana-dashboard/94471>\
**Category:** Kibana\
**Created:** [July 25, 2017, 11:51am UTC](https://discuss.elastic.co/t/slow-kibana-dashboard/94471 "2017-07-25T11:51:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![N31LR](https://avatars.discourse-cdn.com/v4/letter/n/f0a364/32.png) [@N31LR](https://discuss.elastic.co/u/N31LR)\
**Post date:** [July 25, 2017, 11:51am UTC](https://discuss.elastic.co/t/slow-kibana-dashboard/94471/1 "2017-07-25T11:51:20Z")

</div>

I have a kibana visualisation that runs a query containing a wildcard

{  
"query\_string": {  
"query": "system.auth.message:Connection closed\*preauth\]",  
"analyze\_wildcard": true  
}  
}

When this query is ran in visualise page Query Duration = 100 ms and Request Duration = 180 ms  
When the visualisation is added to a dashboard (as the sole visualisation, no others exist on the dashboard), the dashboard and visualisation takes 15 seconds + to load.

Any ideas why the duration's would differ to such an extent?

Thanks

---

<div class="post-metadata">

**Author:** ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)\
**Post date:** [July 25, 2017, 9:28pm UTC](https://discuss.elastic.co/t/slow-kibana-dashboard/94471/2 "2017-07-25T21:28:17Z")

</div>

If it's the same visualization times should be very similar so I'm not sure offhand. Both requests will use an msearch, the difference being a dashboard tends to have more than one visualization requests.

Can you open the network tab in your developer tools and share the response times in dashboard vs visualize?

 ![](https://us1.discourse-cdn.com/elastic/original/3X/1/0/10a1e8dfd84719b945a59cb5d082db64bfb2b7a5.png)

Can you also share your kibana version?

---

<div class="post-metadata">

**Author:** ![N31LR](https://avatars.discourse-cdn.com/v4/letter/n/f0a364/32.png) [@N31LR](https://discuss.elastic.co/u/N31LR)\
**Post date:** [July 26, 2017, 7:13am UTC](https://discuss.elastic.co/t/slow-kibana-dashboard/94471/3 "2017-07-26T07:13:46Z")

</div>

> [@N31LR](#):
>
> system.auth.message:Connection closed\*preauth]

Hi Jon.

These are the msearch times from the visualisation screen, I ran it a few times to get the average, excluding the first run of 916ms once cached all others take around 100ms.

 ![](https://us1.discourse-cdn.com/elastic/original/3X/6/7/67e82b5946d33390e1d4919d3648317979b20a4f.png)

There are the msearch times for the dashboard screen, it only contains the one visualisation for testing this. again it was ran a few times to get the average, taking around 6seconds each time.

 ![](https://us1.discourse-cdn.com/elastic/original/3X/1/9/199c5321c1c775d4ce7eb24962cf8b57b58ad78b.png)

Originally I had two wildcard characters in the query, and it was taking 12 seconds, it looks like for each \* character added to the query, and additional 6 seconds is added to the query duration. Which I understand as a wildcard would be less performant. However this wouldn't explain the difference in duration between the visualisation screen and dashboard screen.

I am running kibana 5.4.1

Thanks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 23, 2017, 7:14am UTC](https://discuss.elastic.co/t/slow-kibana-dashboard/94471/4 "2017-08-23T07:14:04Z")

</div>

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