> > 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 _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general