The server-side part of pg:diagnose is a go program I open sourced at https://github.com/heroku/pgdiagnose . It'd be easy enough to run locally for your own stuff, probably.