Crunchy Data is pleased to announce the initial release of pgbouncer_fdw
pgbouncer_fdw provides a direct SQL interface to the pgbouncer SHOW commands. It takes advantage of the dblink_fdw feature to provide a more typical, table-like interface to the current status of your pgbouncer server(s). This makes it easier to set up monitoring or other services that require direct access to pgbouncer statistics.
A blog post about pgbouncer_fdw has been published recently as well, going over what lead to the development of this tool as well as some brief examples:
https://info.crunchydata.com/blog/making-pgbouncer-easier-to-monitor
The pgbouncer_fdw is made available under the PostgreSQL License.
The team behind pgbouncer_fdw welcomes questions, issues and contributions. Please use the projects GitHub issues to coordinate.
Crunchy Data is proud to support the development and maintenance of pgbouncer_fdw.