Use explain (distsql, format dot) for dashboard to visualize graph

[kwannoel]

https://risingwave-labs.slack.com/archives/C034U0NH5ND/p1732267878599779?thread_ts=1732168127.133129&cid=C034U0NH5ND

Current the RW dashboard has a graph for distributed plan:

We can replace this with explain (format dot, distsql) and render it with graphviz.

We might not support distsql + format dot yet. This is a prerequisite for this task.

[lyang24]

can i take this?

[kwannoel]

can i take this?

Assigned, thanks!

[kwannoel]

You can open 2 separate PRs. One for explain format dot distsql. Another for the dashboard changes.

[lyang24]

May not relate to this issue directly, just checked out the explain function on dashboard, from a user point of view - I felt like its easier to write the explain (distsql) xxx and get the graph output. Currently i have to paste the output json from terminal to the ui.

[kwannoel]

May not relate to this issue directly, just checked out the explain function on dashboard, from a user point of view - I felt like its easier to write the explain (distsql) xxx and get the graph output. Currently i have to paste the output json from terminal to the ui.

We can change this panel to a more general "render graphviz" panel. It can be used to render all kinds of explain queries.
The dashboard cannot directly run the SQL, we will need to manage access to the DB via the dashboard if we want to support this.