Promhub Logo Prom hub

PostgreSQL PGbouncer
4,432

Created 2/5/2019
Updated 2/6/2019
Revision 3
Categories
Databases
Grafana Version >=5.0.4
Datasources
Prometheus

Current dashboard use the following exporter: https://github.com/spreaker/prometheus-pgbouncer-exporter

For correct work, you should add relabel_configs like this:

relabel_configs:
      - source_labels: [ __address__ ]
        target_label: hostname
        regex: 21.21.81.21:9127
        replacement: pg-slave2
Get Dashboard✕
Download
Copy to Clipboard
Dashboard screenshot 1
Source Grafana.com

Used Metrics 17

  • pgbouncer_pools_client_active_connections

  • pgbouncer_stats_queries_total

  • pgbouncer_databases_database_pool_size

  • pgbouncer_databases_database_reserve_pool_size

  • pgbouncer_stats_queries_duration_microseconds

  • pgbouncer_stats_waiting_duration_microseconds

  • pgbouncer_stats_transactions_duration_microseconds

  • pgbouncer_stats_transactions_total

  • pgbouncer_pools_client_waiting_connections

  • pgbouncer_pools_server_active_connections

  • pgbouncer_pools_server_idle_connections

  • pgbouncer_pools_server_used_connections

  • pgbouncer_pools_server_testing_connections

  • pgbouncer_pools_server_login_connections

  • pgbouncer_databases_database_current_connections

  • pgbouncer_stats_received_bytes_total

  • pgbouncer_stats_sent_bytes_total