| time/op
|
---|
AvgAggregateInt/count=1000-8 | 162µs ± 0% | 164µs ± 0% | 162µs ± 0% | 167µs ± 0% | 167µs ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 54.3µs ± 0% | 54.8µs ± 0% | 55.3µs ± 0% | 56.8µs ± 0% | 58.3µs ± 0%
|
AvgAggregateFloat/count=1000-8 | 23.4µs ± 0% | 23.2µs ± 0% | 23.9µs ± 0% | 23.3µs ± 0% | 23.5µs ± 0%
|
AvgAggregateDecimal/count=1000-8 | 277µs ± 0% | 290µs ± 0% | 287µs ± 0% | 285µs ± 0% | 290µs ± 0%
|
CountAggregate/count=1000-8 | 17.4µs ± 0% | 17.8µs ± 0% | 17.4µs ± 0% | 17.5µs ± 0% | 18.4µs ± 0%
|
SumIntAggregateInt/count=1000-8 | 37.7µs ± 0% | 37.2µs ± 0% | 39.1µs ± 0% | 37.8µs ± 0% | 37.8µs ± 0%
|
SumAggregateInt/count=1000-8 | 148µs ± 0% | 148µs ± 0% | 146µs ± 0% | 151µs ± 0% | 154µs ± 0%
|
SumAggregateSmallInt/count=1000-8 | 45.3µs ± 0% | 45.3µs ± 0% | 44.5µs ± 0% | 45.7µs ± 0% | 45.3µs ± 0%
|
SumAggregateFloat/count=1000-8 | 18.3µs ± 0% | 18.2µs ± 0% | 18.3µs ± 0% | 18.2µs ± 0% | 18.4µs ± 0%
|
SumAggregateDecimal/count=1000-8 | 267µs ± 0% | 264µs ± 0% | 265µs ± 0% | 263µs ± 0% | 258µs ± 0%
|
MaxAggregateInt/count=1000-8 | 22.4µs ± 0% | 22.9µs ± 0% | 24.2µs ± 0% | 23.2µs ± 0% | 23.1µs ± 0%
|
MaxAggregateFloat/count=1000-8 | 22.4µs ± 0% | 23.6µs ± 0% | 22.9µs ± 0% | 23.1µs ± 0% | 23.2µs ± 0%
|
MaxAggregateDecimal/count=1000-8 | 132µs ± 0% | 134µs ± 0% | 111µs ± 0% | 127µs ± 0% | 187µs ± 0%
|
MinAggregateInt/count=1000-8 | 22.5µs ± 0% | 22.9µs ± 0% | 23.5µs ± 0% | 22.5µs ± 0% | 22.8µs ± 0%
|
MinAggregateFloat/count=1000-8 | 23.6µs ± 0% | 23.0µs ± 0% | 22.7µs ± 0% | 23.0µs ± 0% | 23.1µs ± 0%
|
MinAggregateDecimal/count=1000-8 | 83.6µs ± 0% | 88.5µs ± 0% | 91.5µs ± 0% | 87.8µs ± 0% | 101.8µs ± 0%
|
VarianceAggregateInt/count=1000-8 | 14.0ms ± 0% | 13.9ms ± 0% | 13.9ms ± 0% | 14.3ms ± 0% | 13.9ms ± 0%
|
VarianceAggregateFloat/count=1000-8 | 20.8µs ± 0% | 21.0µs ± 0% | 20.7µs ± 0% | 20.8µs ± 0% | 20.9µs ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 14.0ms ± 0% | 13.9ms ± 0% | 14.0ms ± 0% | 14.1ms ± 0% | 13.7ms ± 0%
|
StdDevAggregateInt/count=1000-8 | 14.2ms ± 0% | 14.2ms ± 0% | 13.9ms ± 0% | 14.4ms ± 0% | 14.0ms ± 0%
|
StdDevAggregateFloat/count=1000-8 | 24.5µs ± 0% | 26.1µs ± 0% | 25.1µs ± 0% | 25.4µs ± 0% | 24.6µs ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 14.0ms ± 0% | 14.1ms ± 0% | 14.0ms ± 0% | 14.2ms ± 0% | 14.1ms ± 0%
|
LikeWithCache-8 | 3.17µs ± 0% | 3.10µs ± 0% | 3.14µs ± 0% | 3.20µs ± 0% | 3.14µs ± 0%
|
LikeWithoutCache-8 | 33.6µs ± 0% | 33.6µs ± 0% | 32.4µs ± 0% | 32.2µs ± 0% | 32.6µs ± 0%
|
ILikeWithCache-8 | 3.94µs ± 0% | 3.99µs ± 0% | 3.93µs ± 0% | 4.04µs ± 0% | 3.96µs ± 0%
|
ILikeWithoutCache-8 | 37.3µs ± 0% | 37.6µs ± 0% | 36.3µs ± 0% | 36.4µs ± 0% | 36.4µs ± 0%
|
Parse-8 | 40.5µs ± 0% | 41.3µs ± 0% | 39.3µs ± 0% | 38.1µs ± 0% | 39.3µs ± 0%
|
EncodeSQLString/old_version-8 | 1.11ms ± 0% | 1.11ms ± 0% | 1.09ms ± 0% | 1.09ms ± 0% | 1.14ms ± 0%
|
EncodeSQLString/new_version-8 | 363µs ± 0% | 383µs ± 0% | 369µs ± 0% | 370µs ± 0% | 359µs ± 0%
|
[Geo mean] | 102µs | 103µs | 102µs | 103µs | 105µs
|
|
| alloc/op
|
---|
AvgAggregateInt/count=1000-8 | 704B ± 0% | 704B ± 0% | 704B ± 0% | 704B ± 0% | 704B ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 608B ± 0% | 608B ± 0% | 608B ± 0% | 608B ± 0% | 608B ± 0%
|
AvgAggregateFloat/count=1000-8 | 64.0B ± 0% | 64.0B ± 0% | 64.0B ± 0% | 64.0B ± 0% | 64.0B ± 0%
|
AvgAggregateDecimal/count=1000-8 | 76.2kB ± 0% | 79.9kB ± 0% | 78.7kB ± 0% | 79.7kB ± 0% | 77.9kB ± 0%
|
CountAggregate/count=1000-8 | 16.0B ± 0% | 16.0B ± 0% | 16.0B ± 0% | 16.0B ± 0% | 16.0B ± 0%
|
SumIntAggregateInt/count=1000-8 | 24.0B ± 0% | 24.0B ± 0% | 24.0B ± 0% | 24.0B ± 0% | 24.0B ± 0%
|
SumAggregateInt/count=1000-8 | 304B ± 0% | 304B ± 0% | 304B ± 0% | 304B ± 0% | 304B ± 0%
|
SumAggregateSmallInt/count=1000-8 | 208B ± 0% | 208B ± 0% | 208B ± 0% | 208B ± 0% | 208B ± 0%
|
SumAggregateFloat/count=1000-8 | 24.0B ± 0% | 24.0B ± 0% | 24.0B ± 0% | 24.0B ± 0% | 24.0B ± 0%
|
SumAggregateDecimal/count=1000-8 | 77.8kB ± 0% | 76.5kB ± 0% | 79.6kB ± 0% | 75.6kB ± 0% | 74.4kB ± 0%
|
MaxAggregateInt/count=1000-8 | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0%
|
MaxAggregateFloat/count=1000-8 | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0%
|
MaxAggregateDecimal/count=1000-8 | 21.4kB ± 0% | 21.7kB ± 0% | 14.4kB ± 0% | 20.0kB ± 0% | 40.0kB ± 0%
|
MinAggregateInt/count=1000-8 | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0%
|
MinAggregateFloat/count=1000-8 | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0% | 32.0B ± 0%
|
MinAggregateDecimal/count=1000-8 | 416B ± 0% | 416B ± 0% | 944B ± 0% | 224B ± 0% | 176B ± 0%
|
VarianceAggregateInt/count=1000-8 | 1.18MB ± 0% | 1.18MB ± 0% | 1.18MB ± 0% | 1.18MB ± 0% | 1.18MB ± 0%
|
VarianceAggregateFloat/count=1000-8 | 40.0B ± 0% | 40.0B ± 0% | 40.0B ± 0% | 40.0B ± 0% | 40.0B ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 1.18MB ± 0% | 1.18MB ± 0% | 1.18MB ± 0% | 1.18MB ± 0% | 1.18MB ± 0%
|
StdDevAggregateInt/count=1000-8 | 1.18MB ± 0% | 1.18MB ± 0% | 1.19MB ± 0% | 1.18MB ± 0% | 1.18MB ± 0%
|
StdDevAggregateFloat/count=1000-8 | 64.0B ± 0% | 64.0B ± 0% | 64.0B ± 0% | 64.0B ± 0% | 64.0B ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 1.18MB ± 0% | 1.18MB ± 0% | 1.18MB ± 0% | 1.19MB ± 0% | 1.18MB ± 0%
|
LikeWithCache-8 | 496B ± 0% | 496B ± 0% | 496B ± 0% | 496B ± 0% | 496B ± 0%
|
LikeWithoutCache-8 | 14.8kB ± 0% | 14.8kB ± 0% | 14.8kB ± 0% | 14.8kB ± 0% | 14.8kB ± 0%
|
ILikeWithCache-8 | 544B ± 0% | 544B ± 0% | 544B ± 0% | 544B ± 0% | 544B ± 0%
|
ILikeWithoutCache-8 | 15.6kB ± 0% | 15.6kB ± 0% | 15.6kB ± 0% | 15.6kB ± 0% | 15.6kB ± 0%
|
Parse-8 | 6.69kB ± 0% | 6.69kB ± 0% | 6.69kB ± 0% | 6.69kB ± 0% | 6.69kB ± 0%
|
EncodeSQLString/old_version-8 | 32.9kB ± 0% | 32.9kB ± 0% | 32.9kB ± 0% | 32.9kB ± 0% | 32.9kB ± 0%
|
EncodeSQLString/new_version-8 | 78.3kB ± 0% | 78.3kB ± 0% | 78.3kB ± 0% | 78.3kB ± 0% | 78.3kB ± 0%
|
[Geo mean] | 1.70kB | 1.70kB | 1.73kB | 1.66kB | 1.68kB
|
|
| allocs/op
|
---|
AvgAggregateInt/count=1000-8 | 14.0 ± 0% | 14.0 ± 0% | 14.0 ± 0% | 14.0 ± 0% | 14.0 ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 12.0 ± 0% | 12.0 ± 0% | 12.0 ± 0% | 12.0 ± 0% | 12.0 ± 0%
|
AvgAggregateFloat/count=1000-8 | 4.00 ± 0% | 4.00 ± 0% | 4.00 ± 0% | 4.00 ± 0% | 4.00 ± 0%
|
AvgAggregateDecimal/count=1000-8 | 1.90k ± 0% | 1.99k ± 0% | 1.96k ± 0% | 1.99k ± 0% | 1.94k ± 0%
|
CountAggregate/count=1000-8 | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0%
|
SumIntAggregateInt/count=1000-8 | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0%
|
SumAggregateInt/count=1000-8 | 5.00 ± 0% | 5.00 ± 0% | 5.00 ± 0% | 5.00 ± 0% | 5.00 ± 0%
|
SumAggregateSmallInt/count=1000-8 | 3.00 ± 0% | 3.00 ± 0% | 3.00 ± 0% | 3.00 ± 0% | 3.00 ± 0%
|
SumAggregateFloat/count=1000-8 | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0%
|
SumAggregateDecimal/count=1000-8 | 1.95k ± 0% | 1.91k ± 0% | 1.99k ± 0% | 1.89k ± 0% | 1.86k ± 0%
|
MaxAggregateInt/count=1000-8 | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0%
|
MaxAggregateFloat/count=1000-8 | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0%
|
MaxAggregateDecimal/count=1000-8 | 447 ± 0% | 452 ± 0% | 300 ± 0% | 418 ± 0% | 833 ± 0%
|
MinAggregateInt/count=1000-8 | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0%
|
MinAggregateFloat/count=1000-8 | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0% | 1.00 ± 0%
|
MinAggregateDecimal/count=1000-8 | 9.00 ± 0% | 9.00 ± 0% | 20.00 ± 0% | 5.00 ± 0% | 4.00 ± 0%
|
VarianceAggregateInt/count=1000-8 | 25.5k ± 0% | 25.6k ± 0% | 25.5k ± 0% | 25.5k ± 0% | 25.5k ± 0%
|
VarianceAggregateFloat/count=1000-8 | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 25.5k ± 0% | 25.6k ± 0% | 25.5k ± 0% | 25.6k ± 0% | 25.6k ± 0%
|
StdDevAggregateInt/count=1000-8 | 25.6k ± 0% | 25.6k ± 0% | 25.7k ± 0% | 25.6k ± 0% | 25.6k ± 0%
|
StdDevAggregateFloat/count=1000-8 | 4.00 ± 0% | 4.00 ± 0% | 4.00 ± 0% | 4.00 ± 0% | 4.00 ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 25.7k ± 0% | 25.6k ± 0% | 25.6k ± 0% | 25.7k ± 0% | 25.6k ± 0%
|
LikeWithCache-8 | 25.0 ± 0% | 25.0 ± 0% | 25.0 ± 0% | 25.0 ± 0% | 25.0 ± 0%
|
LikeWithoutCache-8 | 205 ± 0% | 205 ± 0% | 205 ± 0% | 205 ± 0% | 205 ± 0%
|
ILikeWithCache-8 | 37.0 ± 0% | 37.0 ± 0% | 37.0 ± 0% | 37.0 ± 0% | 37.0 ± 0%
|
ILikeWithoutCache-8 | 249 ± 0% | 249 ± 0% | 249 ± 0% | 249 ± 0% | 249 ± 0%
|
Parse-8 | 196 ± 0% | 196 ± 0% | 196 ± 0% | 196 ± 0% | 196 ± 0%
|
EncodeSQLString/old_version-8 | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0% | 2.00 ± 0%
|
EncodeSQLString/new_version-8 | 10.0 ± 0% | 10.0 ± 0% | 10.0 ± 0% | 10.0 ± 0% | 10.0 ± 0%
|
[Geo mean] | 35.3 | 35.3 | 35.8 | 34.5 | 35.0
|
|