“Show Full Processlist;” Equivalent Of MySQL For PostgreSQL

sachin

How can I trace PostgreSQL queries on my Linux server as they happen like we do in MySQL by “Show Full Processlist;”?

sachin

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".