The Navicat server monitor can show the following properties from your selection of PostgreSQL servers:

PostgreSQL Server Process List
PostgreSQL Server Variables
PostgreSQL Server Status

How does the Server Monitor work?

Open the Server Monitor by clicking Server Monitor on the Tool menu. Select the servers that you want to monitor by checking them in the check-listbox on the left hand side of the Server Monitor Window. After you have selected your servers, click on either the Process List, Variables or Status Tab depending on what you want to see.

Process List

Click the Process List Tab to get a list of processes from all the PostgreSQL servers selected in the check-listbox.

If you have the process privilege, you can see all processes. Otherwise, you can see only your own processes. The process list provides the following information:

1. The Name of the server as set up in Navicat
2. The ID of the process on the PostgreSQL server
3. The PostgreSQL User of the process
4. The host from which the user is connected
5. The database that the user is currently using
6. The last command that was issued by the user
7. The time, state and info of the process.

Ending Processes on a PostgreSQL Server

If you have the process privilege, you can see and kill all processes on the PostgreSQL server. Otherwise, you can see and kill only your own processes.

To kill a thread on the server, click the Process List button to get a list of processes running on the server. Click on the process you want to kill and then click the End Process button.

Server Variables

Click the Variables Tab to get a list of the PostgreSQL server variables.

Server Status

Click the Status Tab to get the status of the PostgreSQL server.