prometheus-community / prometheus-community/postgres_exporter
Cannot Connect Postgresql database to Grafana Dashboard using Postgres Exporter
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 3.6k
- Forks
- 835
- Avg merge
- 2d 4h
- Merged PRs (30d)
- 10
Description
Hello, I'm creating a dashboard database using Postgres Exporter, Prometheus, and Grafana. But it seems the database is not connected to the grafana dashboard because there is no data and the database not appear on dashboard. Then i check Prometheus, there is no query for pg_stat?
The only queries available are pg_exporter_last_scrape_duration_seconds, pg_up, pg_exporter_last_scrape_error, pg_exporter_scrapes_total.
So basically, I'm missing some metrics from the PostgreSQL exporter.
Can anyone help me on how to resolve this? Thank you.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by checking the Postgres Exporter, Prometheus, and Grafana configuration against the reported metric output. Confirm why only exporter health metrics are available and determine whether pg_stat metrics are expected to appear. Done means the missing PostgreSQL metrics are exposed, collected by Prometheus, and available in the Grafana dashboard.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- grafana, postgresql, prometheus
- Domain
- databases, observability
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100