Unified query detail panel aggregating all data for a single query

[erikdarlingdata]

Summary

Investigating a single query today means bouncing between views: find it in top queries, double-click for history, right-click for plan, switch to Query Store to see if it has a forced plan, check blocking to see if it's involved in locks.

Proposed Feature

A unified "query detail" panel (sidebar or overlay, not a modal) that aggregates everything known about a single query_hash in one place:

• Current stats: CPU, duration, reads, writes, execution count
• Trend chart: Duration/CPU over time (from query history)
• Plan analysis summary: Top warnings from PlanAnalyzer (missing indexes, implicit conversions, etc.)
• Blocking involvement: Was this query a blocker or victim? How often?
• Query Store status: Forced plan? Regressed? Multiple plans?
• Full query text: Scrollable, with copy button

Design Notes

• This is the natural endpoint of all the individual drill-downs that already exist
• Instead of five hops, one click
• Triggered by a context menu action ("View Query Details") or a dedicated button in any query grid
• Panel approach (sidebar/overlay) preferred over modal so users can still see the grid alongside
• Data sources all exist already — this is an aggregation/presentation feature
• Higher complexity: requires cross-cutting data fetch across multiple services
• Applies to both Dashboard and Lite

[erikdarlingdata]

Implementation order: Lite first, then port to Dashboard once the pattern is validated. This avoids the complexity of iterating on both apps simultaneously.