Re: PostgreSQL-9.0 Monitoring System to improve performance

From: Ben Ciceron <ben(at)triggit(dot)com>
To: Fernando Hevia <fhevia(at)gmail(dot)com>
Cc: Bobby Dewitt <Bdewitt(at)appriss(dot)com>, Gregg Jaskiewicz <gryzman(at)gmail(dot)com>, Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>, Tomas Vondra <tv(at)fuzzy(dot)cz>, Greg Smith <greg(at)2ndquadrant(dot)com>, PGSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL-9.0 Monitoring System to improve performance
Date: 2011-10-07 22:13:14
Message-ID: CAOsHk6FChrd9KasP63ss9xr2gYinedUkEZ9VWrGYukRxRHtx3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

doe sit include monitoring replicas ?

Cheers,
Ben-

On Fri, Oct 7, 2011 at 3:01 PM, Fernando Hevia <fhevia(at)gmail(dot)com> wrote:
> pgwatch might also be worth taking a look
> at: http://www.cybertec.at/en/postgresql_products/pgwatch-cybertec-enterprise-postgresql-monitor
> Fernando.-
> On Fri, Sep 30, 2011 at 18:29, Bobby Dewitt <Bdewitt(at)appriss(dot)com> wrote:
>>
>> EnterpriseDB now has Postgres Enterprise Manager
>>
>> (http://enterprisedb.com/products-services-training/products/postgres-enter
>> prise-manager) that has some of the information that is being asked for.
>> It has a hot table analysis report that shows the number of scans, rows
>> read, etc.  Since much of the tool is using the pgAdmin code base, much of
>> this is also available in pgAdmin but PEM will track the statistics at
>> given intervals and show you trending graphs over time.  It's still a very
>> new tool so I'm sure they are working to add new features and have been
>> looking for enhancement suggestions.  Of course, it requires a service
>> contract with them to use the tool, but it doesn't cost extra to add the
>> tool if you already have a contract with them.  It does have a 45 day
>> evaluation if you wanted to check it out.
>>
>> Hope that helps.
>> Bobby
>>
>> On 9/30/11 7:53 AM, "Gregg Jaskiewicz" <gryzman(at)gmail(dot)com> wrote:
>>
>> >Looks like this is generally an area that can be targeted by some
>> >businesses. Or an open source enthusiast.
>> >One centre that captures all the information and produces a report
>> >based on it would be a great thing. Especially in cases like mine,
>> >where I have tens of postgresql installations on different hardware
>> >and with different use patterns (but schemas and queries are the
>> >same).
>>
>>
>> --
>> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-performance
>
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Giovanni Mancuso 2011-10-08 15:04:46 Re: Performance problem with a table with 38928077 record
Previous Message Fernando Hevia 2011-10-07 22:01:36 Re: PostgreSQL-9.0 Monitoring System to improve performance