Hacker News Reader

am I understanding this requires one to run Pg on every server that you want to run the query on?

Not necessarily. You could put a Python (with psutil module) server on machines and connect from a single Postgres/FDW server.