show pools - cl_waiting reported for a newly connected client

[rechtem]

When a client attach to the pooler, but does not issue SQL (idle), it is reported as cl_waiting in the "show pools" console. I am not sure this is the normal behaviour: it is misleading.

pgBouncer doc states: cl_waiting Client connections that have sent queries but have not yet got a server connection.

[Gorilaz]

Absolutely agree with you. What status should be instead of that? Should we check show clients to understand the status of connection

[mrechte]

IMHO it should be cl_active.

[Gorilaz]

Hello! We are actively using odyssey on our production systems. We refused from cascade's pgboncers. We set up monitoring for Odyssey. And when we have clients in queue state (show clients from console db) C | postgres | test_db | queue | | | | |
......... show stats doesn't show us that we have wait time show stats -[ RECORD 2 ]-----+----------------- database | test_db ...... total_wait_time | 0 ....... avg_wait_time | 0

Is it okay? or maybe I misunderstood something?

[x4m]

Just bumped into this too.

Currently we do not calculate wait times, fixing this would be nice. Also, maybe count as cl_waiting queued (OD_CLIENT_QUEUE, clients trying to get server connection) clients instead of pending (OD_CLIENT_PENDING)? What do you think?

[uspen]

UP