# The number of indexes is increasing day by day, and the kibana dashboard shows that indexes are getting slower and slower

**URL:** <https://discuss.elastic.co/t/the-number-of-indexes-is-increasing-day-by-day-and-the-kibana-dashboard-shows-that-indexes-are-getting-slower-and-slower/280618>\
**Category:** Kibana\
**Tags:** docker\
**Created:** [August 6, 2021, 7:25am UTC](https://discuss.elastic.co/t/the-number-of-indexes-is-increasing-day-by-day-and-the-kibana-dashboard-shows-that-indexes-are-getting-slower-and-slower/280618 "2021-08-06T07:25:09Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![yt\_h](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yt_h/32/79484_2.png) [@yt\_h](https://discuss.elastic.co/u/yt_h)\
**Post date:** [August 6, 2021, 7:25am UTC](https://discuss.elastic.co/t/the-number-of-indexes-is-increasing-day-by-day-and-the-kibana-dashboard-shows-that-indexes-are-getting-slower-and-slower/280618/1 "2021-08-06T07:25:09Z")

</div>

elastic search version：7.5.1  
kibana：7.5.1

3 master roles, 3 data roles, 6 nodes in total.  
It takes a few minutes to query the index, this is the fragmentation state.

```auto
GET _cluster/health
{
   "cluster_name": "elasticsearch",
   "status": "green",
   "timed_out": false,
   "number_of_nodes": 6,
   "number_of_data_nodes": 3,
   "active_primary_shards": 8806,
   "active_shards": 17427,
   "relocating_shards": 1,
   "initializing_shards": 0,
   "unassigned_shards": 0,
   "delayed_unassigned_shards": 0,
   "number_of_pending_tasks": 1,
   "number_of_in_flight_fetch": 0,
   "task_max_waiting_in_queue_millis": 0,
   "active_shards_percent_as_number": 100.0
}

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/3/d3d919a619d7807c9817404e22c294f9986aa812.png)

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/7/8777b118e45086f4639967336f8e4b2b7039c02c.png)

Are there any optimization suggestions that can make the query faster.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 8, 2021, 11:29pm UTC](https://discuss.elastic.co/t/the-number-of-indexes-is-increasing-day-by-day-and-the-kibana-dashboard-shows-that-indexes-are-getting-slower-and-slower/280618/2 "2021-08-08T23:29:14Z")

</div>

> [@yt\_h](#):
>
> ```auto
> "number_of_data_nodes": 3,
> "active_primary_shards": 8806,
> "active_shards": 17427,
> 
> ```

That is why, you need to massively reduce the number of shards you have.

> [@yt\_h](#):
>
> Elasticsearch version：7.5.1

7.5 is [EOL](https://www.elastic.co/support/eol), please upgrade 🙂

---

<div class="post-metadata">

**Author:** ![yt\_h](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yt_h/32/79484_2.png) [@yt\_h](https://discuss.elastic.co/u/yt_h)\
**Post date:** [August 9, 2021, 8:45am UTC](https://discuss.elastic.co/t/the-number-of-indexes-is-increasing-day-by-day-and-the-kibana-dashboard-shows-that-indexes-are-getting-slower-and-slower/280618/3 "2021-08-09T08:45:40Z")

</div>

Thank you for your reply. My elasticsearch stores all the company's logs. The index is created every day and needs to be kept for a certain period of time. Lead to too many shards. I need to ask for some help here, or upgrade to 7.14. Will there be a higher performance improvement?

---

<div class="post-metadata">

**Author:** ![yt\_h](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yt_h/32/79484_2.png) [@yt\_h](https://discuss.elastic.co/u/yt_h)\
**Post date:** [August 9, 2021, 8:49am UTC](https://discuss.elastic.co/t/the-number-of-indexes-is-increasing-day-by-day-and-the-kibana-dashboard-shows-that-indexes-are-getting-slower-and-slower/280618/4 "2021-08-09T08:49:53Z")

</div>

For example, some parameter settings

---

<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:** [September 6, 2021, 8:50am UTC](https://discuss.elastic.co/t/the-number-of-indexes-is-increasing-day-by-day-and-the-kibana-dashboard-shows-that-indexes-are-getting-slower-and-slower/280618/5 "2021-09-06T08:50:30Z")

</div>

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