[
https://issues.apache.org/jira/browse/CALCITE-3915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xiening Dai updated CALCITE-3915:
---------------------------------
Comment: was deleted
(was: The example in the description is messed up due to the indents. We will
have a pretty output in console.)
> Add rule listener to report rule attempts and time at DEBUG log level
> ---------------------------------------------------------------------
>
> Key: CALCITE-3915
> URL: https://issues.apache.org/jira/browse/CALCITE-3915
> Project: Calcite
> Issue Type: Bug
> Reporter: Xiening Dai
> Priority: Minor
>
> We can add a rule listener to the VolcanoPlanner for recording rule attempts
> and the accumulative time for the rule firing. This would be very helpful to
> debug planner performance issue (such as CALCITE-2970). The listener will
> only be added under DEBUG log level.
> It will produce a rule attempt summary like below -
> {noformat}
> 2020-04-10 18:03:24,621 [main] DEBUG -
> Rules
> Attempts Time (us)
> ProjectMergeRule:force_mode
> 1,203 1,124,242
> EnumerableProjectRule(in:NONE,out:ENUMERABLE)
> 129 226,475
> AggregatePullUpConstantsRule
> 84 1,949
> AggregateProjectMergeRule
> 81 128,575
> ProjectFilterTransposeRule
> 76 8,734
> JoinPushExpressionsRule
> 71 10,314
> FilterJoinRule:FilterJoinRule:no-filter
> 71 1,306
> JoinPushThroughJoinRule:right
> 47 676
> JoinPushThroughJoinRule:left
> 45 175,696
> FilterJoinRule:FilterJoinRule:filter
> 41 89,381
> ReduceExpressionsRule(Filter)
> 24 38,128
> EnumerableFilterRule(in:NONE,out:ENUMERABLE)
> 24 52,457
> EnumerableJoinRule(in:NONE,out:ENUMERABLE)
> 24 71,752
> EnumerableMergeJoinRule(in:NONE,out:ENUMERABLE)
> 24 47,987
> FilterProjectTransposeRule
> 22 55,177
> JoinCommuteRule
> 20 70,240
> EnumerableAggregateRule(in:NONE,out:ENUMERABLE)
> 10 26,522
> AggregateExpandDistinctAggregatesRule
> 10 37
> EnumerableTableScanRule(in:NONE,out:ENUMERABLE)
> 1 527
> EnumerableInterpreterRule(in:BINDABLE,out:ENUMERABLE)
> 1 764
> BindableTableScanRule
> 1 1,710
> ExpandConversionRule
> 1 175
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
