Install pgtop by entering the following commands in the terminal:
sudo apt update sudo apt install pgtop
Description:
PostgreSQL performance monitoring tool akin to top
pg_top is a console-based tool for monitoring a PostgreSQL database. . With pg_top you can: * View currently running SQL statement of a process * View query plan of a currently running SELECT statement * View locks held by a process * View user table statistics * View user index statistics
Homepage: http://ptop.projects.postgresql.org/
Version: 3.7.0-2build2
Section: universe/misc