this post was submitted on 14 Feb 2025
867 points (99.3% liked)

Canada

7999 readers
2478 users here now

What's going on Canada?

Related Communities

🍁 Meta

πŸ—ΊοΈ Provinces / Territories

πŸ™οΈ Cities / Local Communities

Sorted alphabetically by city name.

πŸ’ SportsHockey

Football (NFL): incomplete

Football (CFL): incomplete

Baseball

Basketball

Soccer

πŸ’» Schools / Universities

Sorted by province, then by total full-time enrolment.

πŸ’΅ Finance, Shopping, Sales

πŸ—£οΈ Politics

🍁 Social / Culture

Rules

  1. Keep the original title when submitting an article. You can put your own commentary in the body of the post or in the comment section.

Reminder that the rules for lemmy.ca also apply here. See the sidebar on the homepage: lemmy.ca

founded 4 years ago
MODERATORS
otter
mp3
867
I had to do a double take when I saw Lemmy.ca spiked to 9.1k registered users (lemmy.ca)
submitted 1 week ago* (last edited 6 days ago) by Sunshine to c/canada
164 comments fedilink hide all child comments
 

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!

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 13 points 6 days ago (1 children)

Is this grafana public? I'd like to check for jlai.lu, we also had a recent influx of users.

[–] Shadow 28 points 6 days ago (2 children)

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:

[–] [email protected] 9 points 6 days ago

Nice, thank you!

[–] lemmyng 7 points 6 days ago (1 children)

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.

[–] [email protected] 6 points 6 days ago (1 children)

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

[–] Shadow 5 points 5 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.