Query Store collector is slow

[erikdarlingdata]

Problem

The Query Store collector is noticeably slower than other collectors, visible in Lite's Collection Health > Duration Trends chart. This adds latency to each collection cycle and could cause cascading delays.

How to Reproduce

1. Open Lite, connect to a server with Query Store enabled
2. Go to Collection Health > Duration Trends
3. Observe the query store collector line is significantly higher than others

Expected Behavior

Query Store collection should complete in a reasonable time, comparable to other collectors.

Investigation Needed

• Profile the Query Store collector query to identify bottlenecks
• Check if Query Store cleanup/compaction is affecting read performance
• Consider if the collector query can be optimized (e.g., narrower time window, fewer columns, Query Store hints)

[erikdarlingdata]

Fixed by PR #137 (CTE optimization) and PR #152 (incremental collection). Query store collector dropped from ~2,300ms to ~100-200ms.