Execution Visualized: Shareable Plan Visualization for DuckDB based on PEV2
For query debugging and optimization, it is crucial to understand the execution plan of a query. In the context of DuckDB, the execution plan can be viewed in several formats. However, these visualizations are not easily shareable. The goal of this thesis is to adapt the PEV2 tool to visualize DuckDB’s execution plans. PEV2 is a web-based tool that allows users to visualize query execution plans of PostgreSQL. The tool is designed to be easily shareable and interactive.
The thesis will involve adapting PEV2 to work with DuckDB’s execution plans. This will involve understanding the structure of DuckDB’s execution plans and adapting the visualization tool to work with them.