# This was run using pydruid like so: # pydruid http://druid1001.eqiad.wmnet/druid/v2/sql/ select uri_host,count(*) from webrequest_sampled_128 where uri_path like '/api/rest_v1/page/graph/png/%%' group by(uri_host) order by count(*) desc;