Feel your pain! This was the idea behind query performance "bubbles" in Fleet. (Uses the osquery performance metadata to indicate whether performance impact of a query on a host is "minimal", "considerable", or "excessive")

Next step is "clairvoyance", where we predict perf based on the SQL when you're in the query editor