The pg_stat_activity table will show you which processes are doing what, and you'll be able to see their process ID from the O/S. That might help you.
Yes, but I need to see which process ID is doing a TON of small transactions which is causing the XID to increment at an unexpectedly high rate and so my question is "if there's a way for me to get the XID for every connection/query?".