# Elasticsearch queries are slow
**URL:** https://discuss.elastic.co/t/elasticsearch-queries-are-slow/20477
**Category:** Elasticsearch
**Created:** [October 29, 2014, 11:02am UTC](https://discuss.elastic.co/t/elasticsearch-queries-are-slow/20477 "2014-10-29T11:02:37Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@appa](https://discuss.elastic.co/u/appa)
#### Post date: [October 29, 2014, 11:02am UTC](https://discuss.elastic.co/t/elasticsearch-queries-are-slow/20477/1 "2014-10-29T11:02:37Z")
I have 7 node of cluster. Each having configuration like 16G RAM, 8 Core
cpu, centos 6
Heap Memory is - 9000m
- 1 Master (Non data)
- 1 Capable master (Non data)
- 5 Data node
Having 10 indexes, one index is big with 55 million documents of number and
254Gi (508Gi)
size on disk.
Every 1 seconds there are 5-10 new documents indexing.
But problem is search is bit slow. Almost taking average of 2000 to 5000
ms. Some queries are in 1 secs.
Why is that so?
--
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/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@Alberto\_Paro\_2](https://discuss.elastic.co/u/Alberto_Paro_2)
#### Post date: [October 30, 2014, 12:54pm UTC](https://discuss.elastic.co/t/elasticsearch-queries-are-slow/20477/2 "2014-10-30T12:54:57Z")
How many shards? if your shards are too small in number, their size it's too big. Typical shards bigger than 10gb gives you bad performance both in writing and in reading due to segment operations.
hi,
Alberto
Sent from my iPhone
> On 29/ott/2014, at 12:02, Appasaheb Sawant [appasaheb.sawant@gmail.com](mailto:appasaheb.sawant@gmail.com) wrote:
>
> I have 7 node of cluster. Each having configuration like 16G RAM, 8 Core cpu, centos 6
>
> Heap Memory is - 9000m
>
> 1 Master (Non data)
> 1 Capable master (Non data)
> 5 Data node
> Having 10 indexes, one index is big with 55 million documents of number and 254Gi (508Gi)
> size on disk.
>
> Every 1 seconds there are 5-10 new documents indexing.
>
> But problem is search is bit slow. Almost taking average of 2000 to 5000 ms. Some queries are in 1 secs.
>
> ## Why is that so?
>
> 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/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com).
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
--
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/5F7A69E0-C3D6-4990-9F0B-0966D1D04D12%40gmail.com](https://groups.google.com/d/msgid/elasticsearch/5F7A69E0-C3D6-4990-9F0B-0966D1D04D12%40gmail.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@Jason\_Wee](https://discuss.elastic.co/u/Jason_Wee)
#### Post date: [October 30, 2014, 2:42pm UTC](https://discuss.elastic.co/t/elasticsearch-queries-are-slow/20477/3 "2014-10-30T14:42:08Z")
Will adding node improve the query time assuming the rest remain the same?
Jason
On Thu, Oct 30, 2014 at 8:54 PM, Alberto Paro [alberto.paro@gmail.com](mailto:alberto.paro@gmail.com)
wrote:
> How many shards? if your shards are too small in number, their size it's
> too big. Typical shards bigger than 10gb gives you bad performance both in
> writing and in reading due to segment operations.
>
> hi,
> Alberto
>
> Sent from my iPhone
>
> On 29/ott/2014, at 12:02, Appasaheb Sawant [appasaheb.sawant@gmail.com](mailto:appasaheb.sawant@gmail.com)
> wrote:
>
> I have 7 node of cluster. Each having configuration like 16G RAM, 8 Core
> cpu, centos 6
>
> Heap Memory is - 9000m
>
> - 1 Master (Non data)
> - 1 Capable master (Non data)
> - 5 Data node
>
> Having 10 indexes, one index is big with 55 million documents of number
> and 254Gi (508Gi)
> size on disk.
>
> Every 1 seconds there are 5-10 new documents indexing.
>
> But problem is search is bit slow. Almost taking average of 2000 to 5000
> ms. Some queries are in 1 secs.
>
> Why is that so?
>
> --
> 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/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com)
> [https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com?utm_medium=email&utm_source=footer)
> .
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
>
> --
> 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/5F7A69E0-C3D6-4990-9F0B-0966D1D04D12%40gmail.com](https://groups.google.com/d/msgid/elasticsearch/5F7A69E0-C3D6-4990-9F0B-0966D1D04D12%40gmail.com)
> [https://groups.google.com/d/msgid/elasticsearch/5F7A69E0-C3D6-4990-9F0B-0966D1D04D12%40gmail.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/5F7A69E0-C3D6-4990-9F0B-0966D1D04D12%40gmail.com?utm_medium=email&utm_source=footer)
> .
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
--
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/CAHO4itx6h\_L4DpM%2BK1UpM2LhVvPV5MJbZEbVi01vgBhNQ9Nh2Q%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAHO4itx6h_L4DpM%2BK1UpM2LhVvPV5MJbZEbVi01vgBhNQ9Nh2Q%40mail.gmail.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@appa](https://discuss.elastic.co/u/appa)
#### Post date: [October 31, 2014, 5:09am UTC](https://discuss.elastic.co/t/elasticsearch-queries-are-slow/20477/4 "2014-10-31T05:09:25Z")
I have 5 nodes, 10 shards and search shards having 45gb of data.
On Thursday, October 30, 2014 6:25:12 PM UTC+5:30, Alberto Paro wrote:
> How many shards? if your shards are too small in number, their size it's
> too big. Typical shards bigger than 10gb gives you bad performance both in
> writing and in reading due to segment operations.
>
> hi,
> Alberto
>
> Sent from my iPhone
>
> On 29/ott/2014, at 12:02, Appasaheb Sawant \<[appasahe...@gmail.com](mailto:appasahe...@gmail.com)
> \\> wrote:
>
> I have 7 node of cluster. Each having configuration like 16G RAM, 8 Core
> cpu, centos 6
>
> Heap Memory is - 9000m
>
> - 1 Master (Non data)
> - 1 Capable master (Non data)
> - 5 Data node
>
> Having 10 indexes, one index is big with 55 million documents of number
> and 254Gi (508Gi)
> size on disk.
>
> Every 1 seconds there are 5-10 new documents indexing.
>
> But problem is search is bit slow. Almost taking average of 2000 to 5000
> ms. Some queries are in 1 secs.
>
> Why is that so?
>
> --
> 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \.
> To view this discussion on the web visit
> [https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com)
> [https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com?utm_medium=email&utm_source=footer)
> .
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
--
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/c60dd472-842d-4875-82ac-489a3f67e4a9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/c60dd472-842d-4875-82ac-489a3f67e4a9%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@appa](https://discuss.elastic.co/u/appa)
#### Post date: [October 31, 2014, 5:14am UTC](https://discuss.elastic.co/t/elasticsearch-queries-are-slow/20477/5 "2014-10-31T05:14:01Z")
Thanks Alerto,
We have 5 nodes, 10 shards, 1 replace and each shard having 28GB of size.
Thanks.
On Thursday, October 30, 2014 6:25:12 PM UTC+5:30, Alberto Paro wrote:
> How many shards? if your shards are too small in number, their size it's
> too big. Typical shards bigger than 10gb gives you bad performance both in
> writing and in reading due to segment operations.
>
> hi,
> Alberto
>
> Sent from my iPhone
>
> On 29/ott/2014, at 12:02, Appasaheb Sawant \<[appasahe...@gmail.com](mailto:appasahe...@gmail.com)
> \\> wrote:
>
> I have 7 node of cluster. Each having configuration like 16G RAM, 8 Core
> cpu, centos 6
>
> Heap Memory is - 9000m
>
> - 1 Master (Non data)
> - 1 Capable master (Non data)
> - 5 Data node
>
> Having 10 indexes, one index is big with 55 million documents of number
> and 254Gi (508Gi)
> size on disk.
>
> Every 1 seconds there are 5-10 new documents indexing.
>
> But problem is search is bit slow. Almost taking average of 2000 to 5000
> ms. Some queries are in 1 secs.
>
> Why is that so?
>
> --
> 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \.
> To view this discussion on the web visit
> [https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com)
> [https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/275027ad-9edf-42a1-a8c5-5841210800a6%40googlegroups.com?utm_medium=email&utm_source=footer)
> .
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
--
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/b72aa427-0df1-4f00-bb24-f93fe2ec33d6%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/b72aa427-0df1-4f00-bb24-f93fe2ec33d6%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@panda2004](https://discuss.elastic.co/u/panda2004)
#### Post date: [June 20, 2017, 11:49pm UTC](https://discuss.elastic.co/t/elasticsearch-queries-are-slow/20477/6 "2017-06-20T23:49:39Z")
appa, are there any updates concerning your problem? We suffer from similar issues.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 4, 2022, 4:01am UTC](https://discuss.elastic.co/t/elasticsearch-queries-are-slow/20477/7 "2022-11-04T04:01:25Z")