# Kibana crashes during getting all documents from Elasticsearch

**URL:** <https://discuss.elastic.co/t/kibana-crashes-during-getting-all-documents-from-elasticsearch/118955>\
**Category:** Kibana\
**Created:** [February 8, 2018, 2:19am UTC](https://discuss.elastic.co/t/kibana-crashes-during-getting-all-documents-from-elasticsearch/118955 "2018-02-08T02:19:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cheleyace](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cheleyace/32/27504_2.png) [@cheleyace](https://discuss.elastic.co/u/cheleyace)\
**Post date:** [February 8, 2018, 2:19am UTC](https://discuss.elastic.co/t/kibana-crashes-during-getting-all-documents-from-elasticsearch/118955/1 "2018-02-08T02:19:56Z")

</div>

Dear all,

I would like to know how to get all the documents in Elasticsearch? I know that the default value of getting the elasticsearch was 10 and can still get up to 10,000. It seems that Kibana cannot handle the large number of data whenever I'm querying to get data. Is there any way how to get all the documents without affecting the Kibana or gettin' errors? Thank you so much.

I also found another approach to get all the data from elasticsearch using Python. Now my problem is how would I connect it to Elasticsearch? I tried using Python method and i got these errors. Can anyone help me on this?

GET [YOURHOST.us-east-1.es.amazonaws.com](http://YOURHOST.us-east-1.es.amazonaws.com) [status:404 request:1.197s]  
Traceback (most recent call last):  
File "\<pyshell#19\>", line 1, in  
es.search(index="my\_index-2018.02.06")  
File "C:\Users\summer.lively\AppData\Local\Programs\Python\Python37\lib\site-packages\elasticsearch\client\utils.py", line 73, in wrapped  
return func(\*args, params=params, \*\*kwargs)  
File "C:\Users\summer.lively\AppData\Local\Programs\Python\Python37\lib\site-packages\elasticsearch\client\_init.py", line 632, in search  
doc\_type, '\_search'), params=params, body=body)  
File "C:\Users\summer.lively\AppData\Local\Programs\Python\Python37\lib\site-packages\elasticsearch\transport.py", line 312, in perform\_request  
status, headers, data = connection.perform\_request(method, url, params, body, ignore=ignore, timeout=timeout)  
File "C:\Users\summer.lively\AppData\Local\Programs\Python\Python37\lib\site-packages\elasticsearch\connection\http\_requests.py", line 90, in perform\_request  
self.\_raise\_error(response.status\_code, raw\_data)  
File "C:\Users\summer.lively\AppData\Local\Programs\Python\Python37\lib\site-packages\elasticsearch\connection\base.py", line 125, in \_raise\_error  
raise HTTP\_EXCEPTIONS.get(status\_code, TransportError)(status\_code, error\_message, additional\_info)  
elasticsearch.exceptions.NotFoundError: TransportError(404, 'index\_not\_found\_exception', 'no such index')

Thank you all.

---

<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:** [February 8, 2018, 6:05pm UTC](https://discuss.elastic.co/t/kibana-crashes-during-getting-all-documents-from-elasticsearch/118955/2 "2018-02-08T18:05:12Z")

</div>

For Kibana this is not really feasible, as it's limited by the maximum payload it can get from Elasticsearch and on how it can process all the data. This is why Kibana usually asks for aggregations from Elasticsearch and Elasticsearch does all the heavy workload.

As for the Python issue, that is a question for the Elasticsearch forums, here: [https://discuss.elastic.co/c/elasticsearch](https://discuss.elastic.co/c/elasticsearch)

---

<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:** [March 8, 2018, 6:05pm UTC](https://discuss.elastic.co/t/kibana-crashes-during-getting-all-documents-from-elasticsearch/118955/3 "2018-03-08T18:05:30Z")

</div>

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