Another useful tool for monitoring database activity is the pg_locks system table. It allows the database administrator to view information

PostgreSQL provides facilities to support dynamic tracing of the database server. This allows an external utility to be called at specific

On most Unix platforms, PostgreSQL modifies its command title as reported by ps, so that individual server processes

The most important disk monitoring task of a database administrator is to make sure the disk doesn't become full. A filled data disk will not result in data corruption, but

Each table has a primary heap disk file where most of the data is stored. If the table has any columns with potentially-wide values, there also might be a

PostgreSQL has the ability to report the progress of certain commands during command execution. Currently, the only command which supports

PostgreSQL's statistics collector is a subsystem that supports collection and reporting of information about server