You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "zhuqi-lucas (via GitHub)" <gi...@apache.org> on 2025/03/24 10:12:35 UTC

[PR] Minor: add average time for clickbench benchmark query [datafusion]

zhuqi-lucas opened a new pull request, #15381:
URL: https://github.com/apache/datafusion/pull/15381

   ## Which issue does this PR close?
   
   Minor: add average time for clickbench benchmark query
   
   ## Rationale for this change
   
   Minor: add average time for clickbench benchmark query
   
   ## What changes are included in this PR?
   
   Minor: add average time for clickbench benchmark query
   
   ## Are these changes tested?
   
   Yes
   
   ## Are there any user-facing changes?
   
   Minor: add average time for clickbench benchmark query


-- 
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: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] Minor: add average time for clickbench benchmark query [datafusion]

Posted by "zhuqi-lucas (via GitHub)" <gi...@apache.org>.
zhuqi-lucas commented on PR #15381:
URL: https://github.com/apache/datafusion/pull/15381#issuecomment-2747580128

   Testing result:
   ```rust
   cargo run --profile release-nonlto  --bin dfbench -- clickbench     -q 1
       Finished `release-nonlto` profile [optimized] target(s) in 0.27s
        Running `target/release-nonlto/dfbench clickbench -q 1`
   Running benchmarks with the following options: RunOpt { query: Some(1), common: CommonOpt { iterations: 3, partitions: None, batch_size: 8192, mem_pool_type: "fair", memory_limit: None, sort_spill_reservation_bytes: None, debug: false }, path: "benchmarks/data/hits.parquet", queries_path: "benchmarks/queries/clickbench/queries.sql", output_path: None }
   Q1: SELECT COUNT(*) FROM hits WHERE "AdvEngineID" <> 0;
   Query 1 iteration 0 took 123.9 ms and returned 1 rows
   Query 1 iteration 1 took 56.0 ms and returned 1 rows
   Query 1 iteration 2 took 47.3 ms and returned 1 rows
   Query 1 avg time: 75.75 ms
   ```


-- 
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: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] Minor: add average time for clickbench benchmark query [datafusion]

Posted by "xudong963 (via GitHub)" <gi...@apache.org>.
xudong963 merged PR #15381:
URL: https://github.com/apache/datafusion/pull/15381


-- 
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: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org