[
https://issues.apache.org/jira/browse/CALCITE-4197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17186813#comment-17186813
]
Julian Hyde commented on CALCITE-4197:
--------------------------------------
Yes, EXPLAIN PLAN will make this feature much more easily accessible. All you
need is a JDBC connection. For example, I would love to see a notebook
interface (like Jupyter) displaying plans as graphs.
Hopefully it is not too much extra work to extend EXPLAIN PLAN.
> Provide utility to visualize RelNode plans
> ------------------------------------------
>
> Key: CALCITE-4197
> URL: https://issues.apache.org/jira/browse/CALCITE-4197
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Reporter: Liya Fan
> Assignee: Liya Fan
> Priority: Major
>
> From time to time, we want to visualize the plan generated the optimizer as a
> DAG (Directed Acyclic Graph). This gives us an overview of the plan, and
> helps us to find problems with the plan quickly.
> A common way to visualize a DAG is to dump it in the {{dot}} format, and then
> display the DAG through GraphViz. Currently, we already have a utility to
> dump the Volcano planner in dot format. In this issue, we want to dump a
> RelNode plan (a RelNode DAG) in the dot format, which will help users to see
> their plans more clearly.
> The utility should have some options that allow users to specify the
> visuzalization details, for example:
> 1. the max length of a node description.
> 2. whether RelSubset/HepRelVertex should be displayed.
> 3. Nodes that should be highlighted.
> Could you please give some feedback?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
