They must be those cool folks from r/onguardforthee and r/fredericton! Lets get off those american Reddit servers eh!

Update: there’s a thread on r/buycanadian with 93 upvotes, promoting the platform! Open the floodgates baby!

  • ShadowA
    28·
    4 days ago

    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:

    • lemmyngEnglish
      7·
      4 days ago

      A suggestion from someone who frequently deals with observability infrastructure: it’s a good idea to set up a postgres exporter and record your data as Prometheus metrics, that way querying the metrics does not hit any of the production stack.

      • tetris11@lemmy.ml
        6·
        4 days ago

        Prometheus is the goat, and is built into a surprisingly large amount of FOSS service tools. JupyterHub for example includes Prometheus metrics out of the box

        • ShadowA
          5·
          3 days ago

          Eh. Calling it the goat is excessive. I’m planning to go victoriametrics instead.

          Yes the exporter format is common and widely supported though, which is nice.