halcy:icosahedron:
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!)
halcy:icosahedron:
@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)
halcy:icosahedron:
@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
halcy:icosahedron:
@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
halcy:icosahedron:
@bea @Gargron (I _can_ compare weekly posts, so that's useful, I guess)
halcy:icosahedron:
p.s. these are probably Very slow and the third one is the most interesting for me
halcy:icosahedron:
@codl idk you're.... same size as i.w. I guess, slightly larger
so that's probably smallish?
in any case thank you
halcy:icosahedron:
@nightpool @codl ty this helps a lot
senooken JP Social is a social network, courtesy of senooken. It runs on GNU social, version 2.0.2-beta0, available under the GNU Affero General Public License.
All senooken JP Social content and data are available under the Creative Commons Attribution 3.0 license.