High CPU usage in facet query

(Tarun Bedi) #1


I am running a facet query and I have 2m docs indexed, when I am doing load testing (15 queries per second) then cpu usage is 400% and response time also increases.

4 nodes on a single machine with 1gb ram assigned to each node.

Here is the query that I am firing

"size": 0,
"query": {
"range": {
"gte": 0
"facets": {
"f": {
"terms": {
"field": "TOTAL_SCORE",
"size": 10000

Can any one suggest what's going wrong over here.

(Mark Walkom) #2

I'd suggest moving to or trying aggs, they are a lot more efficient.

(Tarun Bedi) #3

Thanks Warkolm,

But I have tried that also but I have not find any significant performance gain, cpu still shoots out.

(Mark Walkom) #4

Maybe try with a single node at 4GB ram then, 1Gb isn't much heap for ES to work with.

(system) #5