PgBouncer is a lightweight connection pooler for PostgreSQL. If PgBouncer is installed on your environment, you may need to edit the Sysdig agent configuration file to connect. See the Default Configuration section, below.
This page describes the configuration settings, the metrics available for integration, and a sample result in the Sysdig Monitor UI.
PgBouncer does not ship with a default stats user configuration. To
configure it, you need to add a user allowed to access PgBouncer stats.
Do so by adding following line in
pgbouncer.ini. The default file
stats_users = sysdig_cloud
For the same user you need the following entry in
default file location is
Sysdig Agent Configuration
Review how to Edit dragent.yaml to Integrate or Modify Application Checks.
No default configuration is present in Sysdig’s
file for PgBouncer, as it requires a unique username and password. You
must add a custom entry in
dragent.yaml as follows:
Remember! Never edit
dragent.default.yaml directly; always edit
app_checks: - name: pgbouncer pattern: comm: pgbouncer conf: host: localhost # set if the bind ip is different port: 6432 # set if the port is not the default username: sysdig_cloud password: sysdig_cloud_password #replace with appropriate password
See PGBouncer Metrics.