We use GitHub - prometheus-community/postgres_exporter: A PostgreSQL metric exporter for Prometheus, though I’m not sure if there’s any guides on meta around setting it up.
But, given that you seem to already have prometheus set up, looks like you know what you’re doing.