Post #1929115

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.