# How to debug slow query problem **URL:** \ **Category:** Elasticsearch\ **Created:** [July 28, 2014, 7:20am UTC](https://discuss.elastic.co/t/how-to-debug-slow-query-problem/18923 "2014-07-28T07:20:50Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Amit\_Soni](https://avatars.discourse-cdn.com/v4/letter/a/c0e974/32.png) [@Amit\_Soni](https://discuss.elastic.co/u/Amit_Soni)\ **Post date:** [July 28, 2014, 7:20am UTC](https://discuss.elastic.co/t/how-to-debug-slow-query-problem/18923/1 "2014-07-28T07:20:50Z")
Hi all - We have elastic search cluster wherein each node has the following characteristics: 1. Holds 11-12 shards 2. 12 GB memory 3. No memory or I/O or any such resource constraint observed For queries, we see that elastic search takes from around 5 seconds to 20 seconds to respond. This response time varies a lot over the entire day. Can you pl let us know if there is any way for us to identify where the time is being spent in a given query request? -Amit. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAAOGaQ%2Bh\_ajT\_sQeuJR5F9w5PZceARJY%2B3T15g8POi6GXUD5%2BQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAAOGaQ%2Bh_ajT_sQeuJR5F9w5PZceARJY%2B3T15g8POi6GXUD5%2BQ%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Amit\_Soni](https://avatars.discourse-cdn.com/v4/letter/a/c0e974/32.png) [@Amit\_Soni](https://discuss.elastic.co/u/Amit_Soni)\ **Post date:** [July 29, 2014, 11:28pm UTC](https://discuss.elastic.co/t/how-to-debug-slow-query-problem/18923/2 "2014-07-29T23:28:27Z")
also just to add: each of these nodes hold around 35GB of data. any recommendation? -Amit. On Mon, Jul 28, 2014 at 12:20 AM, Amit Soni [amitsoni29@gmail.com](mailto:amitsoni29@gmail.com) wrote: > Hi all - We have Elasticsearch cluster wherein each node has the > following characteristics: > > 1. Holds 11-12 shards > 2. 12 GB memory > 3. No memory or I/O or any such resource constraint observed > > For queries, we see that Elasticsearch takes from around 5 seconds to 20 > seconds to respond. This response time varies a lot over the entire day. > > Can you pl let us know if there is any way for us to identify where the > time is being spent in a given query request? > > -Amit. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAAOGaQK5UUvQeiC%3Dgw0w%3DfmSydNdqQgzpAiqsmvsZWzQ0RvwGg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAAOGaQK5UUvQeiC%3Dgw0w%3DfmSydNdqQgzpAiqsmvsZWzQ0RvwGg%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:12am UTC](https://discuss.elastic.co/t/how-to-debug-slow-query-problem/18923/3 "2017-07-06T01:12:22Z")