From Top N Lists to Visual Analytics: Query Insights Dashboard in OpenSearch
summary
OpenSearch captures query execution metrics with minimal overhead and surfaces Top N queries by latency, CPU and memory, showing P90 and P99 statistics and per-index/user breakdowns. A Live Queries page lists active and recently completed tasks; a configuration page sets window size, grouping and exporters (S3 exporter planned). A query profiler reruns queries with profile=true and returns shard-level search vs aggregation time plus downloadable JSON. Dashboard visuals (line charts, heat maps, timelines) reveal trends that logs and tables hide.
AI-written summary · about
chapters (9)
- 0:00Query Insights Dashboard intro
- 1:28Live Queries page overview
- 3:14Top queries setup
- 4:58Performance charts & heatmaps
- 7:46Query details & source analysis
- 8:50Query profiler breakdown
- 10:36Query Insights vs Slow Logs
- 13:04Custom dashboards with Query Insights
- 14:26Q&A
related talks
17mMastering the Query Insights Dashboard in OpenSearch
20mUnified Performance Observability in OpenSearch: Integrating Workload Management and Query Insights
20mMeasuring Data with OpenSearch to Better Serve the Community
20mExtending OpenSearch Dashboards: Building a Unified Obser...
04mOpenSearch Performance and Monitoring
06mWhy OpenSearch?
18mEnhance Query Execution Visibility in OS with OpenTelemetry
06mSponsored Keynote: OpenSearch - See Everything: Open Observability for Agentic AI