Do check out the psql cheatsheet & queries directory. Those queries have saved me a lot of time and trouble during critical production issues.