Also, if you *are* talking about prometheus-community/postgres_exporter, then note that pg_postmaster_start_time_seconds comes from the sample queries.yaml, which won't be used unless you're using the -extend.query-path flag or the PG_EXPORTER_EXTEND_QUERY_PATH environment variable to point to a copy of that file. See:
https://github.com/prometheus-community/postgres_exporter#adding-new-metrics-via-a-config-file https://github.com/prometheus-community/postgres_exporter/blob/v0.11.1/queries.yaml#L9-L15 On Monday, 23 January 2023 at 08:17:13 UTC Brian Candler wrote: > Do you really mean "postgres_db_exporter", or do you mean > "postgres_exporter", i.e. this one? > https://github.com/prometheus-community/postgres_exporter > > Maybe you have the wrong values for 'release' and 'instance' labels. What > happens if you query: > > pg_postmaster_start_time_seconds > > without any label filters? (You can do this in prometheus's own web > interface). > > If that doesn't return anything, then are you getting *any* metrics from > the exporter at all? For example, if your scrape job has > > - job_name: 'postgres' > > then you can try querying > > {job="postgres"} > > If that query shows nothing, then probably your scrapes aren't working at > all. Look in the Prometheus web interface under Status > Targets. > > On Monday, 23 January 2023 at 06:22:25 UTC [email protected] wrote: > >> hello , >> >> I am not able find metrics having * pg_postmaster_start_time_seconds.* >> >> *postres_exporter version *0.11.1 >> *DB version : 12.12.0* >> >> >> pg_postmaster_start_time_seconds{release="$release", >> instance="$instance"} * 1000 >> >> thanks >> >> prashant >> > -- 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/e6317fa7-224b-4b0f-97c3-e2ca8fca0f1cn%40googlegroups.com.
