Postgres includes lots of monitoring tools that allow you to see what is happening, but there are a few settings that really go into detail, e.g. log_statement_stats:
SET client_min_messages = log;
S...
In Toad Data Modeler working with large data models is simplified by importing/exporting models into a format like Excel. Watch this video for a tutorial....
Watch this video to get started with connections, connection properties and import and export of connections in the Toad Edge Preview for PostgreSQL....
