[Pgpool-hackers] Admin interface, statistics views, etc

[Tatsuo Ishii]

> >> I still have an issue and perhaps you have an idea on how to
> >> resolve it. Is there a way to know which connection is the active one in
> >> a pool?
> > 
> > Good question:-) I never thought about it. Let me check...
> 
> Just to give you my idea. If you do a "SHOW pool_processes", it gives
> you a list of all processes. It also shows the database and the username
> of the first connection in the pool of the process. And it would be best
> if it can show you the database of the currently active connection in
> the pool. BTW, the same could apply to pcp_proc_info: adding a simple
> column showing the active connection in the pool handled by the
> specified process.

I have just checked in for this. i.e. "connected" menmber is added to
ConnectionInfo which indicates if this connection pool is connected
from frontend or not. Please take a look at recent my commit.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp