Skip to content
Snippets Groups Projects

psql: add output

Merged Hahn Axel (hahn) requested to merge 6010-check-pqsql into master
1 file
+ 9
3
Compare changes
  • Side-by-side
  • Inline
+ 9
3
@@ -247,7 +247,7 @@ case "${sMode}" in
"conflicts")
deltaunit=min
descr="Detected conflicts (from pg_stat_database_conflicts)"
descr="(from pg_stat_database_conflicts)"
renderCounters "select \
sum(confl_tablespace) as confl_tablespace, \
sum(confl_lock) as confl_lock, \
@@ -259,7 +259,10 @@ case "${sMode}" in
# sum of 7th column (with delta per sec)
typeset -i iTotal; iTotal=$( echo "$out" | awk '{ sum+=$7} END { print sum;}' )
if [ $iTotal -gt 0 ]; then
ph.setStatus "critical"
ph.setStatus "critical"
descr+=" ... $iTotal conflicts detected"
else
descr+=" ... OK, nothing was found"
fi
descr+=" - currently $iTotal per ${deltaunit}"
;;
@@ -297,7 +300,10 @@ case "${sMode}" in
# sum of 7th column (with delta per sec)
typeset -i iTotal; iTotal=$( echo "$out" | awk '{ sum+=$7} END { print sum;}' )
if [ $iTotal -gt 0 ]; then
ph.setStatus "critical"
ph.setStatus "critical"
descr+="... $iTotal Problems and troublemakers were found"
else
descr+=" ... OK, nothing was found"
fi
descr+=" - currently $iTotal per ${deltaunit}"
;;
Loading