NetApp announces intent to acquire Instaclustr Read the announcement
PgBouncer Monitoring Metrics

This article introduces the basics of monitoring PgBouncer, using the metrics made available via the Instaclustr Console and the API. There are currently two different PgBouncer metrics groups:

  • PgBouncer – Database Level Metrics
  • PgBouncer – Availability

PgBouncer – Database Level Metrics

This metrics group includes seven separate metrics:

  • Average data sent in bytes per second
  • Average data received in bytes per second
  • Average queries per second
  • Average transactions per second
  • Average query duration in milliseconds
  • Average client wait duration in milliseconds
  • Average transaction duration in milliseconds

Average Data Sent per Second

This metric specifies the average amount of data sent by PgBouncer to clients connected to a given database each second, measured in bytes. Each data point reflects the average over a single metric collection interval.

Graph for average data sent

Average Data Received per Second

This metric specifies the average amount of data received by PgBouncer from clients connected to a given database each second, measured in bytes. Each data point reflects the average over a single metric collection interval.

Graph for average data received

Average Queries per Second

This metric specifies the average number of queries against a given database processed by PgBouncer each second. Each data point reflects the average over a single metric collection interval.

Graph for average queries per second

Average Transactions per Second

This metric specifies the average number of transactions against a given database processed by PgBouncer each second. Each data point reflects the average over a single metric collection interval.

Graph for average transactions per second

Average Query Duration

This metric specifies the average time taken in milliseconds for a client to complete a single query on a given database via PgBouncer. Each data point reflects the average over a single metric collection interval.

Graph for average query duration

Average Client Wait Duration

This metric specifies the average length of time in milliseconds that a client spends waiting for a connection to the PostgreSQL server to be allocated to it from its respective connection pool, for connections on a given database. Each data point reflects the average over a single metric collection interval.

Graph for average client wait duration

Average Transaction Duration

This metric specifies the average time taken in milliseconds for a client on a given database to complete a single transaction via PgBouncer. Each data point reflects the average over a single metric collection interval.

Graph for average transaction duration

PgBouncer – Availability

This metrics group includes a single metric:

  • PgBouncer availability

PgBouncer availability

This metric reflects whether PgBouncer is running on a given node. A value of 1 means that the service is running, whereas a value of 0 means that it is not. 

Graph for PgBouncer availability

By Instaclustr Support
Need Support?
Experiencing difficulties on the website or console?
Already have an account?
Need help with your cluster?
Contact Support
Why sign up?
To experience the ease of creating and managing clusters via the Instaclustr Console
Spin up a cluster in minutes