ptop | PostgreSQL performance monitoring tool akin to top | Mehr ...
ptop is a console-based tool for monitoring a PostgreSQL database. . With ptop 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