Stackstate-PGBouncer Integration

Overview

Connect your PGBouncer to Stackstate in order to:

  • Visualize your pools of connections.
  • Monitor the traffic between PostgreSQL and your applications.

For more details about configuring this integration refer to the following file(s) on GitHub:

Metrics

pgbouncer.stats.requests_per_second
(gauge)
The request rate
shown as request/second
pgbouncer.stats.bytes_received_per_second
(gauge)
The total network traffic received
shown as byte/second
pgbouncer.stats.bytes_sent_per_second
(gauge)
The total network traffic sent
shown as byte/second
pgbouncer.stats.total_query_time
(gauge)
Time spent by pgbouncer actively querying PostgreSQL
shown as microsecond
pgbouncer.stats.avg_req
(gauge)
The average number of requests per second in last stat period
shown as request/second
pgbouncer.stats.avg_recv
(gauge)
The client network traffic received
shown as byte/second
pgbouncer.stats.avg_sent
(gauge)
The client network traffic sent
shown as byte/second
pgbouncer.stats.avg_query
(gauge)
The average query duration
shown as microsecond
pgbouncer.pools.cl_active
(gauge)
Client connections linked to server connection and able to process queries
shown as connection
pgbouncer.pools.cl_waiting
(gauge)
Client connections waiting on a server connection
shown as connection
pgbouncer.pools.sv_active
(gauge)
Server connections linked to a client connection
shown as connection
pgbouncer.pools.sv_idle
(gauge)
Server connections idle and ready for a client query
shown as connection
pgbouncer.pools.sv_used
(gauge)
Server connections idle more than server_check_delay, needing server_check_query
shown as connection
pgbouncer.pools.sv_tested
(gauge)
Server connections currently running either server_reset_query or server_check_query
shown as connection
pgbouncer.pools.sv_login
(gauge)
Server connections currently in the process of logging in
shown as connection
pgbouncer.pools.maxwait
(gauge)
Age of oldest unserved client connection
shown as second