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_explainIf 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:
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →