Title
#fleet
Mystery Incorporated

Mystery Incorporated

12/02/2021, 5:07 AM
Hi all, what's the secret to getting the query performance impact instead of them all being undetermined?
5:12 AM
And yet when I look at a pack on an individual host, literally every single query is marked as excessive, is that normal?
5:13 AM
Doesn't the watchdog protect us from excessive stuff?
Tomas Touceda

Tomas Touceda

12/02/2021, 11:13 AM
hi there! the overall query performance is aggregated across all runs. You can check the logs and see if you find any occurrences of "err" and "aggregating"
Rachel Perkins

Rachel Perkins

12/02/2021, 2:13 PM
Hi -- so it should show Undetermined if the query has never been executed, Minimal if the average usertime + the average system time is under 2000, Considerable under 4000 and Excessive if it's over that. Not really useful information if they're all Undetermined or all Excessive, or is it?
Gavin

Gavin

12/02/2021, 5:54 PM
The behaviour I have seen is it’s only populated if it’s a live query vs content of a traditional Query pack
Mystery Incorporated

Mystery Incorporated

12/03/2021, 5:45 AM
Hi all, yes they are part of query packs. So I guess it says undefined in the main view because they are from a query pack? But when I look at each individual host, they all say Excessive