Monitoring Postgresql

[zamek z]

Hi All,

I'm new in prometheus, and I need a solution, to monitoring my postgresql database. Which reporter do you suggest to do it? I need simply to get an element counts in a table. 

thx,

Zamek

[Ben Kochie]

There are two different things here. There is monitoring PostgreSQL itself, and there's also generating metrics from "business data" in the database.

For "business data", you want to use an SQL exporter. There are several options here.

https://github.com/free/sql_exporter

https://github.com/justwatchcom/sql_exporter

https://github.com/albertodonato/query-exporter

For PostgreSQL, the database server, you want to use the postgres_exporter.

https://github.com/wrouesnel/postgres_exporter

--
You received this message because you are subscribed to the Google Groups "Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/d8e565e5-b7b5-4a6d-b724-ece13b74ba61o%40googlegroups.com.

[zamek z]

Hi Ben,

Thx that's I needed, an sql exporter

On Friday, June 19, 2020 at 2:05:48 PM UTC+2, Ben Kochie wrote:

There are two different things here. There is monitoring PostgreSQL itself, and there's also generating metrics from "business data" in the database.

For "business data", you want to use an SQL exporter. There are several options here.

https://github.com/free/sql_exporter

https://github.com/justwatchcom/sql_exporter

https://github.com/albertodonato/query-exporter

For PostgreSQL, the database server, you want to use the postgres_exporter.

https://github.com/wrouesnel/postgres_exporter

On Fri, Jun 19, 2020 at 1:56 PM zamek z <zam...@gmail.com> wrote:

Hi All,

I'm new in prometheus, and I need a solution, to monitoring my postgresql database. Which reporter do you suggest to do it? I need simply to get an element counts in a table. 

thx,

Zamek

--
You received this message because you are subscribed to the Google Groups "Prometheus Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to promethe...@googlegroups.com.