pgAdmin is a graphical tool used for PostgreSQL administration; it is available on Linux, Windows and macOS X. You can download it from https://www.pgadmin.org.
With pgAdmin, you can do the following:
- Multiple connections
- Overview of the server status in real time
- Graphical explain and graphical explain analyze
- Create databases, schemas, tables, and so on
- Run queries
Take a view at the following figure for better understanding:
![](https://static.packt-cdn.com/products/9781788474481/graphics/assets/2f2b938c-f874-4147-9392-1fecf018ba13.png)
Sometimes, figuring out why your code isn't working properly is best done by diving into the database itself and looking for bottlenecks in its code. There are a few techniques available for this.