Infrastructure nerd, gamer, and Lemmy.ca maintainer

  • 78 Posts
  • 1.38K Comments
Joined 2 years ago
cake
Cake day: June 22nd, 2023

help-circle










  • No, I want to start exposing a grafana instance but for now I’m keeping this internal since it hits our live postgres.

    The query if you want it is:

    SELECT
      DATE(published AT TIME ZONE 'UTC') AS date,
      COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'lemmy.ca')) AS lemmy_ca,
      COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'sh.itjust.works')) AS sh_itjust_works,
      COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'lemmy.world')) AS lemmy_world,
      COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'lemmy.dbzer0.com')) AS dbzer0,
      COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'jlai.lu')) AS jlai_lu,
      count(*) as all_lemmy
    FROM person
    GROUP BY 1
    ORDER BY 1;
    

    Or here’s your instance overlayed with us to provide a comparison: