Using Correlation Analysis to Monitor DBMS Performance
Postgres Pro (enterprise certified) 15.7.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.4.1 20230605 (Red Soft 11.4.0-1), 64-bit
CPU
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 85
model name : Intel Xeon Processor (Skylake, IBRS, no TSX)
…
processor : 5
vendor_id : GenuineIntel
cpu family : 6
model : 85
model name : Intel Xeon Processor (Skylake, IBRS, no TSX)
RAM
free -g
total
Mem: 31
Experiment results
Load on the DBMS
DBMS performance
Correlation between DBMS performance and the number of sessions in the waiting state
Results and conclusions
An indicator of DBMS performance degradation can be the correlation value between the DBMS performance and the number of sessions in the waiting state. Increased expectations and decreased DBMS performance indicate the presence of problems and the need to create an incident to analyze and resolve the situation.
The priority of an incident is determined by the value of the correlation coefficient:
-0.7 < Rxy < -0.5 : Low priority
Rxy < -0.7 : High priority