PostgreSQL performance monitoring tool akin to top


pg_top is 'top' for PostgreSQL.

 * Monitor PostgreSQL processes.
 * View currently running SQL statement of a process.
 * View query plan of a currently running SELECT statement.
 * View locks held by a process.
 * View I/O statistics per process.
 * View replication statistics for downstream nodes.

Upload more screenshots

Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.

Upload a screenshot

Hint: upload an image here from your clipboard with Ctrl-V


Install this software package

If the package is available for the distribution you are currently using on your computer then install the software by clicking on…

Install pgtop