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


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

[psqlserverconflicts.graph]
check_command = "Postgres-conflicts"

; confltablespace=0;; confllock=0;; conflsnapshot=0;; conflbufferpin=0;; confldeadlock=0;;

[psqlserverconflicts.urlparams]
areaAlpha   = "0.2"
areaMode    = "first"
colorList   = "aaaadd,dd8888,66cc88,6699aa,ff0000"
;              ^      ^      ^      ^      ^
;              tables lock   snaps  buffer deadlock
lineWidth   = "2"
min         = "0"
yUnitSystem = "binary"


[psqlserverconflicts.metrics_filters]
tablespace  = "$service_name_template$.perfdata.confltablespace.value"
lock        = "$service_name_template$.perfdata.confllock.value"
snapshot    = "$service_name_template$.perfdata.conflsnapshot.value"
bufferpin    = "$service_name_template$.perfdata.conflbufferpin.value"
deadlock    = "$service_name_template$.perfdata.confldeadlock.value"

[psqlserverconflicts.functions]
tablespace  = "alias($metric$, 'tablespace - queries that have been canceled due to dropped tablespaces')"
lock        = "alias($metric$, 'lock - queries that have been canceled due to lock timeouts')"
snapshot    = "alias($metric$, 'snapshot - queries that have been canceled due to old snapshots')"
bufferpin   = "alias($metric$, 'bufferpin - queries that have been canceled due to pinned buffers')"
deadlock    = "alias($metric$, 'deadlock - queries that have been canceled due to deadlocks')"