# Slow query in python

**URL:** <https://discuss.elastic.co/t/slow-query-in-python/156715>\
**Category:** Elasticsearch\
**Created:** [November 14, 2018, 5:02pm UTC](https://discuss.elastic.co/t/slow-query-in-python/156715 "2018-11-14T17:02:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Artem\_Sh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/artem_sh/32/37638_2.png) [@Artem\_Sh](https://discuss.elastic.co/u/Artem_Sh)\
**Post date:** [November 14, 2018, 5:02pm UTC](https://discuss.elastic.co/t/slow-query-in-python/156715/1 "2018-11-14T17:02:16Z")

</div>

Hello.

I start Elasticsearch in local machine.  
Index "wbtm\_cities"  
Documents: **1.8k**  
Data: **66.3 MB**  
Total Shards: **1**  
Unassigned Shards: **0**  
Fields:  
[http://take.ms/0haXq](http://take.ms/0haXq)  
[http://take.ms/am2mS](http://take.ms/am2mS)

I do query:  
GET wbtm\_cities/doc/\_search  
{  
"query": {  
"bool": {  
"filter": [  
{  
"term": {  
"domain": "[site.ru](http://site.ru)"  
}  
},  
{  
"term": {  
"is\_big": "1"  
}  
}  
]  
}  
},  
"from": 0,  
"size": 200,  
"\_source": {  
"includes": [  
"name",  
"slug",  
"declension\_rus"  
]  
}  
}

Speed first query in kibana: 7-65 ms - [http://take.ms/xNIF1](http://take.ms/xNIF1), [http://take.ms/YFpue](http://take.ms/YFpue)  
In second time kibana return 1ms  
But then I use Python requests speed low: 200-300ms

1800 document it no many to slow query

1. Why first Kibana connection is slow?
2. Why python requests is slow?

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [November 14, 2018, 5:07pm UTC](https://discuss.elastic.co/t/slow-query-in-python/156715/2 "2018-11-14T17:07:48Z")

</div>

Does the time it takes in Python include creating the client and setting up the connection, or is it just the query time?

---

<div class="post-metadata">

**Author:** ![Artem\_Sh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/artem_sh/32/37638_2.png) [@Artem\_Sh](https://discuss.elastic.co/u/Artem_Sh)\
**Post date:** [November 14, 2018, 5:14pm UTC](https://discuss.elastic.co/t/slow-query-in-python/156715/3 "2018-11-14T17:14:56Z")

</div>

Python client setting up the connection not longer 1-5ms. Then I connect to [wikipedia.com](http://wikipedia.com) this client it's not slow.

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [November 14, 2018, 5:19pm UTC](https://discuss.elastic.co/t/slow-query-in-python/156715/4 "2018-11-14T17:19:25Z")

</div>

OK, so you are not using the official Elasticsearch Python client?

---

<div class="post-metadata">

**Author:** ![Artem\_Sh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/artem_sh/32/37638_2.png) [@Artem\_Sh](https://discuss.elastic.co/u/Artem_Sh)\
**Post date:** [November 14, 2018, 5:47pm UTC](https://discuss.elastic.co/t/slow-query-in-python/156715/5 "2018-11-14T17:47:28Z")

</div>

I use this library - [https://elasticsearch-dsl.readthedocs.io/en/latest/](https://elasticsearch-dsl.readthedocs.io/en/latest/)  
And I use straight query

the result is the same

---

<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 12, 2018, 5:47pm UTC](https://discuss.elastic.co/t/slow-query-in-python/156715/6 "2018-12-12T17:47:34Z")

</div>

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