[pgpool-general: 2564] Re: measuring balancing success
jaime at 2ndquadrant.com
Wed Feb 12 08:13:04 JST 2014
On Tue, Feb 11, 2014 at 1:41 AM, Granthana Biswas <granthana at zedo.com> wrote:
> 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.
yeah i thought on that the bad thing is that it could take a lot of
space because of logs... the other option i was thinking was using
pg_stat_statements and take snapshots every often... it's less
accurate but maybe it use less space too.
i think that is an important info pgpool should capture and display easily
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
More information about the pgpool-general