pgAdmin

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:

Profiling the database

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.

gprof

The standard GNU profiler, gprof, is available for most Unix...