What time of the day is email communication highest in Alioth projects? (07-2011)


This chart shows the hourly breakdown of email communication in select Alioth projects. The projects shown had the highest total number of emails in their mailing lists.


SQL Script

SELECT COUNT(m.message_id), hour(m.date_sent)
FROM al_messages m
INNER JOIN al_mailing_lists l
ON l.mailing_list = m.mailing_list
WHERE l.project = 'project_name'
AND l.datasource_id = <current>
GROUP BY HOUR(m.date_sent)

alioth-email-traffic.png16.89 KB