Obtain from the new metrics DB the relays' ratios

Child of #313.

This could be accomplished by implementing the exporter either:

• in sbws
• in onbasca
• in bwauthealth (implies getting files from collector and parsing them)
• from the bandwidth files via the "new db"

I think the last way is preferred.

added Next Sponsor 112 Q3 S112-O3 labels

marked this issue as related to #313

Maybe #320 (closed) and #321 (closed) should be labels for this metric.

In any case, this metric should have information about the relays' flags (guard, exit, etc.) that can be retrieved from the consesuses.

mentioned in issue #305 (closed)

marked this issue as related to tpo/network-health/metrics/monitoring-and-alerting#29 (closed)

assigned to @juga

marked this issue as related to #305 (closed)

added Doing label and removed Next label

changed title from Create prometheus node exporter with relays' ratios to Obtain from the new metrics DB the relays' ratios

Changed title cause at the moment we don't need a node exporter as we can directly create SQL queries from the new DB in grafana.

In concrete to extract the ratios as time series per relay, the query can be like:

SELECT
    time,
    greatest(r_strm, r_strm_filt) as ratio,
FROM bandwidth_record
where  $__timeFilter("time") and (node_id = '$node_id' or nick = '$nick')  and r_strm != 0;

Though to solve the parent tickets this query have to be combined with others.

i think this issue can be closed and continue to work on the parent issues.

closed

Added time spent in September

added 15m of time spent