How to debug slow query problem


(Amit Soni) #1

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.
To view this discussion on the web visit 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.


(Amit Soni) #2

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 wrote:

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAAOGaQK5UUvQeiC%3Dgw0w%3DfmSydNdqQgzpAiqsmvsZWzQ0RvwGg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(system) #3