forked from darold/pgcluu
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathChangeLog
102 lines (87 loc) · 4.57 KB
/
ChangeLog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
2014-01-28 - Version 1.1 released
This release adds lot of report improvements and bug fixes. There is also
several new features or reports.
- Format mouse tracker on graphs to show all dataset values at a time.
- Add run queue length report to system menu.
- Add checkpoint write and sync times reports.
- Add report of PostgreSQL version
- Split background writer buffer and count statistics into separated
reports.
- Add report of maxwritten_clean into bgwriter reports.
- Add report of kernel parameters to the system info page.
- Add collect of system kernel tuning parameters.
- Remove embedded CSS and javascript on each HTML page, resources are
now automatically copied into the output directory if not already
present. Thanks to Guillaume Lelarge for the suggestion.
- Allow pgcluu to parse sar file generated from sa file, use commands
like "sar -A -p -f /var/log/sysstat/sa*". Thanks to Julien Rouhaud
for the feature request.
- Split commit, rollback and backend graph by using a second yaxis for
backend. Thanks to GUillaume Lelarge for the report.
- Add System Information report.
- Move Cache hit/miss ratio on second yaxis and change dataset colors.
Thanks to Guillaume Lelarge for the report.
- Add collect of OS release information.
- Allow pgcluu_collectd to grab OS information (cpu, memory, etc.) and
add --os-info option to only grab that information (for testing).
- Reformat dashboard information.
- Add -z | --timezone to set the hour(s) from GMT time to adjust times
on sar report. Thanks to Bricklen for the feature request.
and some more changes/fixes:
- Add vertical crosshair on graph.
- Update copyright date to 2014
- Disable database report of number of canceled queries when not on
hot standby node.
- Disable checkpoint write report following the pg version (< 9.2).
- Disable temporary files and deadlocks reports following the postgresql
version (< 9.2).
- Add storage of pg version into sysinfo.txt
- Fix missing legend of checkpoints_timed in checkpoint report.
- Fix warning on META_MERGE for ExtUtils::MakeMaker < 6.46. Thanks to
Julien Rouhaud for the patch.
- Fix typo in pgcluu_collectd calls. Thanks to Jacky Rigoreau for the
report.
- Fix issue where information slide was not displayed when clicking on
the information button.
- Change documentation about resources files that are now autogenerated.
- Fix grab of statistics from an 8.4 cluster (access to not-available-yet
statistics catalogs). Thanks to Guillaume Lelarge for the report.
- Fix issue on parsing CentOs release. Thanks to bricklen for the help.
- Fix issue "Use of uninitialized value $val in substitution line 3312".
Thanks to bricklen for the report.
- Fix call method "print" on an undefined value at ./pgcluu line 1303.
Thanks to Guillaume Lelarge for the report.
- Fix sar dashboard report.
- Remove decimal from hit cache ratio report. Thanks to Guillaume Lelarge
for the report.
- Dashboard review: cluster label rewrite, remove empty values from
report, add start/end date of database stats and sar stats. Thanks to
Guillaume Lelarge for the feature/change requests.
- Fix some warning on uninitialized value on dashboard. Thanks to Julien
Rouhaud for the report.
- Fix Illegal division by zero at ./pgcluu line 1132. Thanks to Julien
Rouhaud for the report.
- Fix issue in building timestamps in sar data. Thanks to Bricklen for
the report.
- Fix sysstat version execution error with locale different to C or en_*.
Thanks to forall for the report.
- Fix broken sar charts when collect time is greater than 24 hours.
- Add -z | --timezone option to documentation.
- Fix error: print() on closed filehandle GEN9 at pgcluu line 1942.
Thanks to Bricklen for the report.
2013-11-18 - Version 1.0 released
This is the first public release of pgCluu, that is a packaging of the tools I
use every day to collect statistics and build reports of PostgreSQL Clusters
for performances auditing and troubleshooting.
At this time it collect and report most of what is helpful for a PostgreSQL
Cluster performance auditing. There's lot of others reports to be included:
- Statistics reports concerning tables.
- Statistics reports about pg_stat_statement.
- More Sar statistiques reports.
- ...
This will comes in next release.
The goal of this project is to provide a complete PostgreSQL auditing tool that
do not need any dependency so that it can be run on any server.
If you just have a sar output file, pgCluu can be use to draw graphs about the
system utilization only.
For more information take a look at http://pgcluu.darold.net/