# pg_top
# Display and update information about the top CPU PostgreSQL processes

# connect to port 5432 using user postgres, and database, ask for password
pg_top -p 5432 -U postgres -d database -W

# Interactive mode keys:
#
#  A
#      Display the actual query plan (EXPLAIN ANALYZE)
#  E
#      Display re-determined execution plan (EXPLAIN) of the SQL statement
#      by a back end process
#  L
#      Display the currently held locks by a back end process
#  Q
#      Display the currently running query of a back end process
#  X
#      Display user index statistics.