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
jaz :twt: :wales_flag: ⁂
npub1hg…enwn8
2026-10-08 09:01:08 UTC
Author Public Key
npub1hg6ku0pxvl5ta6d0suz9rauk8chdd57vy90z3p83u98eay8z902suenwn8Seen on
wss://relay.momostr.pinkPublished at
2026-10-08 09:01:08 UTCEvent JSON
{
"id": "697cc0db7cd9af9d8f0d1585b1f09b989ff8c399110421f6d763eb247d843a36",
"pubkey": "ba356e3c2667e8bee9af870451f7963e2ed6d3cc215e2884f1e14f9e90e22bd5",
"created_at": 1791450068,
"kind": 1,
"tags": [
[
"t",
"mastoadmin"
],
[
"proxy",
"https://toot.wales/@jaz/117404471661117955",
"web"
],
[
"proxy",
"https://toot.wales/users/jaz/statuses/117404471661117955",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://toot.wales/users/jaz/statuses/117404471661117955",
"pink.momostr"
],
[
"-"
]
],
"content": "I have a need to know how many text posts, images, and videos this Mastodon server gets in a month, local and remote (separately). \n\nOr, 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.\n\n#MastoAdmin",
"sig": "3b92bb5fc94af725cc524316d901d2e76b98209194727c813405f252010f9028b5cebf38b41a3b94bbc91c56aa0b25aedf02ecdb215aff885c69cbd3c4f409ad"
}