2026-05-02 01:06 UTC
Average age of accounts being banned, grouped by instance:
SELECT
i.domain AS instance,
AVG(EXTRACT(EPOCH FROM (NOW() - u.created)) / (60*60*24)) AS avg_account_age_days
FROM mod_log ml
INNER JOIN "user" u ON ml.target_user_id = u.id
INNER JOIN instance i ON u.instance_id = i.id
WHERE ml.action = 'ban_user'
AND i.domain IN ('lemmy.ml', 'lemmy.dbzer0.com', 'lemmy.world', 'piefed.social',
'lemmy.blahaj.zone', 'pawb.social', 'lemmy.ca', 'sh.itjust.works',
'lemmy.zip', 'feddit.org', 'programming.dev', 'discuss.tchncs.de',
'sopuli.xyz', 'lemmy.today', 'slrpnk.net', 'beehaw.org', 'jlai.lu')
GROUP BY i.domain
ORDER BY avg_account_age_days DESC;
lemmy.dbzer0.com is towards the young side but not really out of the ordinary. It’s the instances like lemmy.today, lemmy.zip and piefed.social that are unusual.
Replies (0)
No replies.