---

pg_top Screenshots

---

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

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

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

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

Table Statistics

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

Index Statistics

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