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

Jaime Casanova 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:
> 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.

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 mailing list