PGBouncer integration metrics

The official Datadog integration for monitoring PGBouncer. It collects 44 metrics.

Official summary

Track connection pool metrics and monitor traffic to and from your application.

Metric types

  • gauge (value at a point in time): 37
  • rate (per second): 7

Metrics

Descriptions are the official definitions, unedited.

MetricTypeUnit
pgbouncer.clients.connect_timeWhen the connection was made (seconds since epoch)gaugesecond
pgbouncer.clients.prepared_statementsThe number of prepared statements that the client has preparedgaugequery
pgbouncer.clients.request_timeWhen last request was issued (seconds since epoch)gaugesecond
pgbouncer.clients.waitCurrent waiting time in secondsgaugesecond
pgbouncer.clients.wait_usThe microsecond portion of the current waiting timegaugemicrosecond
pgbouncer.databases.current_connectionsCurrent number of connections for this databasegaugeconnection
pgbouncer.databases.max_connectionsMaximum number of allowed connectionsgaugeconnection
pgbouncer.databases.pool_sizeMaximum number of server connectionsgaugeconnection
pgbouncer.max_client_connThe maximum number of client connections allowed.gaugeconnection
pgbouncer.pools.cl_activeClient connections linked to server connection and able to process queriesgaugeconnection
pgbouncer.pools.cl_waitingClient connections waiting on a server connectiongaugeconnection
pgbouncer.pools.maxwaitHow long the first (oldest) client in the queue has waited, in secondsgaugesecond
pgbouncer.pools.maxwait_usMicrosecond part of the maximum waiting timegaugemicrosecond
pgbouncer.pools.sv_activeServer connections linked to a client connectiongaugeconnection
pgbouncer.pools.sv_idleServer connections idle and ready for a client querygaugeconnection
pgbouncer.pools.sv_loginServer connections currently in the process of logging ingaugeconnection
pgbouncer.pools.sv_testedServer connections currently running either server_reset_query or server_check_querygaugeconnection
pgbouncer.pools.sv_usedServer connections idle more than server_check_delay, needing server_check_querygaugeconnection
pgbouncer.servers.connect_timeWhen the connection was made (seconds since epoch)gaugesecond
pgbouncer.servers.prepared_statementsThe number of prepared statements that are prepared on the server, limited by the max_prepared_statements settinggaugequery
pgbouncer.servers.request_timeWhen last request was issued (seconds since epoch)gaugesecond
pgbouncer.stats.avg_bind_countThe average number of prepared statements readied for execution by clients and forwarded to PostgreSQL per second in last stat periodgaugequery/second
pgbouncer.stats.avg_client_parse_countThe average number of prepared statements created by clients per second in last stat periodgaugequery/second
pgbouncer.stats.avg_queryThe average query durationgaugemicrosecond
pgbouncer.stats.avg_query_countThe average number of queries per second in last stat periodgaugequery/second
pgbouncer.stats.avg_query_timeThe average query durationgaugemicrosecond
pgbouncer.stats.avg_recvThe client network traffic receivedgaugebyte/second
pgbouncer.stats.avg_reqThe average number of requests per second in last stat periodgaugerequest/second
pgbouncer.stats.avg_sentThe client network traffic sentgaugebyte/second
pgbouncer.stats.avg_server_parse_countThe average number of prepared statements created by pgbouncer on a server per second in last stat periodgaugequery/second
pgbouncer.stats.avg_transaction_countThe average number of transactions per second in last stat periodgaugetransaction/second
pgbouncer.stats.avg_transaction_timeThe average transaction durationgaugemicrosecond
pgbouncer.stats.avg_wait_timeTime spent by clients waiting for a server, in microseconds (average per second)gaugemicrosecond
pgbouncer.stats.bind_count_per_secondThe rate of prepared statements readied for execution by clients and forwarded to PostgreSQLgaugequery/second
pgbouncer.stats.bytes_received_per_secondThe total network traffic receivedratebyte/second
pgbouncer.stats.bytes_sent_per_secondThe total network traffic sentratebyte/second
pgbouncer.stats.client_parse_count_per_secondThe rate of prepared statements created by clientsgaugequery/second
pgbouncer.stats.queries_per_secondThe query rateratequery/second
pgbouncer.stats.requests_per_secondThe request rateraterequest/second
pgbouncer.stats.server_parse_count_per_secondThe rate of prepared statements created by pgbouncer on a servergaugequery/second
pgbouncer.stats.total_query_timeTime spent by pgbouncer actively querying PostgreSQLratemicrosecond
pgbouncer.stats.total_transaction_timeTime spent by pgbouncer in transactionsratemicrosecond
pgbouncer.stats.total_wait_timeTime spent by clients waiting for a server, in microsecondsgaugemicrosecond
pgbouncer.stats.transactions_per_secondThe transaction rateratetransaction/second

Official documentation

Official documentation for the PGBouncer integration

Metric names and descriptions are the official Datadog integration definitions (Copyright Datadog, Inc., BSD-3-Clause), reproduced unedited. The full license terms are on the About page.