DocumentationpgSentinel Documentation

Metrics Catalog

Pool Capacity

pgsentinel_pool_connections

Active, idle, and max connections per pool and database.

pgsentinel_pool_wait_queue

Number of clients waiting for an available backend connection.

pgsentinel_pool_server_usage

Allocated vs free server connections (backend sockets).

Throughput & Latency

pgsentinel_query_duration_seconds

Histogram of query execution time observed by pgBouncer.

pgsentinel_transactions_total

Cumulative transactions per pool.

pgsentinel_bytes_transferred_total

Inbound/outbound bytes proxied.

Errors & Alerts

pgsentinel_retries_total

Client retries triggered due to pool saturation.

pgsentinel_auth_failures_total

Authentication failures observed at pgBouncer.

pgsentinel_alerts_fired_total

Number of alerts fired per severity and pool.

Prometheus Examples

Pool saturation

# Active client connections vs limits
pgsentinel_pool_connections{state="active"}
  / ignoring(state)
pgsentinel_pool_connections_limit

95th percentile latency

histogram_quantile(0.95,
  sum(rate(pgsentinel_query_duration_seconds_bucket[5m])) by (le, pool)
)