[GitHub] [arrow-datafusion] Jimexist commented on pull request #564: Add benchmarks to window function queries

[GitBox <gi...@apache.org>]

Jimexist commented on pull request #564:
URL: https://github.com/apache/arrow-datafusion/pull/564#issuecomment-865005156


   updated benchmark:
   
   ```
   Benchmarking window empty over, aggregate functions: Warming up for 3.0000 s
   Warning: Unable to complete 100 samples in 5.0s. You may wish to increase target time to 9.5s, enable flat sampling, or reduce sample count to 50.
   window empty over, aggregate functions
                           time:   [1.8108 ms 1.8229 ms 1.8366 ms]
   Found 9 outliers among 100 measurements (9.00%)
     6 (6.00%) high mild
     3 (3.00%) high severe
   
   Benchmarking window empty over, built-in functions: Warming up for 3.0000 s
   Warning: Unable to complete 100 samples in 5.0s. You may wish to increase target time to 7.1s, enable flat sampling, or reduce sample count to 50.
   window empty over, built-in functions
                           time:   [1.3960 ms 1.4046 ms 1.4148 ms]
   Found 11 outliers among 100 measurements (11.00%)
     6 (6.00%) high mild
     5 (5.00%) high severe
   
   window order by, aggregate functions
                           time:   [8.4081 ms 8.5143 ms 8.6268 ms]
   Found 2 outliers among 100 measurements (2.00%)
     2 (2.00%) high mild
   
   window order by, built-in functions
                           time:   [7.4327 ms 7.4752 ms 7.5203 ms]
   Found 2 outliers among 100 measurements (2.00%)
     2 (2.00%) high mild
   
   window partition by, u64_wide, aggregate functions
                           time:   [17.877 ms 17.982 ms 18.094 ms]
   Found 2 outliers among 100 measurements (2.00%)
     2 (2.00%) high mild
   
   window partition by, u64_narrow, aggregate functions
                           time:   [6.4812 ms 6.5318 ms 6.5843 ms]
   Found 4 outliers among 100 measurements (4.00%)
     4 (4.00%) high mild
   
   window partition by, u64_wide, built-in functions
                           time:   [16.144 ms 16.248 ms 16.360 ms]
   Found 9 outliers among 100 measurements (9.00%)
     6 (6.00%) high mild
     3 (3.00%) high severe
   
   window partition by, u64_narrow, built-in functions
                           time:   [5.8226 ms 5.8595 ms 5.8988 ms]
   Found 11 outliers among 100 measurements (11.00%)
     11 (11.00%) high mild
   
   window partition and order by, u64_wide, aggregate functions
                           time:   [25.350 ms 25.578 ms 25.824 ms]
   Found 4 outliers among 100 measurements (4.00%)
     4 (4.00%) high mild
   
   Benchmarking window partition and order by, u64_narrow, aggregate functions: Warming up for 3.0000 s
   Warning: Unable to complete 100 samples in 5.0s. You may wish to increase target time to 5.4s, or reduce sample count to 90.
   window partition and order by, u64_narrow, aggregate functions
                           time:   [53.310 ms 53.726 ms 54.169 ms]
   Found 3 outliers among 100 measurements (3.00%)
     3 (3.00%) high mild
   
   window partition and order by, u64_wide, built-in functions
                           time:   [23.481 ms 23.690 ms 23.917 ms]
   Found 3 outliers among 100 measurements (3.00%)
     2 (2.00%) high mild
     1 (1.00%) high severe
   
   window partition and order by, u64_narrow, built-in functions
                           time:   [15.603 ms 15.715 ms 15.839 ms]
   Found 6 outliers among 100 measurements (6.00%)
     2 (2.00%) high mild
     4 (4.00%) high severe
   ```


-- 
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:
users@infra.apache.org