You can also use pgAdmin to get a quick view of what is going on in the database. For better control, you need to install the adminpack extension in the destination database, by issuing this command:
CREATE EXTENSION adminpack;
This extension is a part of the additionally supplied modules of PostgreSQL (aka contrib). It provides several administration functions that PgAdmin (and other tools) can use in order to manage, control, and monitor a Postgres server from a remote location.
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:
![](https://static.packt-cdn.com/products/9781785883187/graphics/assets/78214693-15a7-4412-80bd-922bf5b3113c.png)