Notices by halcy​:icosahedron: (halcy@icosahedron.website), page 17

Note to self maybe pay your membership dues at some point

Yall and your C3s.

@codl idk you're.... same size as i.w. I guess, slightly larger

so that's probably smallish?

in any case thank you

p.s. these are probably Very slow and the third one is the most interesting for me

oh yeah LB watch this it's very good

@bea @Gargron (I _can_ compare weekly posts, so that's useful, I guess)

@bea @Gargron activity endpoint counts logged-in users, but I want this as a baseline for comparison with sth where I only know about users that actually posted a thing

@Gargron like what? also I mostly want to compare this to stats from a place where I most definitely can only look at rate of public posts / number of publicly active users

@Gargron willllll they slow an instance down if ran? if so, oops (they ran just fine on i.w., but there probably just aren't that many posts here so)

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!)

@revenant they're best friends and they go on adventures imo

how isn't there any unix that has a Command Lion as mascot

@bea in Germany, what we say is "Muss ja."