Skip to content
Snippets Groups Projects
iml_psql-problems.ini 2.40 KiB
; ======================================================================
;
; PSQLSERVER conflicts
;
; ----------------------------------------------------------------------
; 2023-06-09  <axel.hahn@unibe.ch>  initial version
; ======================================================================


; ----------------------------------------------------------------------
; graph
; ----------------------------------------------------------------------

[psqlserverproblems.graph]
check_command = "Postgres-problems"

; conflicts=0;; deadlocks=0;; checksumfailures=0;; tempfiles=0;; tempbytes=0;;

[psqlserverproblems.urlparams]
areaAlpha   = "0.2"
areaMode    = "first"
colorList   = "ee8822,ff4444,dd88dd,6699aa"
;              ^      ^      ^      ^     
;              confl. deadlk checks tmpfiles
lineWidth   = "2"
min         = "0"
yUnitSystem = "binary"


[psqlserverproblems.metrics_filters]
conflicts        = "$service_name_template$.perfdata.conflicts.value"
deadlocks        = "$service_name_template$.perfdata.deadlocks.value"
checksumfailures = "$service_name_template$.perfdata.checksumfailures.value"
tempfiles        = "$service_name_template$.perfdata.tempfiles.value"
; tempbytes        = "$service_name_template$.perfdata.tempbytes.value"

[psqlserverproblems.functions]
conflicts        = "alias($metric$, 'conflicts - Number of queries canceled due to conflicts with recovery')"
deadlocks        = "alias($metric$, '# of deadlocks')"
checksumfailures = "alias($metric$, '# of data page checksum failures')"
tempfiles        = "alias($metric$, 'Number of temporary files created by queries')"
; tempbytes        = "alias($metric$, 'Total amount of data written to temporary files by queries')"

; ----------------------------------------------------------------------
; graph 2
; ----------------------------------------------------------------------

[psqlserverproblems2.graph]
check_command = "Postgres-problems"

; conflicts=0;; deadlocks=0;; checksumfailures=0;; tempfiles=0;; tempbytes=0;;

[psqlserverproblems2.urlparams]
areaAlpha   = "0.2"
areaMode    = "first"
colorList   = "6699aa"
;              ^
;              tmpbyte
lineWidth   = "2"
min         = "0"
yUnitSystem = "binary"

[psqlserverproblems2.metrics_filters]
tempbytes        = "$service_name_template$.perfdata.tempbytes.value"

[psqlserverproblems2.functions]
tempbytes        = "alias($metric$, 'Total amount of data written to temporary files by queries')"