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
sudo pganalyze-collector --test-explain
This will produce no output but will run an artificially slow query using the
Assuming the collector is running in the background, after a few minutes you should then see an EXPLAIN plan show up in the pganalyze EXPLAIN plan list:
When you go to the details, you will find the corresponding plan:
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 →