Monitor Postgresql Load Activity

The best and easiest way to monitor what a Postgres server is doing is by using the pg_top tool. Usage is as follows:

$pg_top -d postgres