ClusterThu Feb 27 13:21:10 2014 to Thu Feb 27 15:28:12 2014
- 3.09 GB Cluster size
- 17 Databases
- 2444 Connections
- 208135353 Tuples returned
- 97% Hit cache ratio
- 2 Extensions (plpgsql, hstore)
- 2.88 GB Largest database
- 56 Most connections
- 85108027 Most tuples fetched
- 97% Worst cache utilization
SystemThu Feb 27 13:08:45 2014 to Thu Feb 27 15:28:10 2014
- 4.38% Highest CPU utilization
(Thu Feb 27 14:39:22 2014)
- 1.13 Highest system load
(Thu Feb 27 14:51:34 2014)
- 1.96 GB Lowest system cache
(Thu Feb 27 13:08:45 2014)
- 264.00 Highest device service time
(Thu Feb 27 14:43:26 2014)
- pdc_bhcccjdji Most read device
- sdb Most written device
pgCluu is a Perl program used to perform a full audit of a PostgreSQL Cluster. It is divided in two parts, a collector used to grab statistics on the PostgreSQL cluster using psql and sysstat, a grapher that will generate all HTML output. It is fully open source and free of charge.
pgCluu is licenced under the PostgreSQL Licence a liberal Open Source license, similar to the BSD or MIT licenses.
That mean that all parts of the program are open source and free of charge.
This is the case for both, the collecter and the grapher programs.
pgCluu is an original development of Gilles Darold.
Some parts of the collector are taken from pgstats a C program writen by Guillaume Lelarge and especially the SQL queries including the compatibility with all PostgreSQL versions.
Btw pgCluu grapher is compatible with files generated by pgstats, sar and sadc so you can use it independantly to graph those data. Some part of the sar output parser are taken from SysUsage
- myserver Hostname
- Linux 2.6.03-1 #1 SMP Kernel
- i686 GNU/Linux Arch
- Ubuntu Distribution
- 12.04.4 LTS, Precise Pangolin Version
- Intel(R) Xeon(R) CPU E5620
- 2400.113 Speed
- 12288 KB Cache
- 4 Sockets
- 12 Cores
- 7.63 GB Total memory
- 515.25 MB Free memory
- 0 Buffers
- 5.98 GB Cached
- 0 Total swap
- 0 Free swap
- 697.38 MB Shared memory
Filesystem Size Used Free Use% Mount /dev/simfs 50G 39G 12G 77% /
Filesystem Mount type Options /var/lib/vz/private/305 / simfs (rw,relatime)