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, typically in /etc/pganalyze-collector.conf:

enable_log_explain = true

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

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

sudo pganalyze-collector --test

Successful test run will reload the collector. If this test succeeds, continue to the next step to test plan collection:

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