Help with SQL query Postgres and use result for chart

We have just started a proof-of-concept for monitoring PostgreSQL databases using Netdata. A lot of what we monitor manually is based up SQL queries of the database. I saw an example of how to query Mysql using the Pandas collector and another entry from 2017 for mysql. Does anyone have an example of how to do the same thing in Postgres?

Hi, @mlknez.

  • Postgres collector does not support custom queries.
  • Pandas collector is unmaintained. The person who wrote it no longer works for Netdata. Can’t help with it.
  • I think the only way is using sql_exporter to query Postgres/expose metrics and Netdata to scrape it (storing and visualization).