man pgmonitor () - monitor activity of PostgreSQL backends

NAME

pgmonitor - monitor activity of PostgreSQL backends

SYNOPSIS

pgmonitor [admin_user_name]

DESCRIPTION

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.

SEE ALSO

AUTHOR

This manual page was written by Oliver Elphick <olly@lfix.co.uk> for Debian GNU/Linux