search

xuchuanyin / workbench

0 stars 0 forks source link

2018-10-15 tpch #63

Open xuchuanyin opened 5 years ago

xuchuanyin commented 5 years ago

carbon load


+----------------------+-----------+------+---------+---------+---------+---------+---------+---------+---------+---------+
|         query        |    avg    | size |  total  |   min   |   max   |   25%   |   50%   |   75%   |   90%   |   95%   |
+----------------------+-----------+------+---------+---------+---------+---------+---------+---------+---------+---------+
|          ALL         |  193759.0 |   8  | 1550073 |   478   | 1219958 |   5608  |  32731  |  212050 | 1219958 | 1219958 |
| carbon-load-customer |  20829.0  |   1  |  20829  |  20829  |  20829  |  20829  |  20829  |  20829  |  20829  |  20829  |
| carbon-load-lineitem | 1219958.0 |   1  | 1219958 | 1219958 | 1219958 | 1219958 | 1219958 | 1219958 | 1219958 | 1219958 |
|  carbon-load-nation  |   718.0   |   1  |   718   |   718   |   718   |   718   |   718   |   718   |   718   |   718   |
|  carbon-load-orders  |  212050.0 |   1  |  212050 |  212050 |  212050 |  212050 |  212050 |  212050 |  212050 |  212050 |
|   carbon-load-part   |  32731.0  |   1  |  32731  |  32731  |  32731  |  32731  |  32731  |  32731  |  32731  |  32731  |
| carbon-load-partsupp |  57701.0  |   1  |  57701  |  57701  |  57701  |  57701  |  57701  |  57701  |  57701  |  57701  |
|  carbon-load-region  |   478.0   |   1  |   478   |   478   |   478   |   478   |   478   |   478   |   478   |   478   |
| carbon-load-supplier |   5608.0  |   1  |   5608  |   5608  |   5608  |   5608  |   5608  |   5608  |   5608  |   5608  |
+----------------------+-----------+------+---------+---------+---------+---------+---------+---------+---------+---------+
xuchuanyin commented 5 years ago

parquet load

+-----------------------+----------+------+---------+--------+--------+--------+--------+--------+--------+--------+
|         query         |    avg   | size |  total  |   min  |   max  |   25%  |   50%  |   75%  |   90%  |   95%  |
+-----------------------+----------+------+---------+--------+--------+--------+--------+--------+--------+--------+
|          ALL          | 134205.0 |   8  | 1073644 |   227  | 855780 |  3535  |  15099 | 157557 | 855780 | 855780 |
| parquet-load-customer |  15099.0 |   1  |  15099  |  15099 |  15099 |  15099 |  15099 |  15099 |  15099 |  15099 |
| parquet-load-lineitem | 855780.0 |   1  |  855780 | 855780 | 855780 | 855780 | 855780 | 855780 | 855780 | 855780 |
|  parquet-load-nation  |   960.0  |   1  |   960   |   960  |   960  |   960  |   960  |   960  |   960  |   960  |
|  parquet-load-orders  | 157557.0 |   1  |  157557 | 157557 | 157557 | 157557 | 157557 | 157557 | 157557 | 157557 |
|   parquet-load-part   |  13611.0 |   1  |  13611  |  13611 |  13611 |  13611 |  13611 |  13611 |  13611 |  13611 |
| parquet-load-partsupp |  26875.0 |   1  |  26875  |  26875 |  26875 |  26875 |  26875 |  26875 |  26875 |  26875 |
|  parquet-load-region  |   227.0  |   1  |   227   |   227  |   227  |   227  |   227  |   227  |   227  |   227  |
| parquet-load-supplier |  3535.0  |   1  |   3535  |  3535  |  3535  |  3535  |  3535  |  3535  |  3535  |  3535  |
+-----------------------+----------+------+---------+--------+--------+--------+--------+--------+--------+--------+