Hello Everyone, I am implementing a PostgreSQL performance monitoring system (to monitor the below) which would help us understand the database behavior -
1. Big Full Table Scans 2. Table with high IOs (hot tables) 3. Highly used Indexes 4. Tables undergoing high DMLs with index scans 0 (with unused indexes) 5. Index usage for heap blk hits 6. Tracking Checkpoints 7. Tracking CPU, IO and memory usage ( by PG processes ) -- desperately needed 8. Buffer cache usage 9. Tables, Indexes and Database growth statistics and more.. I am struck at building a script or monitoring tool which gets us CPU usage, IO metrics and RAM usage of the database server. Can someone please help me achieve this ? I need to monitor a 12 processor system with 6 cores. I need to know how each CPU is performing. Please help me know the availability of any open source monitoring tools or scripts for PG-9.0 on RHEL5. I will hit back with questions regarding monitoring in coming days. Thanks VB