NEW: Paste your query and schema data and we give you the best index. Launch pganalyze Index Advisor

Step 2: Enable log-based EXPLAIN

You will need to update the collector configuration to enable log-based EXPLAIN.

If using the config file, make the following changes to your pganalyze-collector.conf:

enable_log_explain: true

If running the collector in a container, set these environment variables instead:

  • PGA_ENABLE_LOG_EXPLAIN=true

Afterwards make sure to reload the pganalyze collector, so the setting takes effect:

sudo pganalyze-collector --test --reload

If this test succeeds, continue to the next step to test plan collection:

Proceed to Step 3: Test and verify

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