Graph data from HGETALL

[redisgrafana]

Graph data from HGETALL

[lexicalunit]

It's something I'm developing. I'm just trying to figure out how to do something like "counts by day" which seems to be really freaking difficult or else I'm just using the wrong tools. I'm using RedisCloud for my redis hosting and I'm not sure I have access to the time series module, at least not without paying (I'm on the free plan right now). At least, the TS commands don't seem to work on my cli when I connect to the db.

[mikhail-vl]

Here is the blog how I did something similar: https://redislabs.com/blog/how-to-use-the-new-redis-data-source-for-grafana-plug-in/

[lexicalunit]

Thanks for the blog post, I'll dig into this!

[mikhail-vl]

Hello @lexicalunit, thank you for submitting the issue.

My initial analysis is that HGETALL returns each column as a string or number and Grafana expects time to be a time.Time type. I have to take a closer look.
Is it an existing project or you are developing it? Hash is not the best data type to store time-series data. I would recommend taking a look at RedisTimeSeries which is fully supported in the plug-in.

Please let me know if RedisTimeSeries works. I will investigate and get back to you.

[mikhail-vl]

@lexicalunit Redis Cloud has a RedisTimeSeries module available in AWS/Mumbai region. All modules are a part of Pro subscriptions in all regions.

You can add your data to RedisTimeSeries and then aggregate values per day: https://oss.redislabs.com/redistimeseries/commands/#tsrangetsrevrange
You can try using Docker: docker run -p 6379:6379 -it --rm redislabs/redistimeseries.

I am still checking regarding the graph.

[lexicalunit]

@mikhailredis I don't see that option here: https://elements.heroku.com/addons/rediscloud#details

[mikhail-vl]

@lexicalunit, I was talking about Redis Cloud Essential, which you can try for free https://redislabs.com/try-free/ and it's available in Oregon (us-west-2) region.

Please let me know if you have any questions.

[lexicalunit]

Ah, I was trying to stay within the ecosystem of heroku. Ty for the info tho!

[mikhail-vl]

@lexicalunit RedisTimeSeries is available in Heroku if you want to give it a try.
Are you still developing your application using Hashes? In the upcoming version, the hash will be represented as fields instead of rows, to be able to stream it.

We can implement a special option to display hash as time-series if you are still interested.

[lexicalunit]

@mikhailredis I switched over to using a read-only account via a postgresql data source for a lot of the graphs I wanted to create. I'm still using redis for some metrics that I want to display though.

For the redis panels I just have to manually get many multiple values individually as their own series and then display them as a bar graph. For example:

For the postgresql panels I'm able to just have one single series in grafana that uses a GROUPY BY to identify the individual lines dynamically based on the data itself. It's not clear to me that something like this would even be possible with redis:

[mikhail-vl]

@lexicalunit You can use Hash to store metrics and display them as bar graphs in the upcoming version using HGETALL or HMGET commands.

Regarding the Postgres query, as I said before it can be done using RedisTimeSeries, which is now available in Heroku.
You can add time-series samples for data using TS.ADD command with labels and then display using TS.MRANGE command.

Please let me know if you have any questions.

[mikhail-vl]

I am going ahead and close this issue. Let me know if you need anything else.