Rachelint commented on issue #13449: URL: https://github.com/apache/datafusion/issues/13449#issuecomment-2481048885
For q18, I found string view lead to some regression? ``` [[email protected]] 16:10:45 ~/arrow-datafusion $ sudo perf record -F 99 -g --call-graph dwarf /home/db/arrow-datafusion/target/release/dfbench clickbench --iterations 5 --path /home/db/arrow-datafusion/benchmarks/data/hits.parquet --queries-path /home/db/arrow-datafusion/benchmarks/queries/clickbench/queries.sql --query 18 --force-view-types Running benchmarks with the following options: RunOpt { query: Some(18), common: CommonOpt { iterations: 5, partitions: None, batch_size: 8192, debug: false, force_view_types: true }, path: "/home/db/arrow-datafusion/benchmarks/data/hits.parquet", queries_path: "/home/db/arrow-datafusion/benchmarks/queries/clickbench/queries.sql", output_path: None } Q18: SELECT "UserID", extract(minute FROM to_timestamp_seconds("EventTime")) AS m, "SearchPhrase", COUNT(*) FROM hits GROUP BY "UserID", m, "SearchPhrase" ORDER BY COUNT(*) DESC LIMIT 10; Query 18 iteration 0 took 8186.2 ms and returned 10 rows Query 18 iteration 1 took 8292.9 ms and returned 10 rows Query 18 iteration 2 took 8276.1 ms and returned 10 rows Query 18 iteration 3 took 8327.8 ms and returned 10 rows Query 18 iteration 4 took 8165.0 ms and returned 10 rows [ perf record: Woken up 762 times to write data ] [ perf record: Captured and wrote 190.757 MB perf.data (24029 samples) ] [[email protected]] 16:11:38 ~/arrow-datafusion $ sudo perf record -F 99 -g --call-graph dwarf /home/db/arrow-datafusion/target/release/dfbench clickbench --iterations 5 --path /home/db/arrow-datafusion/benchmarks/data/hits.parquet --queries-path /home/db/arrow-datafusion/benchmarks/queries/clickbench/queries.sql --query 18 Running benchmarks with the following options: RunOpt { query: Some(18), common: CommonOpt { iterations: 5, partitions: None, batch_size: 8192, debug: false, force_view_types: false }, path: "/home/db/arrow-datafusion/benchmarks/data/hits.parquet", queries_path: "/home/db/arrow-datafusion/benchmarks/queries/clickbench/queries.sql", output_path: None } Q18: SELECT "UserID", extract(minute FROM to_timestamp_seconds("EventTime")) AS m, "SearchPhrase", COUNT(*) FROM hits GROUP BY "UserID", m, "SearchPhrase" ORDER BY COUNT(*) DESC LIMIT 10; Query 18 iteration 0 took 7820.3 ms and returned 10 rows Query 18 iteration 1 took 7648.6 ms and returned 10 rows Query 18 iteration 2 took 7847.3 ms and returned 10 rows Query 18 iteration 3 took 7629.2 ms and returned 10 rows Query 18 iteration 4 took 7709.3 ms and returned 10 rows ``` -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
