# How to improve performance in this case?

**URL:** <https://discuss.elastic.co/t/how-to-improve-performance-in-this-case/196267>\
**Category:** Elasticsearch\
**Created:** [August 22, 2019, 7:59am UTC](https://discuss.elastic.co/t/how-to-improve-performance-in-this-case/196267 "2019-08-22T07:59:59Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Bertrand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bertrand/32/45679_2.png) [@Bertrand](https://discuss.elastic.co/u/Bertrand)\
**Post date:** [August 23, 2019, 9:17am UTC](https://discuss.elastic.co/t/how-to-improve-performance-in-this-case/196267/6 "2019-08-23T09:17:12Z")

</div>

Have a look at [Slow date\_histogram after upgrading to 7.3.0 on "dense" indexes](https://discuss.elastic.co/t/slow-date-histogram-after-upgrading-to-7-3-0-on-dense-indexes/196475).

We experienced exactly the same symptoms as you and could reproduce it with a sample dataset. The query profiler shows that the query phase is fast, but most of the time is spent in the _collect_ phase.

---

_[View the full topic](https://discuss.elastic.co/t/how-to-improve-performance-in-this-case/196267)._