mirror of
https://github.com/fleetdm/fleet
synced 2026-04-21 13:37:30 +00:00
9dc573fb17
Resolves #41540 * Added new computed column to determinate whether query_result has data. * Added new index to query_results to to cover all query patterns. * Refactored queries used in host report page to improve performance. * Fixed various bugs with around query filtering for host reports.
2 lines
No EOL
219 B
Text
2 lines
No EOL
219 B
Text
* Improved database query performance for the Host Details > Reports page by adding a `has_data` virtual generated column to `query_results`.
|
|
* Added `(query_id, has_data, host_id, last_fetched)` index on query_results. |