I'm not sure how much flexibility you have, but have you taken a look at Prometheus (for time series data) + Grafana (for dashboards) I'm certainly not a DB ex

I'm not sure how much flexibility you have, but have you taken a look at Prometheus (for time series data) + Grafana (for dashboards) I'm certainly not a DB expert, but this is where a similar need led me a few months ago.