Elephantshark: like Wireshark, but specifically for Postgres (github.com)

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