Monitor active queries for Satellite 5

active_queries_sat5.sh

#!/bin/bash
export PATH="/bin:/sbin:/usr/bin:/usr/sbin:/opt/rh/postgresql92/root/usr/bin"
PG_VERSION=$(su - postgres -c "psql -c 'select version();'" |  grep "^ PostgreSQL" | cut -f 3 -d ' ' | cut -f1 -d'.')


if [ $PG_VERSION -eq 9 ]; then
    echo "SELECT query,xact_start,query_start FROM pg_stat_activity GROUP BY query,xact_start,query_start;" | spacewalk-sql --select-mode -

elif [ $PG_VERSION -eq 8 ]; then

    echo "SELECT current_query, query_start, backend_start, datid, usesysid, procpid, waiting from pg_stat_activity;" | spacewalk-sql --select-mode -

    #exclude the IDLEs
    echo "SELECT current_query, query_start, backend_start, datid, usesysid, procpid, waiting from pg_stat_activity where current_query not like '%IDLE%';" | spacewalk-sql --select-mode -

else
    echo "Sorry, I could not determine the PostgreSQL version"
fi