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
Causes the duration of each completed statement to be logged if the statement ran for at least the specified number of milliseconds.