feat: explain an existing MV to show the fragment_id, table id and names

[fuyufjh]

Is your feature request related to a problem? Please describe.

Currently, it's difficult to tell which state table belongs to which part of the execution plan.

Describe the solution you'd like

We may provide a syntax like

explain <table_or_mv_or_sink_name>

and then it will print a physical plan (i.e. fragments) with the real IDs, including (and not limited to) fragment_id, table id and names, etc.

Describe alternatives you've considered

This is an alternative to the dashboard. Would be helpful when we can't access the dashboard easily.

Additional context

No response

[lmatz]

thinking it can be integrated into the diagnose command,
users just one click and print all the query plans for off-site debugging

[fuyufjh]

thinking it can be integrated into the diagnose command, users just one click and print all the query plans for off-site debugging

Right. That's also what I think.