postgres exporter custom query

[Adrien]

Hi,

I need to export the result of a postgres select query, I tried to use a postgres exporter (https://github.com/prometheus-community/postgres_exporter) but there is a glitch: it seems there is no way to run custom queries on specific database: they are ran on every db, leading to errors in logs, there is an enhancement request about that. (https://github.com/prometheus-community/postgres_exporter/issues/443) 

Does someone have an idea how to workaround this ?

Thanks

[Ben Kochie]

I would recommend using the SQL exporter. The postgres_exporter is meant to provide metrics about the PostgreSQL server, not the data in databases.

https://github.com/free/sql_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/3c6e79f3-1a05-44b0-9fff-f905d2cdf483n%40googlegroups.com.

[Adrien]

Thank you, this was also my idea but I wanted to avoid using another exporter for this.

[Ben Kochie]

The sql_exporter has a number of features that make it much more suited to producing metrics from business data.

To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/f804006f-9bd4-49ac-a573-721a91ffbbf7n%40googlegroups.com.