[ https://issues.apache.org/jira/browse/DRILL-5247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15858883#comment-15858883 ]
Chunhui Shi commented on DRILL-5247: ------------------------------------ "explain plan including all attributes for " will get the cost details returned. Is that not enough, if you need cost information about abandoned plans, usually I will go to calcite logs. > Text form of EXPLAIN statement does not have same information as profile > ------------------------------------------------------------------------ > > Key: DRILL-5247 > URL: https://issues.apache.org/jira/browse/DRILL-5247 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.9.0 > Reporter: Paul Rogers > Priority: Minor > > Create as simple query. Run it and view the "physical plan" in the Web UI or > the profile JSON. That plan contains a rich set of information about operator > costs and so on. > Now, with the same query, execute an EXPLAIN statement. The resulting plan > looks like the one in the profile, but lacks the cost detail. (See below.) > Since the cost detail comes from the planner, and is essential to > understanding why a plan was chosen, the information should appear in the > EXPLAIN output. (After all, the output is supposed to EXPLAIN the plan...) > Example of EXPLAIN output: > {code} > 00-00 Screen > 00-01 Project(id_i=[$0], name_s20=[$1]) > 00-02 SelectionVectorRemover > 00-03 Filter(condition=[=($0, 10)]) > 00-04 Scan(groupscan=[MockGroupScanPOP [url=null, > readEntries=[MockScanEntry [records=10000, columns=[MockColumn > [minorType=INT, name=id_i, mode=REQUIRED], MockColumn [minorType=VARCHAR, > name=name_s20, mode=REQUIRED]]]]]]) > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)