Reference

pgmonitor(1)

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

postmaster(1), postgres(1), pg_ctl(1)

AUTHOR

This manual page was written by Oliver Elphick <[email protected]> for Debian GNU/Linux