Post by @jaz@toot.wales

2026-10-08 09:01 UTC

I have a need to know how many text posts, images, and videos this Mastodon server gets in a month, local and remote (separately). Or, from anyone else who has such data, what that looks like such that I can extrapolate a likely volume of all three stratified by local vs remote per e.g 1,000 active. If anyone has some handy dandy data and/or queries to run, I'd be extremely grateful. #MastoAdmin

Replies (1)

@galaxis@mastodon.infra.de 2026-10-10 13:28

@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...

Open ##5204408