# Elasticsearch Search Qurery Taking Time **URL:** \ **Category:** Elasticsearch\ **Created:** [May 2, 2016, 7:30am UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930 "2016-05-02T07:30:23Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![krish0608](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/krish0608/32/6797_2.png) [@krish0608](https://discuss.elastic.co/u/krish0608)\ **Post date:** [May 2, 2016, 7:30am UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/1 "2016-05-02T07:30:23Z")
Hi, I am facing problem in my Elasticsearch in production envoirnment.We currently have 3 Elasticsearch nodes in production with 27GB of memory for each instance for a total of 81GB of memory for the entire cluster. Of that 81GB of memory about 4% of it is dedicated to the filter cache. My Search Query is taking so much of time. Index Activity Indexing - Index: 0ms 1.43ms 1.67ms 1.93ms Indexing - Delete: 0ms 0ms 0ms 0ms Search - Query: 0ms 4172.88ms 4018.64ms 5483.46ms Search - Fetch: 0ms 6.36ms 8.09ms 8.69ms Get - Total: 0ms 0.49ms 0.58ms 0.7ms Get - Exists: 0ms 0.49ms 0.58ms 0.7ms Get - Missing: 0ms 0.19ms 0.19ms 0.32ms Refresh: 0ms 43.87ms 50.41ms 57.94ms Flush: 0ms 91.95ms 97.73ms 109.56ms please Guyz help me out. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [May 2, 2016, 7:36am UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/2 "2016-05-02T07:36:42Z")
Have you looked at hot\_threads? Are you monitoring your cluster for things like load, cache use, GC etc? ---
**Author:** ![krish0608](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/krish0608/32/6797_2.png) [@krish0608](https://discuss.elastic.co/u/krish0608)\ **Post date:** [May 2, 2016, 8:50am UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/3 "2016-05-02T08:50:50Z")
Thanks for reply, My Field Evictions is more. Cache Activity Field Size: 0.0 0.0 0.0 0.0 Field Evictions: 0 45,309 50,100 52,767 Filter Cache Size: 0.0 1.4GB 1.4GB 1.4GB Filter Evictions: 0 per query 0.2 per query 0.2 per query 0.2 per query ID Cache Size: % ID Cache: 0% 19.9% 21.4% 16.3% & my GC is Perfect. Memory Total Memory: 14 gb 27 gb 27 gb 27 gb Heap Size: 7 gb 14 gb 14 gb 14 gb Heap % of RAM: 50.9% 50.8% 50.8% 50.8% % Heap Used: 13.9% 58.8% 50% 59.9% GC MarkSweep Frequency: 0 s 0 s 0 s 0 s GC MarkSweep Duration: 0ms 0ms 0ms 0ms GC ParNew Frequency: 0 s 0 s 0 s 0 s GC ParNew Duration: 0ms 0ms 0ms 0ms G1 GC Young Generation Freq: 0 s 0 s 0 s 0 s G1 GC Young Generation Duration: 0ms 0ms 0ms 0ms G1 GC Old Generation Freq: 0 s 0 s 0 s 0 s G1 GC Old Generation Duration: 0ms 0ms 0ms 0ms Swap Space: 0.0000 MB 0.0000 MB 0.0000 MB 0.0000 MB ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [May 2, 2016, 10:03pm UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/4 "2016-05-02T22:03:47Z")
Check hot threads as well. ---
**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:** [May 3, 2016, 6:05am UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/5 "2016-05-03T06:05:48Z")
Which version of Elasticsearch are you using? How much data do you have in the cluster? What is the average and max shard size? What is the specification of your hardware? ---
**Author:** ![krish0608](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/krish0608/32/6797_2.png) [@krish0608](https://discuss.elastic.co/u/krish0608)\ **Post date:** [May 3, 2016, 10:35am UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/6 "2016-05-03T10:35:02Z")
I am using 1.7.4 Es version & i have 20 shards & 1 replica set & I have 3 data node & 1 master node. I have 20cr data in my Es. I have 3 Elasticsearch nodes in production with 27GB of memory for each instance for a total of 81GB of memory for the entire cluster. Of that 81GB of memory about 4% of it is dedicated to the filter cache. But my CPU is of 4-core but utilization is 92% & 14GB is still left in memory. ---
**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:** [May 3, 2016, 10:38am UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/7 "2016-05-03T10:38:41Z")
> [@krish0608](#): > > I have 20cr data in my Es. I do not understand. How large are your shards in GB? How much data do you have in them? ---
**Author:** ![krish0608](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/krish0608/32/6797_2.png) [@krish0608](https://discuss.elastic.co/u/krish0608)\ **Post date:** [May 3, 2016, 11:23am UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/8 "2016-05-03T11:23:17Z")
I have total 20 crore data in my Es. And on each Node i have 27GB data. ---
**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:** [May 3, 2016, 11:59am UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/9 "2016-05-03T11:59:23Z")
Please use units that are well recognised worldwide. It will make it a lot easier for people to understand and help out. I now understand that you have 200 million documents indexed. Is it correct that you have 27GB of indexed data and 27GB or RAM on each node in the cluster? What type of queries are you running that is taking that long? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 5, 2017, 10:54pm UTC](https://discuss.elastic.co/t/elasticsearch-search-qurery-taking-time/48930/10 "2017-07-05T22:54:25Z")