Step 2: Enable auto_explain

You can enable auto_explain for your Heroku Postgres by running the following:

heroku pg:settings:auto-explain [database-addon-name] on -a [your-app-name]

Subsequent Postgres sessions will then be configured with those settings and will automatically log the EXPLAIN plan for any qualifying statements to your Postgres logs.