prometheus-community / prometheus-community/postgres_exporter
Add support for metrics from pg_stat_user_indexes?
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 3.6k
- Forks
- 835
- Avg merge
- 2d 4h
- Merged PRs (30d)
- 10
Description
Proposal
Stats from the pg_stat_user_indexes group are very useful in general.
One particular use case I have is figuring out unused indexes, which is hard to do without metrics over time.
I'm secretly hoping I'm missing something, because as soon as I turned this exporter on I expected to see information about indexes and I couldn't find any and couldn't find where to enable them.
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
The issue names no files or tests. Start by reviewing the exporter’s existing PostgreSQL statistics collectors and how metric groups are enabled, then compare them with pg_stat_user_indexes. Done means the requested index statistics are exposed as usable Prometheus metrics, with coverage for the stated unused-index use case.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, postgresql, prometheus
- Domain
- databases, observability-sre
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100