Posts

Grafana Dashboard for Pgpool-II Exporter

Pgpool-II Exporter is a tool that periodically collects Pgpool-II and PostgreSQL Cluster's metrics and exports the results as Prometheus metrics.  Pgpool-II Exporter uses SHOW command to collect Pgpool-II and PostgreSQL Cluster's metrics, including: name Description pgpool2_frontend_total Number of total child processes pgpool2_frontend_used Number of used child processes pgpool2_frontend_used_ratio Ratio of used child processes to total child processes (0.0 to 1.0) pgpool2_pool_nodes_status Backend node Status (1 for up or waiting, 0 for down or unused) pgpool2_pool_nodes_replication_delay Replication delay pgpool2_pool_backend_stats_error_cnt Error message counts returned from backend pgpool2_pool_backend_stats_fatal_cnt Fatal message counts returned from backend