We are trying to monitor a number of connections to the Azure for Postgres Flexible server, by a specific user and/or specific database (connection pool, making sure it does not exceed a threshold).
To accomplish this, PGBouncer was set up and enabled:
pgbouncer.enabled = true metrics.pgbouncer_diagnostics = on
other parameters were left at default.
When trying to vew metrics for the number of connections (client or server) to the specific database in the Metrics section in Azure, "PGBouncer Metrics (Preview)" section is available. It always shows 1 connection only, whether client or server. In addition, the only name of the database in the dropdown is "postgres", no other databases show up.
Questions:
- How can it truly track connection counts (when it always shows 1)
- How can we set it up to list other databases?
Thank you in advance!
