pgmonitor1

Usage

Overview

pgmonitor displays a window showing all current PostgreSQL backends on the machine on which pgmonitor is run.

If pgmonitor is run by root or by the PostgreSQL administrator, it is able to find the query curently being executed by a backend. It can also cancel a query, terminate a backend or shutdown the postmaster.

The default admin_user_name is "postgres"; this should not need to be specified.

pgmonitor uses ps to find processes to display.

Action Buttons

Refresh

Reload the display. (This normally happens regularly; the interval between reloads is specified by the field next to the Refresh button.)

Sort

Displays a dialog in which the display order of the backend processes can be changed.

Query

Displays a dialog box containing the query (if any) currently being executed by the currently-selected backend.

Cancel

Cancels the query being run by the currently-selected backend.

Terminate

Closes the currently-selected backend.

Shutdown

Shuts down the PostgreSQL postmaster.

Help

Displays a help message.

Exit

Ends the pgmonitor program.