wangyum commented on pull request #30865:
URL: https://github.com/apache/spark/pull/30865#issuecomment-748826458


   ```
   21:47:51.449 WARN org.apache.spark.sql.TPCDSQuerySuite: 
   === Metrics of Analyzer/Optimizer Rules ===
   Total number of runs: 246192
   Total time: 105.655380705 seconds
   
   Rule                                                                         
     Effective Time / Total Time                     Effective Runs / Total 
Runs                    
   
   org.apache.spark.sql.catalyst.optimizer.Optimizer$OptimizeSubqueries         
     13967311221 / 17930421970                       47 / 772                   
                    
   org.apache.spark.sql.catalyst.optimizer.ColumnPruning                        
     1386295449 / 6773304521                         328 / 2383                 
                    
   org.apache.spark.sql.catalyst.analysis.Analyzer$ResolveAggregateFunctions    
     1333101651 / 3589200583                         49 / 2166                  
                    
   org.apache.spark.sql.catalyst.analysis.Analyzer$AddMetadataColumns           
     0 / 3410575751                                  0 / 2176                   
                    
   org.apache.spark.sql.catalyst.analysis.Analyzer$ResolveSubquery              
     2926377387 / 3067767576                         51 / 2166                  
                    
   org.apache.spark.sql.catalyst.optimizer.PruneFilters                         
     32468139 / 2319485483                           5 / 1997                   
                    
   org.apache.spark.sql.catalyst.analysis.DecimalPrecision                      
     1921173686 / 2150344481                         361 / 2166                 
                    
   org.apache.spark.sql.catalyst.optimizer.PushDownPredicates                   
     884285005 / 1843322102                          767 / 2390                 
                    
   org.apache.spark.sql.catalyst.optimizer.BooleanSimplification                
     7784243 / 1672676489                            4 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.ReorderJoin                          
     708427120 / 1662902661                          177 / 1611                 
                    
   org.apache.spark.sql.catalyst.optimizer.RemoveNoopOperators                  
     137522205 / 1546275507                          116 / 2383                 
                    
   org.apache.spark.sql.catalyst.optimizer.NullPropagation                      
     109179965 / 1382088206                          59 / 1611                  
                    
   org.apache.spark.sql.catalyst.optimizer.OptimizeJsonExprs                    
     0 / 1326862595                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.SimplifyBinaryComparison             
     413782 / 1314356052                             1 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.SimplifyConditionals                 
     424467 / 1302138752                             1 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.CollapseProject                      
     220138136 / 1297546216                          220 / 1997                 
                    
   org.apache.spark.sql.catalyst.optimizer.ConstantFolding                      
     204135630 / 1285454678                          197 / 1611                 
                    
   org.apache.spark.sql.catalyst.optimizer.UnwrapCastInBinaryComparison         
     12264430 / 1278802169                           8 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.LikeSimplification                   
     677386 / 1269174316                             1 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.SimplifyCaseConversionExpressions    
     0 / 1261731288                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.InferFiltersFromConstraints          
     1187921660 / 1251528301                         278 / 386                  
                    
   org.apache.spark.sql.catalyst.optimizer.SimplifyExtractValueOps              
     0 / 1247930226                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.PushFoldableIntoBranches             
     15151058 / 1247174639                           19 / 1611                  
                    
   org.apache.spark.sql.catalyst.optimizer.SimplifyCasts                        
     100866650 / 1236069244                          83 / 1611                  
                    
   org.apache.spark.sql.catalyst.optimizer.ReorderAssociativeOperator           
     0 / 1232823764                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.OptimizeIn                           
     19230987 / 1209426575                           27 / 1611                  
                    
   org.apache.spark.sql.catalyst.optimizer.RemoveDispensableExpressions         
     0 / 1200696182                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.ReplaceNullWithFalseInPredicate      
     12294169 / 1187601942                           17 / 1611                  
                    
   org.apache.spark.sql.catalyst.optimizer.CombineUnions                        
     45074167 / 1151074096                           43 / 1997                  
                    
   org.apache.spark.sql.catalyst.optimizer.CollapseRepartition                  
     0 / 1111211134                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.ConstantPropagation                  
     0 / 1051772192                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.analysis.UpdateAttributeNullability            
     19068252 / 1026787123                           12 / 1453                  
                    
   org.apache.spark.sql.catalyst.optimizer.CombineFilters                       
     0 / 1026089915                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.CollapseWindow                       
     0 / 1019354027                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.EliminateSerialization               
     0 / 1006513732                                  0 / 1611                   
                    
   org.apache.spark.sql.catalyst.optimizer.SimplifyConditionalInPredicate       
     2930801 / 1004655515                            6 / 1611                   
                    
   
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to