iml_psql-dbrows.ini

; ======================================================================
;
; PSQLSERVER actions with db rows
;
; ----------------------------------------------------------------------
; 2023-06-08  <axel.hahn@unibe.ch>  initial version
; ======================================================================


; ----------------------------------------------------------------------
; graph READ actions
; ----------------------------------------------------------------------

[psqlserverdbrows.graph]
check_command = "Postgres-dbrows"

; tupreturned=3689;; tupfetched=3415;; tupinserted=0;; tupupdated=0;; tupdeleted=0;;

[psqlserverdbrows.urlparams]
areaAlpha   = "0.2"
areaMode    = "all"
colorList   = "cccccc,6699aa,88dd88,aaaadd,ffaaaa,6699aa,ffaaaa"
;              ^      ^      ^      ^      
;              return fetch  insert update deleted
lineWidth   = "2"
min         = "0"
yUnitSystem = "binary"
yUnitSystem = "binary"
title       = Read per sec


[psqlserverdbrows.metrics_filters]
returned  = "$service_name_template$.perfdata.tupreturned.value"
fetched   = "$service_name_template$.perfdata.tupfetched.value"

[psqlserverdbrows.functions]
returned  = "alias($metric$, 'Returned rows (total)')"
fetched   = "alias($metric$, 'Fetched - rows fetched by index scans')"


; ----------------------------------------------------------------------
; graph WRITE actions
; ----------------------------------------------------------------------

[psqlserverdbrows2.graph]
check_command = "Postgres-dbrows"

[psqlserverdbrows2.urlparams]
areaAlpha   = "0.2"
areaMode    = "all"
colorList   = "88cc88,aaaadd,ffaaaa"
;              ^      ^      ^      
;              insert update deleted
lineWidth   = "2"
min         = "0"
yUnitSystem = "binary"
title       = Modifications per sec

[psqlserverdbrows2.metrics_filters]
inserted  = "$service_name_template$.perfdata.tupinserted.value"
updated   = "$service_name_template$.perfdata.tupupdated.value"
deleted   = "$service_name_template$.perfdata.tupdeleted.value"

[psqlserverdbrows2.functions]
inserted  = "alias($metric$, 'inserted')"
updated   = "alias($metric$, 'updated')"
deleted   = "alias($metric$, 'deleted')"