[pgpool-general: 7271] Re: Finding child_max_connection usage

[Tatsuo Ishii]

Hi,

> Hi Team,
> 
> Is there a way to find how many connections has a single Pgpool child
> process served?
> 
> For example: If child_max_connections is 10, then each child process will
> serve 10 requests and then respawn. How do I find how many connections the
> child process has served currently?

Currently there's no such information exported. Each process has a
counter for this inside its process space.

> I looked into pool_counter from "show pool_pools" and I suppose it gives
> how many times my backend cached connections were reused and not the number
> of connections a child process has served.

Yes, your understanding is correct.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp