6 ms·

Grafana: Postgres Data Source

128 points by scrollaway 9y ago

reacharavindh 9y ago
Great timing. I was considering building a monitoring setup based on Influx and hookung up Grafana to it. Now, I can play with timescaledb and Grafana instead. Don’t know the technical advantages/disadvantages of timescaledb over influxdb. If any of you had any experiences with them, pls share.
- scrollaway 9y ago
  I haven't tried timescaledb yet because it's not available on RDS (see https://github.com/timescale/timescaledb/issues/65 https://github.com/timescale/timescaledb/issues/65 if you want it on RDS btw). But I really can't wait to try it. My understanding is that it's resource-hungrier than Influx but to be really honest, influx has been super unreliable for me with metrics disappearing, very hard to do maintenance on it (eg. how do I find out where my disk space usage lies? etc) Postgres' maturity is something I miss every single day I deal with influx. I trust postgres' data integrity and tooling every day of the week and I don't have that with Influx.
  - edejong 9y ago
    I have a very similar experience. Also the lack of support for any query more complicated than a freshman’s SQL is often bothering me.
  - RobAtticus 9y ago
    Hey, thanks for the shout out :) In terms of resource-hungry-ness, while we haven't done extensive benchmarking on memory & CPU against InfluxDB, we should compare fine on those resources. The one area we do fall behind is disk usage, but with ZFS or the like we can close the gap. Thanks for the support! Hopefully we can get it on RDS soon.
scrollaway 9y ago
It's in 4.6.0-beta1; I've been playing with it a bunch, it's really nice for single stat and when you have time series tables. Also worth bringing up: http://www.timescale.com http://www.timescale.com
sgt 9y ago
Anyone using Grafana in production? I would like to hear some opinions and experiences. I found it a bit disappointing as in; at first impression it really looks amazing, and the charts are stunning. However once you go into the knitty gritty and find lacking user/role/permissions management it was disappointing.
- scrollaway 9y ago
  Grafana is incredible and 4.6 fixes my two major issues with it (no cloudwatch alerting and no postgres support). It does take some training to get good at writing dashboards however. But it's free to try by either self-hosting it or with the personal plan on https://grafana.com https://grafana.com. Highly recommended either way.
- pimeys 9y ago
  I use Grafana for everything. At work a part of every feature I do is a Grafana graph to monitor when the feature goes to production. At home I graph my blood glucose having information such as A1c always available for me real time. Such a useful tool.
- Gonzih 9y ago
  Yes, we usa grafana in our team, but only isolated on internal network and with access only to 12 team members, so no real need for roles etc. We use zabbix, elasticsearch and graphite data sources. Works like a charm in our case, also embedded graphs are not ideal, but useful for internal dashboards and etc. So very positive experience so far. Before grafana integration we had kibana + graphite + zabbix as a 3 separate things.
- maaaats 9y ago
  Why would permissions matter so much? We use it, good experiences so far.
  - sgt 9y ago
    Giving different teams and outside partners (i.e. less trusted) access to a variety of dashboards, not just due to security but also to make it less confusing to these users.
stonewhite 9y ago
That is an unacceptably big change set for a proper review process.
- arianvanp 9y ago
  Seems to be a collection of many commits squashed into one. Probably during review, each commit was addresed.
quintin 9y ago
I first came to know about Grafana via the Wikipedia’s webpage performance management page: https://twitter.com/mediawiki/status/630865572654264320 https://twitter.com/mediawiki/status/630865572654264320 Interesting talk from the Wikipedia folks here: https://www.youtube.com/watch?v=UlL6UoRUQAM https://www.youtube.com/watch?v=UlL6UoRUQAM

128 points by scrollaway 9y ago

Great timing. I was considering building a monitoring setup based on Influx and hookung up Grafana to it. Now, I can play with timescaledb and Grafana instead. Don’t know the technical advantages/disadvantages of timescaledb over influxdb. If any of you had any experiences with them, pls share.

scrollaway 9y ago
I haven't tried timescaledb yet because it's not available on RDS (see https://github.com/timescale/timescaledb/issues/65 https://github.com/timescale/timescaledb/issues/65 if you want it on RDS btw). But I really can't wait to try it. My understanding is that it's resource-hungrier than Influx but to be really honest, influx has been super unreliable for me with metrics disappearing, very hard to do maintenance on it (eg. how do I find out where my disk space usage lies? etc) Postgres' maturity is something I miss every single day I deal with influx. I trust postgres' data integrity and tooling every day of the week and I don't have that with Influx.
- edejong 9y ago
  I have a very similar experience. Also the lack of support for any query more complicated than a freshman’s SQL is often bothering me.
- RobAtticus 9y ago
  Hey, thanks for the shout out :) In terms of resource-hungry-ness, while we haven't done extensive benchmarking on memory & CPU against InfluxDB, we should compare fine on those resources. The one area we do fall behind is disk usage, but with ZFS or the like we can close the gap. Thanks for the support! Hopefully we can get it on RDS soon.

scrollaway 9y ago

It's in 4.6.0-beta1; I've been playing with it a bunch, it's really nice for single stat and when you have time series tables. Also worth bringing up: http://www.timescale.com http://www.timescale.com

sgt 9y ago

Anyone using Grafana in production? I would like to hear some opinions and experiences. I found it a bit disappointing as in; at first impression it really looks amazing, and the charts are stunning. However once you go into the knitty gritty and find lacking user/role/permissions management it was disappointing.

scrollaway 9y ago
Grafana is incredible and 4.6 fixes my two major issues with it (no cloudwatch alerting and no postgres support). It does take some training to get good at writing dashboards however. But it's free to try by either self-hosting it or with the personal plan on https://grafana.com https://grafana.com. Highly recommended either way.
pimeys 9y ago
I use Grafana for everything. At work a part of every feature I do is a Grafana graph to monitor when the feature goes to production. At home I graph my blood glucose having information such as A1c always available for me real time. Such a useful tool.
Gonzih 9y ago
Yes, we usa grafana in our team, but only isolated on internal network and with access only to 12 team members, so no real need for roles etc. We use zabbix, elasticsearch and graphite data sources. Works like a charm in our case, also embedded graphs are not ideal, but useful for internal dashboards and etc. So very positive experience so far. Before grafana integration we had kibana + graphite + zabbix as a 3 separate things.
maaaats 9y ago
Why would permissions matter so much? We use it, good experiences so far.
- sgt 9y ago
  Giving different teams and outside partners (i.e. less trusted) access to a variety of dashboards, not just due to security but also to make it less confusing to these users.

stonewhite 9y ago

That is an unacceptably big change set for a proper review process.

arianvanp 9y ago
Seems to be a collection of many commits squashed into one. Probably during review, each commit was addresed.

quintin 9y ago

I first came to know about Grafana via the Wikipedia’s webpage performance management page: https://twitter.com/mediawiki/status/630865572654264320 https://twitter.com/mediawiki/status/630865572654264320 Interesting talk from the Wikipedia folks here: https://www.youtube.com/watch?v=UlL6UoRUQAM https://www.youtube.com/watch?v=UlL6UoRUQAM