#!/bin/bash

[ -r /etc/check_mk/galaxy_counts.cfg ] && . /etc/check_mk/galaxy_counts.cfg
[[ "x$GALAXY_DATABASE" == "x" ]] && exit 0

if which psql > /dev/null 2>&1 ; then
    echo "<<<galaxy_counts>>>"
    cd /tmp
    sudo -u postgres psql --csv -t -d $GALAXY_DATABASE -c "select state,count(*) from job group by state" 2>&1
fi
