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: