$ go get github.com/chobostar/pgbouncer-cancel-request
$ cd ~/go/src/github.com/chobostar/pgbouncer-cancel-request
$ docker-compose up -d
$ make run_pgbouncer

$ psql -h localhost -p 6432 -U pgbouncer -c "show lists" | grep 'used_clients'

$ psql -h localhost -p 6432 -U postgres -d db
psql: ERROR:  no more connections allowed (max_client_conn)

$ make run_odyssey

$ make test_stats

$ PGAPPNAME=pgbouncer psql -U postgres -p 6432 -h localhost -d db -c "select pg_sleep(3600)"

$ PGAPPNAME=odyssey psql -U postgres -p 6532 -h localhost -d db -c "select pg_sleep(3600)"

$ PGAPPNAME=psql psql -U postgres -p 5432 -h localhost -d postgres -c "select pg_sleep(3600)"

$ kill $(ps aux | grep '[p]sql' | awk '{print $2}')

$ psql -U postgres -h localhost -c "select application_name from pg_stat_activity where state != 'idle' and pid != pg_backend_pid()"

 application_name 
------------------
 pgbouncer
 psql
(2 rows)