I find activity monitor to be a good overview of what's going on my system. I use whoisactive after that to view the transactions that have been running for a long time, and exactly how long they have been running.

You can filter out sessions that arent active in activity monitor by clicking the drop down arrow at the top of the task state column and selecting 'non blanks'. this will filter out idle sessions.