[pgpool-general: 2559] Re: measuring balancing success

Granthana Biswas granthana at zedo.com
Tue Feb 11 15:41:20 JST 2014


You can setup Pgbadger for master and slave database which will show the
number of SELECT and DML queries being fired for a day on both. You can get
the ratio from that. Logging in database should be set for all the queries.


On Tue, Feb 11, 2014 at 10:17 AM, Jaime Casanova <jaime at 2ndquadrant.com>wrote:

> Hi,
> A customer that implemented pgpool for load balancing wants to measure
> the percent of queries that are actually being balanced.
> maybe there is a command to show that?
> --
> Jaime Casanova         www.2ndQuadrant.com
> Professional PostgreSQL: Soporte 24x7 y capacitación
> Phone: +593 4 5107566         Cell: +593 987171157
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140211/5a0eade6/attachment.html>

More information about the pgpool-general mailing list