Additional Postgresql metrics

[jbgcarnes]

A note for the community

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

The current metrics that vector gathers from Postgresql are great, but there are a few additional metrics that would be useful for users. These metrics are attempting to bring the exporter to par with the prometheus-exporter for postgresql found here.

These metrics include:

• Version (current version of the postgresql instance)
• Maximum current connections (this is useful to know what percentage of max is currently being used)
• Long running transactions
• Start time of the instance.

I am willing to work on the issue.

Use Cases

In the end, I would like to entirely replace the prometheus-exporter for postgresql that I am using with vector. There are just a few metrics that are required. These mostly are about the current settings of the database. While these are unlikely to change, they can be used for comparisons/calculations to understand if your database is reaching saturation.

Attempted Solutions

I've gone through the documentation of postgresql's metrics gathered and the listed ones are not there. They will need to be added. Luckily, the sql for them is relatively trivial.

No configuration change needs be made to the datasource object, it would just return additional metrics.

Proposal

I purpose adding the listed 3 metrics to the postgresql source. These are 3 simple sql statements.

References

No response

Version

v0.29.0

[dsmith3197]

Hi @jbgcarnes,

Thanks for the feature request. We'd be happy to consider a contribution if you're inclined to work on it.