PostgreSQL集群性能审计工具-pgCluu
PostgreSQL Cluster utilizationpgCluu is a PostgreSQL performances monitoring and auditing tool.
View reports of all statistics collected from your PostgreSQL databases cluster. pgCluu will show you the entire informations of the PostgreSQL Cluster and the system utilization
pgCluu 是一个对 PostgreSQL 集群性能进行完整审计的工具,采用Perl开发,该工具分为两部分:
1. collector 收集器用于从 PostgreSQL 集群中获取统计数据,使用 psql 和 sar 工具
2. grapher 哟关于生成 HTML 报表和图表
Cluster
This part shows statistics about global cluster intormation such as databases size, connections, cache utilisation, locks, bgwriter, xlogs, temporary files, checkpoints, read tuples, commits and rollbacks ratio, write ratio, read vs write queries, canceled queries and conflicts...
Databases
This part shows statistics per database. Selecting a database will show all informations to this database like size, connections, cache utilisation, locks, temporary files, read tuples, commits and rollbacks ratio, write ratio, read vs write queries, canceled queries and conflicts...
System
This part shows statistics about the hosting system like CPUs utilization and percentage of iowait, memory, swap, load average, number of process, read/write blocks, and per devices utilization like CPU, read/write bytes per second and average of I/O service time per device...
最新版本:
项目主页:http://pgcluu.darold.net/