Graphing PgSQL query result set from a remote machine

Hello,

I have added my remote servers to be monitored (basic device template) via SSH. Now I want to send PostgreSQL queries to the machines and graph the result (single integer value). Where can I start with this I am fairly new to the community and how the software organizes everything. I have searched for hours, but psql does not seem to be heavily used with zenoss. I know that I will likely have to create my own ZenPack, but from what I have been looking though the documentation is terrible.

Thanks,
jhallen978