What logs does your Postgres dump?
I set these setting on postgresql.conf
#The default is NOTICE.
log_min_error_statement = WARNING
#I set ten seconds.
log_min_duration_statement = 10000
Controls whether or not the SQL statement that causes an error condition will be recorded in the server log.
Causes the duration of each completed statement to be logged if the statement ran for at least the specified number of milliseconds.