cargo-bins / cargo-quickinstall

pre-compiled binary packages for `cargo install`
Apache License 2.0
218 stars 11 forks source link

shared grafana org for cargo-bins #279

Open alsuren opened 2 months ago

alsuren commented 2 months ago
          Data has moved to a different org which uses infuxdb iox (which doesn't support dashboards yet). I will delete the old one and re-invite everyone to the new org.

I have also made a public dashboard at https://alsuren.grafana.net/public-dashboards/12d4ec3edf2548a1850a813e00592b53 (which I will also move soon).

_Originally posted by @alsuren in https://github.com/cargo-bins/cargo-quickinstall/pull/165#discussion_r1749179931_

Unless grafana wants to give us an enterprise org, I will probably just make a new email address cargo-bins@gmail.com or something and set that up with a grafana account.

The dashboards from influxdb iox are a bit non-existent, but I have the following snippet in their data explorer if you want to do some messing about with the data:

https://us-east-1-1.aws.cloud2.influxdata.com/orgs/d44c7fc1cf1e3ea5/data-explorer?fluxScriptEditor

-- If you stumbled across this saved script in data explorer, you need to:
-- * disable SQL Sync
-- * select Bucket: cargo-quickinstall
-- * select Measurement: counts
-- * hit RUN
-- (the UI for this is a bit shocking).
--
-- I will make a shared grafana dashboard soon, but for now you can explore
-- the readonly one at:
-- https://alsuren.grafana.net/public-dashboards/12d4ec3edf2548a1850a813e00592b53

SELECT
  date_bin_gapfill(INTERVAL '10 minutes', time) AS time,
  crate,
  -- TODO: divide through by the interval to make this into a rate instead?
  sum("count") AS count
FROM "counts"
-- TODO: does influx ui give us variables for the start and end of the range,
-- like how grafana does?
WHERE time >= now() - interval '1 day' and time <= now()
GROUP BY 1, crate