# Does Kibana supports a big csv exports?

**URL:** <https://discuss.elastic.co/t/does-kibana-supports-a-big-csv-exports/256714>\
**Category:** Kibana\
**Created:** [November 25, 2020, 8:58pm UTC](https://discuss.elastic.co/t/does-kibana-supports-a-big-csv-exports/256714 "2020-11-25T20:58:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ayadi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ayadi/32/78063_2.png) [@Ayadi](https://discuss.elastic.co/u/Ayadi)\
**Post date:** [November 25, 2020, 8:58pm UTC](https://discuss.elastic.co/t/does-kibana-supports-a-big-csv-exports/256714/1 "2020-11-25T20:58:17Z")

</div>

Hi Guys I'm facing a problem with the exports in Kibana since a week now and I will be happy, if I can get some help here.  
I want to generate big csv reports from kibana that could reach 3 Gb  
And I was surprised that every time when I want to export more than 300mb file from Kibana Elasticsearch get killed automatically.

I run KIbana as follow

```auto
NODE_OPTIONS="--max-old-space-size=4096" ./bin/kibana 

```

and ELS as follow:

```auto
bin/elasticsearch

```

my configuration in Kibana.yml is

```auto
xpack.security.encryptionKey : "EePXCifCaykPORwjqKGbINHCPFYnNXZT"
elasticsearch.requestTimeout: 900000
xpack.reporting.queue.timeout: 120000000
xpack.reporting.encryptionKey: "EePXCifCaykPORwjqKGbINHCPFYnNXZT"
xpack.reporting.csv.maxSizeBytes: 400000000 
xpack.encryptedSavedObjects.encryptionKey: "EePXCifCaykPORwjqKGbINHCPFYnNXZT"
csp.strict: true
xpack.reporting.enabled: true
logging.verbose: true
server.maxPayloadBytes: 10485760  

```

and in elasticsearch.yml is:

```auto
indices.breaker.total.use_real_memory : false 
http.max_content_length: 500mb

```

and my jvm.options config is as follow:

```auto
-Xms4g
-Xmx4g

```

so when I try to download a reporting from KIbana which will have a 400mb as a size based on my config Kibana get automatically killed

```auto
log [16:58:23.585] [warning][csv][execute-job][khz2to7r0wtld0ca1c33bvgg][reporting] max Size Reached
  log [16:58:23.586] [debug][csv][execute-job][khz2to7r0wtld0ca1c33bvgg][reporting] executing clearScroll request
  log [16:58:23.588] [debug][csv][execute-job][khz2to7r0wtld0ca1c33bvgg][reporting] finished generating, total size in bytes: 1048575667
  log [16:58:31.248] [info][esqueue][queue-worker][reporting] khz2q2s00wtld0ca1c77dr67 - Job execution completed successfully
Killed

```

So I wanna ask if I'm doing something wrong ?  
I will appreciate every help from you guys!

---

<div class="post-metadata">

**Author:** ![Patrick\_Mueller](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/patrick_mueller/32/109425_2.png) [@Patrick\_Mueller](https://discuss.elastic.co/u/Patrick_Mueller)\
**Post date:** [November 26, 2020, 4:52am UTC](https://discuss.elastic.co/t/does-kibana-supports-a-big-csv-exports/256714/2 "2020-11-26T04:52:07Z")

</div>

There's some previous discussion on this topic, here: [Csv file export with 1 million records(approx 1 gb size) in kibana reporting](https://discuss.elastic.co/t/csv-file-export-with-1-million-records-approx-1-gb-size-in-kibana-reporting/222892)

I don't know if you're doing anything wrong, but I believe that is pushing the limits of what Kibana can do.

---

<div class="post-metadata">

**Author:** ![Ayadi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ayadi/32/78063_2.png) [@Ayadi](https://discuss.elastic.co/u/Ayadi)\
**Post date:** [November 26, 2020, 4:58pm UTC](https://discuss.elastic.co/t/does-kibana-supports-a-big-csv-exports/256714/3 "2020-11-26T16:58:33Z")

</div>

But I'm not using logstasch to download the csv, I downloading it from the browser(KIbana localhost).  
I'm just asking if it is possible to download a csv file bigger than 3Gb or not ?  
if yes what should the configs look like in elasticsearch.yml , kibana.yml and jvm.options  
Thx

---

<div class="post-metadata">

**Author:** ![Ayadi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ayadi/32/78063_2.png) [@Ayadi](https://discuss.elastic.co/u/Ayadi)\
**Post date:** [November 26, 2020, 6:37pm UTC](https://discuss.elastic.co/t/does-kibana-supports-a-big-csv-exports/256714/4 "2020-11-26T18:37:02Z")

</div>

@Elastic Team Member I will appreciate any help !! ☹

---

<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:** [December 24, 2020, 6:37pm UTC](https://discuss.elastic.co/t/does-kibana-supports-a-big-csv-exports/256714/5 "2020-12-24T18:37:09Z")

</div>

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