...
For .dump backups retained by Heroku (we retain up to 25) a restore takes about a minute and works like this (to restore to the most recent)
heroku pg:backups:restore --app scihist-digicoll-production
or, to a particular database backup:
heroku pg:backups:restore a188 --app scihist-digicoll-production
...