[Pgpool-general] pcp stats

[Daniel.Crespo at l-3com.com]

> > Im using pgpool for 3 backends that have different weights. Its a
> > replication/load-balancing setup. Is there any way to show the
number
> of
> > connections/queries that have been sent to each of the backends? I
> just want
> > to verify that the weighing mechanism works correctly.
> 
> Check the active connections/queries sent on each of the PostgreSQL
> nodes?

You can do so by doing:

select * from pg_stat_activity; on each postgresql backend.

Daniel