How to visualize a query plan

SQL optimization history

info

Enable the "History" feature using the configuration options HISTORY_ENABLED and PLATFORM_.

• Execute any explain query 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

1. Paste Plan with execution in JSON format to the Plan field on the Plan visualization page.
2. Click on the button related to the visualization method you want to use.