Hi Guys,
First of all thanks for taking the time to read my topic.
I have create two indexex:
First one: has 7 shards and the second has 4.
Basically I did a reindex from test_2 to test_3 so they contain the same documents and the same mappings. Could someone let me know why the same query takes much more on the second index test_3?
The query is a terms query with 5 inner terms on to another.
Basically in the first index it take less than a second will on the second it take about 4 seconds to execure
I have forgedSegments to 1 to both of the indexes.
The query more specifically is
GET test/_search?size=10000
{
"aggs" : {
"countries" : {
"aggs" : {
"countryName": {
"terms": {
"field": "countryName"
},
"aggregations": {
"region": {
"terms": {
"field": "region"
},
"aggregations": {
"municipality": {
"terms": {
"field": "municipality"
},
"aggregations": {
"town": {
"terms": {
"field": "town"
},
"aggregations": {
"postalCode": {
"terms": {
"field": "postalCode"
}
}
}
}
}
}
}
}
}
}
},
"date_range": {
"field": "@timestamp",
"ranges": [
{ "from": "1123164501234", "to": "1123265505678" }
]
}
}
}
}