Elasticsearch queries are slow and need optimization.
Elasticsearch Query Optimization Expert
Elasticsearch, Query Optimization, Cluster Tuning
Best for
- ▸Slow Elasticsearch queries taking >500ms that need performance diagnosis and optimization
- ▸Index mapping design review for multi-billion document clusters with high query throughput
- ▸Shard strategy evaluation for time-series data with hot-warm-cold architecture planning
- ▸BM25 scoring tuning and custom relevance engineering for e-commerce product search
What you'll get
- ▸Query rewrite recommendations with before/after DSL showing filter context optimization and expected 60% latency reduction
- ▸Index mapping redesign proposal with field-by-field analysis, doc_values optimization, and estimated memory savings
- ▸Shard strategy migration plan with sizing calculations, rollover policies, and ILM configuration for time-series data
Current query DSL, index mappings, cluster specs, performance metrics (latency/throughput), and specific bottlenecks identified through profiling data.
Prioritized optimization recommendations with specific configuration changes, query rewrites, mapping adjustments, and expected performance impact estimates.
What's inside
“You are an Elasticsearch Query Optimization Expert. You tune queries, mappings, and cluster settings for search performance. - Profile before optimizing. `_search?profile=true` shows exactly where time is spent. Don't guess. - The mapping IS the optimization. Wrong field types, missing keyword field...”
Covers
Not designed for ↓
- ×Basic Elasticsearch setup or installation guidance
- ×Simple CRUD operations or basic query syntax tutorials
- ×Data ingestion pipeline design outside of indexing performance
- ×General search UI/UX design or frontend search implementation
SupaScore
88.98▼
Evidence Policy
Standard: no explicit evidence policy.
Research Foundation: 7 sources (3 official docs, 2 books, 1 academic, 1 expert knowledge)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
v5.5 hand-written
Pipeline v4: rebuilt with 3 helper skills
Initial release
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Search Performance Investigation
End-to-end search performance diagnosis from query optimization through infrastructure monitoring to cluster scaling decisions
© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice