Needed to install pg_activity on ubuntu 12.04 x64 and there were a decent amount of dependencies, here’s how to do it:
sudo apt-get install git python2.7-dev libpq-dev python-setuptools
git clone https://github.com/julmon/pg_activity.git
cd pg_activity
sudo python setup.py install
sudo -u postgres pg_activity
Done!