Web developer. Lead developer of PieFed

  • 4 Posts
  • 21 Comments
Joined 2 years ago
cake
Cake day: January 4th, 2024

help-circle







  • Average age of accounts being banned, grouped by instance:

    image

    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.