A good way to visualize what happens on your site right now is glTail at http://www.fudgie.org/ - you can do a lot of the real-time queries you want with a custom parser.