Listing Postgres process in your Linux Server

After logging in you Postgres Server (Linux), you can use ps auxww to list the Postgres connection and check their status, like this: “ps auxww | grep ^postgres“ 

Try this, in your pgadmin or postgres console, execute a simple query using begin tran (no commit or rollback):

BEGIN TRANSACTION; 

SELECT * 

FROM   sometable; 

Try “ps auxww | grep ^postgres“ once again and you will see that a new process is running with the "in transaction" description.

Peachy. =)

Now, rollback your transaction (just execute a "rollback;" in pgadmin) and execute “ps auxww | grep ^postgres“ in your server console.

And the 233 process is idle again.  

Cheers! 

Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06