The sql_exporter has a number of features that make it much more suited to producing metrics from business data.
On Tue, Mar 30, 2021 at 3:37 PM Adrien <[email protected]> wrote: > Thank you, this was also my idea but I wanted to avoid using another > exporter for this. > > > Le mardi 30 mars 2021 à 14:53:36 UTC+2, [email protected] a écrit : > >> 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 >> >> On Tue, Mar 30, 2021 at 2:19 PM Adrien <[email protected]> wrote: >> >>> 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 >>> >>> -- >>> 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 [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/prometheus-users/3c6e79f3-1a05-44b0-9fff-f905d2cdf483n%40googlegroups.com >>> <https://groups.google.com/d/msgid/prometheus-users/3c6e79f3-1a05-44b0-9fff-f905d2cdf483n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/prometheus-users/f804006f-9bd4-49ac-a573-721a91ffbbf7n%40googlegroups.com > <https://groups.google.com/d/msgid/prometheus-users/f804006f-9bd4-49ac-a573-721a91ffbbf7n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CABbyFmrJzKwY%3Dd2LBgufuQKjwf6j2Hbj%2Bb5S7BRXTcwVdJ61aA%40mail.gmail.com.
