[ARROW-9654] [Rust][DataFusion] Add an EXPLAIN command to the datafusion CLI

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Component/s: Rust, Rust - DataFusion
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/25713
• Assignee: Andrew Lamb
• Reporter: Andrew Lamb
• Created: 05/Aug/20 12:51
• Updated: 11/Jan/23 08:08
• Resolved: 14/Aug/20 22:16

Description

In order to understand what DataFusion's planner is doing, it would be helpful to have an "EXPLAIN PLAN" feature. All other database systems I have worked with have such a feature (e.g. see MySql).

I have found EXPLAIN helpful for both users but also very much developers.

The feature would look something like

EXPLAIN <sql>

Which would then print a string with the logical plan. One way to implement this would simply be to use the debugging printout of the logical and physical plans

Issue Links

• links to: GitHub Pull Request #7959