SQL optimization history
- 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.