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

[Granthana Biswas]

Jaime,

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.

Regards,
Granthana


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>