Elephantshark, a tool to monitor Postgres network traffic (github.com)

OP and tool author here: AMA (though I hope the README is pretty self-explanatory).