Slow aggregations query

(Alexander Burakovskiy) #1

I have a problem with queries with aggregations on a big index.
My aggregations are basically facets for students list, so I have high cardinality fields (education, skills, titles etc).
My environment:

CPU Count 4
System Memory 16Gb
EC2 Instance Type m4.xlarge

Count of documents 50M
Document has several nested objects, here is example

"education": [
"school": "Gemological Institute of America",
"degree": "Graduate jewller, Metal and Jewelry Arts, A",
"startDate": "2001-01-01T00:00:00+0000",
"endDate": "2002-01-01T00:00:00+0000"
"school": "University of Mumbai",
"degree": "Bachelors , Business/Commerce, General, A",
"startDate": "1998-01-01T00:00:00+0000",
"endDate": "2001-01-01T00:00:00+0000"

Here is example of query:

And it took over 3s.

I've tried to enable "eager_global_ordinals", but it didn't increase performance.

Is it possible to improve queries performance (decrease query time to less then 0.5s)?

(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.