Performance issue on some requests

[jprante (Jörg Prante)]

@RVillette

So, here is my question... How do you think we could reduce the CPU usage?
[...]
Other?

Do not execute range queries/filters on millisecond resolution fields, prefer seconds resolution if you want high performance.

Query much faster against timestamp in seconds than milliseconds

I have a query which is significantly faster if I run it against a field containing a timestamp in seconds instead of milliseconds. Query 1- uses timestampMilliseconds, averages 500ms to execute: { index: 'events', body: { query: { bool: { filter: { and: [ { term: { userId: ... } }, { range: { timestampMilliseconds: { lt: ... } } } ] } } } }, sort: 'timestampMilliseconds:desc', size: 300, requestTimeout…