This is what I'm finding at backend, and pgbouncer: - backend : 27 tcp connections to pgbouncer: $ /sbin/ss -p state established dport = :5433 | egrep twistd | wc -l 27
- pgbouncer: 20 PG conns (still 27 TCPs, obviously): $ psql .. -c 'SHOW POOLS;'|sed -n '1p;/librarian /p' database | user | cl_active | cl_waiting | sv_active | sv_idle | sv_used | sv_tested | sv_login | maxwait <...> | librarian | 20 | 0 | 20 | 0 | 0 | 0 | 0 | 0 $ /sbin/ss state established dst ${backend_ip} sport = :5433|wc -l 28 ## (one for the headerline)
This is what I'm finding at backend, and pgbouncer:
- backend : 27 tcp connections to pgbouncer:
$ /sbin/ss -p state established dport = :5433 | egrep twistd | wc -l
27
- pgbouncer: 20 PG conns (still 27 TCPs, obviously):
$ psql .. -c 'SHOW POOLS;'|sed -n '1p;/librarian /p'
database | user | cl_active | cl_waiting | sv_active | sv_idle | sv_used | sv_tested | sv_login | maxwait
<...> | librarian | 20 | 0 | 20 | 0 | 0 | 0 | 0 | 0
$ /sbin/ss state established dst ${backend_ip} sport = :5433|wc -l
28 ## (one for the headerline)