# Kibana not showing more than 30 million records from elasticsearch if records are more than that

**URL:** https://discuss.elastic.co/t/kibana-not-showing-more-than-30-million-records-from-elasticsearch-if-records-are-more-than-that/127064
**Category:** Kibana
**Created:** [April 6, 2018, 9:59am UTC](https://discuss.elastic.co/t/kibana-not-showing-more-than-30-million-records-from-elasticsearch-if-records-are-more-than-that/127064 "2018-04-06T09:59:41Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![raja\_gopal](https://avatars.discourse-cdn.com/v4/letter/r/ac8455/32.png) [@raja\_gopal](https://discuss.elastic.co/u/raja_gopal)
#### Post date: [April 6, 2018, 9:59am UTC](https://discuss.elastic.co/t/kibana-not-showing-more-than-30-million-records-from-elasticsearch-if-records-are-more-than-that/127064/1 "2018-04-06T09:59:41Z")

</div>

In our elasticsearch datastore there are more than 120 million records but kibana is pulling up only 30 million records. Is there any way to view all the records.

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [April 6, 2018, 10:43pm UTC](https://discuss.elastic.co/t/kibana-not-showing-more-than-30-million-records-from-elasticsearch-if-records-are-more-than-that/127064/2 "2018-04-06T22:43:09Z")

</div>

Can you provide more details? What application in Kibana are you trying to use? Where is the 30 million number coming from?

---

<div class="post-metadata">

### Author: ![raja\_gopal](https://avatars.discourse-cdn.com/v4/letter/r/ac8455/32.png) [@raja\_gopal](https://discuss.elastic.co/u/raja_gopal)
#### Post date: [April 9, 2018, 6:44am UTC](https://discuss.elastic.co/t/kibana-not-showing-more-than-30-million-records-from-elasticsearch-if-records-are-more-than-that/127064/3 "2018-04-09T06:44:44Z")

</div>

The 30 million records are syslog events. On an average there are events \> 100K coming within every 15 minutes. On dev tools i am able to query and get the actual number of records but in the discover tab if i chose the time period "This Year" i don't see more than 30 million events. Could you please help me ?

---

<div class="post-metadata">

### Author: ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)
#### Post date: [April 9, 2018, 3:00pm UTC](https://discuss.elastic.co/t/kibana-not-showing-more-than-30-million-records-from-elasticsearch-if-records-are-more-than-that/127064/4 "2018-04-09T15:00:22Z")

</div>

In the Discover app, can you open the network tab of your browser’s dev tools and grab the actual request being sent and received from elasticsearch? It should be a request to the `_msearch` endpoint. That should help us figure out if the problem lies in ES or kibana.

---

<div class="post-metadata">

### Author: ![raja\_gopal](https://avatars.discourse-cdn.com/v4/letter/r/ac8455/32.png) [@raja\_gopal](https://discuss.elastic.co/u/raja_gopal)
#### Post date: [April 10, 2018, 5:10am UTC](https://discuss.elastic.co/t/kibana-not-showing-more-than-30-million-records-from-elasticsearch-if-records-are-more-than-that/127064/5 "2018-04-10T05:10:58Z")

</div>

Thanks for your help. I fixed the issue; it was the timefield used in discover app was a wrong one. After changing, the discover tab is working fine.

---

<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: [May 8, 2018, 5:11am UTC](https://discuss.elastic.co/t/kibana-not-showing-more-than-30-million-records-from-elasticsearch-if-records-are-more-than-that/127064/6 "2018-05-08T05:11:01Z")

</div>

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