Skip site navigation (1) Skip section navigation (2)

Re: Performance monitoring?

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Performance monitoring?
Date: 2010-08-19 14:16:25
Message-ID: 4C6D3CB9.8090600@ca.afilias.info (view raw or flat)
Thread:
Lists: pgsql-novice
  On 10-08-19 05:57 AM, machielr(at)rdc(dot)co(dot)za wrote:
> Good day all
>
>     This is me again.
>
>      Does anybody know about resources or methods that can be used to 
> Monitor postgresql performance specifrically for the purpose of 
> creating monthly performance reports.
>
>

What sort of performance data are looking at reporting?


>
>      The situation I have at the moment is as follows:
>
>       We are managing a client site with 100 Postgresql databases 
> (which I can just say is in a hectic state at present).
>
>       We need to provide the client with a monthly performance report 
> on all the databases (the 100 databases are spread across 13 servers 
> so running it per server might be a good idea).
>
>
>      So far however I have not been able to find any info on how to 
> monitor the database performance.
>
>
>    I did find something called pgstatspack, however this gives a text 
> based presentation of info per database and runnign this for 100 
> Databases will be a mission especially if this needs to be placed into 
> a report at the end of the month.
>

Pgstatspack is an excellent tool.  The raw data is all stored in the 
respective databases, and the reporter script is quiet easy to read.  
All of the queries are fairly straight forward, it shouldn't be too much 
work to extract them and put them into your own script that can run 
across all of your databases in an automated fashion.


-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.



In response to

pgsql-novice by date

Next:From: Rikard BosnjakovicDate: 2010-08-19 17:40:08
Subject: Easiest way to extract owner-id from a third table
Previous:From: Pg NoviceDate: 2010-08-19 10:54:36
Subject: Re: Creating a second database on the same computer

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group