PostgreSQL Logo

pg_top Screenshots


Process List

pg_top Process List

This is the default screen. To start pg_top:

pg_top [-d ] [-U ] [-W]

Where '-d' specifies the database to connect to, '-U' specifies the database user, and '-W' will prompt for the password if a password is required to connect.

Current Query

pg_top Current Query

Use the 'Q' key and enter a PID once pg_top is started.

Query Plan

pg_top Query Plan

Use the 'E' key and enter a PID once pg_top is started. The 'E' commands runs 'EXPLAIN' and 'EXPLAIN ANALYZE' can be used by using the 'A' key followed by a PID.

Locks Acquired

pg_top Locks Acquired

Use the 'L' key and enter a PID once pg_top is started.

Table Statistics

pg_top Table Statistics

Use the 'R' key to display user table statistics. Use 't' to toggle between displaying cumulative and differential statistics.

Index Statistics

pg_top Index Statistics

Use the 'X' key to display user index statistics. Use 't' to toggle between displaying cumulative and differential statistics.


Powered By GForge Collaborative Development Environment