Listing Active Requests in PostgreSQL
I needed to find out how to list all the active queries in PostgreSQL, so I did a little googling, and found the following:
SELECT * FROM pg_stat_activity;
and the response comes back with all the activity you can imagine. I'm pretty sure it's by the connection, as a lot of my connections are 'idle', but that's great! This gives me the knowledge of what's going on in the database in case a query it taking forever.