How to do it… (with pgAdmin)

The following section illustrates the pgAdmin tool.

Once you have installed adminpack, connect to the database server; this will open a window similar to that shown in the following screenshot, reporting a general view plus information on connections, locks, and running transactions: