PROFILE

SHOW PROFILE

根据SQL的Job ID查看SQL执行过程中的PROFILE的信息。since AIR 2.0

• 语法说明

SHOW PROFILE INFO 'jobId';

• 使用示例

show profile info 'cf1da82a-0380-40f1-8fd4-24d73edf5891';

• 返回结果

[SqlJobId a7de3745-f80c-4ab1-8a11-1ffa7a86deb1 
PlanningPhase : 
Phase Name:Parse,DurationMillis:30ms 
Phase Name:Raw relNode,DurationMillis:265ms 
LogicalProject(deptno=[$0], name=[$1])
  LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:Query Use Default Raw,DurationMillis:2ms 
LogicalProject(deptno=[$0], name=[$1])
  LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:expressionReduce,DurationMillis:22ms 
LogicalProject(deptno=[$0], name=[$1])
  LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:windowRewrite,DurationMillis:1ms 
LogicalProject(deptno=[$0], name=[$1])
  LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:rexSimplify,DurationMillis:0ms 
LogicalProject(deptno=[$0], name=[$1])
  LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:removeExpansionNode,DurationMillis:0ms 
LogicalProject(deptno=[$0], name=[$1])
  LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:subQueryRewrite,DurationMillis:0ms 
LogicalProject(deptno=[$0], name=[$1])
  LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:trimFields,DurationMillis:4ms 
LogicalProject(deptno=[$0], name=[$1])
  LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:deCorrelate,DurationMillis:5ms 
LogicalProject(deptno=[$0], name=[$1])
  LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:projectRewrite,DurationMillis:3ms 
LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:setOpRewrite,DurationMillis:0ms 
LogicalScanRel(table=[[default_catalog, hr, depts]])
Phase Name:queryRewrite,DurationMillis:53ms 
TardisLogicalJdbcScan(table=[[default_catalog, hr, depts]])
Phase Name:addRenameProject,DurationMillis:0ms 
LogicalProject(deptno=[$0], name=[$1])
  TardisLogicalJdbcScan(table=[[default_catalog, hr, depts]])
]