@jaz@toot.wales I have a job in my monitoring that uses these queries to estimate local and remote posts received (for the past five minutes, since that's the job interval - should be adaptable for a month, with an appropriately increased query limit): select count(id) from (select id,created_at,local from statuses order by id desc limit 1000) AS slast where slast.created_at >= now() - INTERVAL '5 minutes' and local='t'; select count(id) from (select id,created_at,local from statuses order by id desc limit 1000) AS slast where slast.created_at >= now() - INTERVAL '5 minutes' and local='f'; Also have some adhoc queries for media statistics stashed away somewhere that I need to find...