Slow querying of Elasticsearch data using Python

Hi. I would like to ask for advice. I'm just new to Elasticsearch.
I'm using Python to GET and PROCESS data from Elasticsearch.
But I'm having a hard time in retrieving data from Elasticsearch...

It took me 15 hours to get 3M rows of data.
Here's the snapshot of my code and it's result

This is my query:

Any help guys on how will I be able to retrieve millions of data faster?

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