Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-4197

Provide utility to visualize RelNode plans

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.26.0
    • core

    Description

      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?

      Attachments

        1. screenshot-1.png
          39 kB
          Liya Fan
        2. screenshot-2.png
          31 kB
          Liya Fan
        3. screenshot-3.png
          7 kB
          Liya Fan
        4. screenshot-4.png
          31 kB
          Liya Fan
        5. screenshot-5.png
          40 kB
          Liya Fan
        6. screenshot-6.png
          39 kB
          Liya Fan
        7. screenshot-7.png
          29 kB
          Liya Fan

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            fan_li_ya Liya Fan
            fan_li_ya Liya Fan
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 4h
                4h

                Slack

                  Issue deployment