MySQL has a very powerfull command through “show full processlist;", to see a list of currently running queries.
mysql
mysql > show full processlist;
PostgreSQL has a similar shell to MySQL, named psql. Here’s how it works. First, change to the postgres user.
su postgres
Enter the PostgreSQL command shell.
[postgres@srv]$ psql
And perform the query to see the current activity.
postgres > select * from pg_stat_activity;
To quit the PostgreSQL shell, type \q.
