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

Tatsuo Ishii ishii at sraoss.co.jp
Sun Sep 13 09:17:44 JST 2020


> 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

More information about the pgpool-general mailing list