Step 4: Test and Verify
At this point, your pganalyze setup should be ready to collect EXPLAIN plans. Since you may not have any slow queries in your system right now, we can generate a synthetic slow query that we can use to confirm everything is working.
The collector includes a flag to do this for you automatically, based on your
auto_explain.log_min_duration
:
sudo pganalyze-collector --test-explain
This will produce no output but will run an artificially slow query using the
Postgres pg_sleep
function.
Assuming the collector is running in the background, after a few minutes you should then see EXPLAIN plans show up in the pganalyze EXPLAIN plan list:
![Screenshot of EXPLAIN list in pganalyze](/static/log-explain-overview-ea6673caa395090cb14e2bda5a23bf07.png)
When you select one of the query executions in this list, you will see details of the corresponding plan:
![Screenshot of EXPLAIN plan in pganalyze](/static/log-explain-details-146b1e7d43719483e593676d026ce3ed.png)
From now on, you will now get EXPLAIN plans automatically in the pganalyze UI, for all your slow queries.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →