Most efficient query to filter a large number of tag values while peforming a group by

@scott unfortunately they do not. The list of hosts comes from a business application which in almost all cases would never have a common pattern