Follow these steps to get the status of PgBouncer clients:
- Connect to the pgbouncer database on port 6432 of the PostgreSQL server as the postgres user.
- Issue the following query for pool status:
SHOW POOLS;
- Issue the following query for pool statistics:
SHOW STATS;