GROUP BY/Aggregation is blocking operations (Needs group /aggregate all results first). That is taking time .