Conversation

hey if you run a mid size to large mastodon instance, want to run the following things in the masto console and tell me the output? I need some values for comparison

Status.local.where('created_at > ?', 1.day.ago).count('distinct account_id')

Status.local.where('created_at > ?', 7.day.ago).count('distinct account_id')

Status.local.where('created_at > ?', 31.day.ago).count('distinct account_id')

(counts daily/weekly/monthly distinct users that posted at least once. boosts appreciated!)