Performance issues when returning many ids

Hello,
I have a search index with 200.000 documents, and experience bad performance when performing searches that returns multiple results.

Each document consists of 1040 fields all mapped as keywords. See filemapping below.

When performing a query that returns approx 140.000 ids, the "took" time from elastic is around 10.000ms.

Is there anything obviously wrong with this setup / way of indexing documents?

I am aware of the fact that using from: 0, to:1000000 is not ideal, but if i use a PIT, and fetches in batches, it takes approx 1100ms pr batch of 10000 documents, which gives a total time spent on ~15.000ms

mapping


query
time

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