How to visualize a query plan

SQL optimization history

info

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

• Run any explain query and click Permalink at the end of the response
• Or open the Command page by clicking the command card in the SQL optimization history

Learn more about how you can discover commands in SQL optimization history here.

Click on one of the plan visualization methods you want to use:

• Explain Depesz - classic Postgres plan visualization made by depesz
• Explain PEV2 - another popular visualizer, initially made by AlexTatiyants and improved by the Dalibo team
• Explain FlameGraph - plan visualization inspired by Brendan Gregg's flame graphs

All visualizers are securely deployed in our infrastructure.

Plan visualization page

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