Postgres::getProcesses PHP Method

    function getProcesses($database = null)
    {
        if ($database === null) {
            $sql = "SELECT datname, usename, pid, waiting, state_change as query_start,\n                  case when state='idle in transaction' then '<IDLE> in transaction' when state = 'idle' then '<IDLE>' else query end as query \n\t\t\t\tFROM pg_catalog.pg_stat_activity\n\t\t\t\tORDER BY datname, usename, pid";
        } else {
            $this->clean($database);
            $sql = "SELECT datname, usename, pid, waiting, state_change as query_start,\n                  case when state='idle in transaction' then '<IDLE> in transaction' when state = 'idle' then '<IDLE>' else query end as query \n\t\t\t\tFROM pg_catalog.pg_stat_activity\n\t\t\t\tWHERE datname='{$database}'\n\t\t\t\tORDER BY usename, pid";
        }
        return $this->selectSet($sql);
    }