# Kibana TSVB performance

**URL:** <https://discuss.elastic.co/t/kibana-tsvb-performance/222774>\
**Category:** Kibana\
**Created:** [March 9, 2020, 5:56pm UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774 "2020-03-09T17:56:25Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![akrzos](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@akrzos](https://discuss.elastic.co/u/akrzos)\
**Post date:** [March 9, 2020, 5:56pm UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/1 "2020-03-09T17:56:26Z")

</div>

I am creating some visualizations with Kibana using the TSVB visualizations and find that the load time for the create page is very slow. During this time period it seems that the kibana instance handling the request is pegging to a 100% cpu. Are there any tunables to improve the performance of Kibana?

Any recommendations in terms of sizing the VM hosting Kibana (CPU and Memory)? It seems that adding more cpus won't help since the process seems constrained to a single cpu.

Thanks

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [March 11, 2020, 5:57am UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/2 "2020-03-11T05:57:55Z")

</div>

cc @Marius_Dragomir @LeeDr

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [March 12, 2020, 9:56am UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/3 "2020-03-12T09:56:50Z")

</div>

Do you have monitoring enabled for ES and Kibana? Would be interesting to see the charts for that. TSVB also queried all indices by default in older versions of Kibana, so that would be an issue as well. What version are you using?

---

<div class="post-metadata">

**Author:** ![akrzos](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@akrzos](https://discuss.elastic.co/u/akrzos)\
**Post date:** [March 12, 2020, 1:32pm UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/4 "2020-03-12T13:32:56Z")

</div>

Hi Marius,

We do have monitoring enabled. If I use chrome dev tools, the page load hangs on the `fields?index=` consistently for 40-60s. I then adjusted the memory of the vm hosting kibana from 2GiB to 4GiB and that query is taking 20s so there was some large jump in performance based on the vm sizing change. Is that large enough or should the VM be provisioned larger?

Also we are running kibana 7.5.0-1. Which version has the fix for not querying all indexes?

-Alex

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [March 12, 2020, 1:38pm UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/5 "2020-03-12T13:38:02Z")

</div>

The size should be good enough, i'd look more into increasing the CPU and Memory for the ES cluster. Do you also have a large number of fields on your index?

---

<div class="post-metadata">

**Author:** ![akrzos](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@akrzos](https://discuss.elastic.co/u/akrzos)\
**Post date:** [March 13, 2020, 1:34pm UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/6 "2020-03-13T13:34:47Z")

</div>

It is my understanding based on chrome dev tools that simply clicking create TSVB it seems it is trying to load all fields across all indexes - `fields?index=`. According to some of our index patterns we have upwards of 3400+ filebeat fields, 2500+ metricbeat fields and several other index patterns that would have many more fields.

View attached screenshot of issue

 ![Poor-tsvb-load-time](https://us1.discourse-cdn.com/elastic/original/3X/0/5/05916b165740d2960a1b00d3d383ad851bf1f3d8.png)

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [March 13, 2020, 2:36pm UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/7 "2020-03-13T14:36:00Z")

</div>

Sadly yes. It's a legacy issue due to how TSVB communicates with ES. Other visualizations use the index cache so they don't do this request. There is ongoing work on transitioning TSVB to this, but it will take a while as it's a rather big undertaking.

---

<div class="post-metadata">

**Author:** ![akrzos](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@akrzos](https://discuss.elastic.co/u/akrzos)\
**Post date:** [March 13, 2020, 3:21pm UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/8 "2020-03-13T15:21:54Z")

</div>

Got it so this isn't fixed in 7.5 then and not fixed in 7.6 either yet? Compared to another ES+Kibana cluster we don't see this issue but there are less fields in the indexes and less index patterns.

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [March 13, 2020, 3:24pm UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/9 "2020-03-13T15:24:21Z")

</div>

No, it's not gonna be any different. The amount of fields and indices is why this happens only one your one cluster.

---

<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:** [April 10, 2020, 3:24pm UTC](https://discuss.elastic.co/t/kibana-tsvb-performance/222774/10 "2020-04-10T15:24:23Z")

</div>

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