zhuqi-lucas commented on issue #14810:
URL: https://github.com/apache/datafusion/issues/14810#issuecomment-2682638615
```rust
/usr/bin/time -l cargo run --profile release-nonlto -- -m 3G
--mem-pool-type fair --maxrows 1 --format table -f
'/Users/zhuqi/arrow-datafusion/benchmarks/data/external_sort.sql'
Compiling datafusion-cli v45.0.0
(/Users/zhuqi/arrow-datafusion/datafusion-cli)
Finished `release-nonlto` profile [optimized] target(s) in 23.18s
Running
`/Users/zhuqi/arrow-datafusion/target/release-nonlto/datafusion-cli -m 3G
--mem-pool-type fair --maxrows 1 --format table -f
/Users/zhuqi/arrow-datafusion/benchmarks/data/external_sort.sql`
DataFusion CLI v45.0.0
0 row(s) fetched.
Elapsed 0.005 seconds.
+------------+-----------+-----------+--------------+------------+-----------------+------------+-------+------------+--------------+---------------+
| l_orderkey | l_partkey | l_suppkey | l_linenumber | l_quantity |
l_extendedprice | l_discount | l_tax | l_shipdate | l_commitdate |
l_receiptdate |
+------------+-----------+-----------+--------------+------------+-----------------+------------+-------+------------+--------------+---------------+
| 1 | 1551894 | 76910 | 1 | 17.00 | 33078.94
| 0.04 | 0.02 | 1996-03-13 | 1996-02-12 | 1996-03-22 |
| . | . | . | . | . | .
| . | . | . | . | . |
| . | . | . | . | . | .
| . | . | . | . | . |
| . | . | . | . | . | .
| . | . | . | . | . |
+------------+-----------+-----------+--------------+------------+-----------------+------------+-------+------------+--------------+---------------+
59986052 row(s) fetched. (First 1 displayed. Use --maxrows to adjust)
Elapsed 4.252 seconds.
32.07 real 12.73 user 6.46 sys
3856441344 maximum resident set size
0 average shared memory size
0 average unshared data size
0 average unshared stack size
994646 page reclaims
0 page faults
0 swaps
0 block input operations
0 block output operations
0 messages sent
0 messages received
0 signals received
2279 voluntary context switches
98027 involuntary context switches
304329202988 instructions retired
72023941353 cycles elapsed
3847026176 peak memory footprint
```
```rust
/usr/bin/time -l cargo run --profile release-nonlto -- -m 3G
--mem-pool-type fair --maxrows 1 --format csv -f
'/Users/zhuqi/arrow-datafusion/benchmarks/data/external_sort.sql'
Finished `release-nonlto` profile [optimized] target(s) in 0.32s
Running
`/Users/zhuqi/arrow-datafusion/target/release-nonlto/datafusion-cli -m 3G
--mem-pool-type fair --maxrows 1 --format csv -f
/Users/zhuqi/arrow-datafusion/benchmarks/data/external_sort.sql`
DataFusion CLI v45.0.0
0 row(s) fetched.
Elapsed 0.006 seconds.
l_orderkey,l_partkey,l_suppkey,l_linenumber,l_quantity,l_extendedprice,l_discount,l_tax,l_shipdate,l_commitdate,l_receiptdate
1,1551894,76910,1,17.00,33078.94,0.04,0.02,1996-03-13,1996-02-12,1996-03-22
59986052 row(s) fetched. (First 1 displayed. Use --maxrows to adjust)
Elapsed 3.840 seconds.
8.47 real 12.51 user 6.20 sys
3736174592 maximum resident set size
0 average shared memory size
0 average unshared data size
0 average unshared stack size
954842 page reclaims
0 page faults
0 swaps
0 block input operations
0 block output operations
0 messages sent
0 messages received
0 signals received
1528 voluntary context switches
104430 involuntary context switches
293439737861 instructions retired
69591166435 cycles elapsed
3726603512 peak memory footprint
```
--
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]
