From your console within your project directory type the following command:
heroku logs --tail --ps postgres
Slow queries are automatically logged by heroku. This will tail your app logs and filter them for the postgres process only. It's great real-time feedback of your app's database performance.