How to visualize a query plan
SQL optimization history
Enable the "History" feature using the configuration options
- Execute any
explainquery and click the Permalink at the end of the response
- Or open the Command page by clicking the command card on the SQL optimization history
Learn more about how you can discover command in SQL optimization history here.
Click on one of the plan visualization methods you want to use:
- Explain Depesz - classic PostgreSQL plan visualization made by depesz
- Explain PEV2 - another famous visualizator, initially made by AlexTatiyants and improved by the Dalibo team
- Explain FlameGraph - plan visualization inspired by Brendan Gregg's flamegraphs
All visualizators are securely deployed in our infrastructure.
Plan visualization page
- Paste Plan with execution in JSON format to the Plan field on the Plan visualization page.
- Click on the button related to the visualization method you want to use.