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