I'm trying to approximately graph how many new toots my instance has received. Does Mastodon keep track somewhere?
My current approach is to get the last 1000 entries from the statuses table (way too much, but reasonably quick thanks to the index on statuses.id) and then count those that were created in the past five minutes. I'm using munin, which polls for data about every five minutes - it's jittery thanks to cron and the variable run time of other plugins...
Doesn't take deletions into account, but I currently have no good idea where those would be visible in the database. Current graph looks like this for the past hour that I have data for:
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!