PgBouncer

Integration Installation

1. Install the Astradot Infra Agent on your server

2. Edit /etc/astradot-infra/integrations/pgbouncer.toml

   #For every pgbouncer instance to monitor, add an [[instance]] block
   [[instance]]
   host = "localhost"
   port = 6432
   username = "user1"
   password = "xx"
   ssl = true
   #The pgbouncer database itself.
   #This field can be left out unless you explicity configured otherwise in pgbouncer.
   database = "pgbouncer"

3. Restart astradot-infra agent

   service astradot-infra restart

Metrics

Metric	Description
Transactions	Rate of SQL transactions pooled
Queries	Rate of SQL queries pooled
Bytes Received	Volume of network traffic received
Bytes Sent	Volume of network traffic sent
Client Connections - Active	Client connections that are linked to server connection and can process queries
Client Connections - Waiting	Client connections have sent queries but have not yet got a server connection
Server Connections - Active	Server connections that linked to client
Server Connections - Idle	Server connections that unused and immediately usable for client queries
Server Connections - In Use	Server connections that have been idle more than server_check_delay, so they needs server_check_query to run on them before they can be used