Requests Total
select count(*),virtual_domain from log_entries group by virtual_domain;

Requests per Day
select count(*),request_time::date,virtual_domain from log_entries group by virtual_domain,request_time::date;

Unique Hits
select count(distinct (remote_host)),virtual_domain from log_entries group by virtual_domain;

Unique Hits per Day
select count(distinct (remote_host)),request_time::date,virtual_domain from log_entries group by virtual_domain,request_time::date;

Downloads
select count(*),virtual_domain from log_entries where request like '%tar.gz%' group by virtual_domain;