ptop
Ptop, often written ptop, is the name used by several open-source tools that provide real-time monitoring of PostgreSQL servers and, in some cases, broader system activity. The most commonly referenced project is a PostgreSQL monitoring utility that presents a top-like, terminal-based view of server activity. It is designed to help database administrators identify long-running queries, blocking locks, and other performance bottlenecks by displaying per-backend state, current queries, and I/O activity.
Ptop projects are typically implemented as text-based interfaces built with a curses-like library. They connect to
Common features include sorting and filtering of displayed backends by user, database, or query, highlighting of
Usage usually involves running a command in the shell with connection parameters such as host, port, user,