Open tbar0970 opened 4 years ago
This query is taking about 10 seconds for a system with lots of services.
I think the temp table is inevitable when group-by and distinct is in the mix. But we might need to find a way to avoid joining on to so many services to get the last usage and 12m count.
Hitting again. Large temp table sometimes runs into disk space issues. See also #718