Comment 6 for bug 1000805

Revision history for this message
JuanJo Ciarlante (jjo) wrote :

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)