In addition to what Fanis mentioned, we have some performance improvements for

group_by

in

29.0.rc19

. So you want to try upgrading to that. I'd also recommend enabling caching for that query using the

use_cache=true

parameter (default TTL is 60s)