Join us for our webinar on June 18th, 9:30am Pacific Time: Optimizing slow queries with EXPLAIN to fix bad query plans - register now.

Step 1: Check for auto_explain

The recommended Automated EXPLAIN configuration for Heroku Postgres is to use the Postgres auto_explain contrib module. This ensures accurate and detailed plan information, including runtime information (as gathered by EXPLAIN ANALYZE). With our recommended configuration (presented in a later step), performance overhead is minimal.

Check if auto_explain already enabled

First, to check if auto_explain is already enabled on your system, run the following query with heroku pg:psql:

SHOW session_preload_libraries;

If auto_explain is already there, it is enabled.

If auto_explain is not enabled

Continue to Step 2: Enable auto_explain

If auto_explain is already enabled

If auto_explain is already enabled, you can skip the next step and proceed to review our recommended auto_explain configuration settings:

Skip to Step 3: Review auto_explain settings

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →