| time/op
|
---|
AvgAggregateInt/count=1000-8 | 170µs ± 0% | 173µs ± 0% | 173µs ± 0% | 174µs ± 0% | 165µs ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 59.8µs ± 0% | 58.5µs ± 0% | 58.2µs ± 0% | 58.6µs ± 0% | 57.1µs ± 0%
|
AvgAggregateFloat/count=1000-8 | 26.3µs ± 0% | 25.9µs ± 0% | 25.1µs ± 0% | 25.8µs ± 0% | 25.3µs ± 0%
|
AvgAggregateDecimal/count=1000-8 | 298µs ± 0% | 310µs ± 0% | 293µs ± 0% | 306µs ± 0% | 297µs ± 0%
|
CountAggregate/count=1000-8 | 20.9µs ± 0% | 20.8µs ± 0% | 20.4µs ± 0% | 20.6µs ± 0% | 20.4µs ± 0%
|
SumIntAggregateInt/count=1000-8 | 40.5µs ± 0% | 40.0µs ± 0% | 39.7µs ± 0% | 39.3µs ± 0% | 40.7µs ± 0%
|
SumAggregateInt/count=1000-8 | 154µs ± 0% | 157µs ± 0% | 152µs ± 0% | 151µs ± 0% | 156µs ± 0%
|
SumAggregateSmallInt/count=1000-8 | 47.1µs ± 0% | 48.2µs ± 0% | 47.2µs ± 0% | 47.2µs ± 0% | 47.3µs ± 0%
|
SumAggregateFloat/count=1000-8 | 21.5µs ± 0% | 22.1µs ± 0% | 22.0µs ± 0% | 22.0µs ± 0% | 21.7µs ± 0%
|
SumAggregateDecimal/count=1000-8 | 278µs ± 0% | 280µs ± 0% | 284µs ± 0% | 289µs ± 0% | 279µs ± 0%
|
MaxAggregateInt/count=1000-8 | 26.2µs ± 0% | 27.0µs ± 0% | 26.4µs ± 0% | 26.3µs ± 0% | 26.5µs ± 0%
|
MaxAggregateFloat/count=1000-8 | 25.8µs ± 0% | 26.3µs ± 0% | 26.0µs ± 0% | 25.7µs ± 0% | 26.0µs ± 0%
|
MaxAggregateDecimal/count=1000-8 | 113µs ± 0% | 112µs ± 0% | 112µs ± 0% | 116µs ± 0% | 115µs ± 0%
|
MinAggregateInt/count=1000-8 | 26.4µs ± 0% | 26.2µs ± 0% | 26.5µs ± 0% | 26.4µs ± 0% | 26.6µs ± 0%
|
MinAggregateFloat/count=1000-8 | 26.3µs ± 0% | 25.6µs ± 0% | 25.7µs ± 0% | 26.1µs ± 0% | 26.2µs ± 0%
|
MinAggregateDecimal/count=1000-8 | 87.2µs ± 0% | 90.4µs ± 0% | 87.0µs ± 0% | 90.3µs ± 0% | 99.3µs ± 0%
|
VarianceAggregateInt/count=1000-8 | 14.8ms ± 0% | 14.6ms ± 0% | 14.6ms ± 0% | 14.5ms ± 0% | 15.2ms ± 0%
|
VarianceAggregateFloat/count=1000-8 | 23.8µs ± 0% | 24.0µs ± 0% | 24.1µs ± 0% | 23.6µs ± 0% | 23.7µs ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 14.9ms ± 0% | 14.6ms ± 0% | 15.1ms ± 0% | 14.9ms ± 0% | 14.5ms ± 0%
|
StdDevAggregateInt/count=1000-8 | 14.8ms ± 0% | 14.8ms ± 0% | 15.0ms ± 0% | 14.8ms ± 0% | 14.5ms ± 0%
|
StdDevAggregateFloat/count=1000-8 | 26.9µs ± 0% | 27.4µs ± 0% | 27.1µs ± 0% | 27.2µs ± 0% | 27.9µs ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 14.6ms ± 0% | 14.8ms ± 0% | 14.6ms ± 0% | 14.9ms ± 0% | 14.8ms ± 0%
|
LikeWithCache-8 | 3.34µs ± 0% | 3.41µs ± 0% | 3.35µs ± 0% | 3.39µs ± 0% | 3.32µs ± 0%
|
LikeWithoutCache-8 | 33.1µs ± 0% | 33.3µs ± 0% | 33.7µs ± 0% | 34.5µs ± 0% | 33.5µs ± 0%
|
ILikeWithCache-8 | 4.16µs ± 0% | 3.98µs ± 0% | 4.04µs ± 0% | 4.15µs ± 0% | 4.24µs ± 0%
|
ILikeWithoutCache-8 | 37.4µs ± 0% | 37.7µs ± 0% | 38.3µs ± 0% | 38.7µs ± 0% | 38.0µs ± 0%
|
Parse-8 | 47.8µs ± 0% | 47.9µs ± 0% | 46.5µs ± 0% | 46.6µs ± 0% | 47.2µs ± 0%
|
EncodeSQLString/old_version-8 | 1.14ms ± 0% | 1.14ms ± 0% | 1.15ms ± 0% | 1.14ms ± 0% | 1.16ms ± 0%
|
EncodeSQLString/new_version-8 | 380µs ± 0% | 378µs ± 0% | 387µs ± 0% | 384µs ± 0% | 377µs ± 0%
|
[Geo mean] | 110µs | 110µs | 110µs | 110µs | 110µ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 | 79.4kB ± 0% | 80.3kB ± 0% | 79.1kB ± 0% | 80.2kB ± 0% | 79.8kB ± 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 | 79.5kB ± 0% | 78.1kB ± 0% | 78.8kB ± 0% | 79.5kB ± 0% | 79.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 | 14.1kB ± 0% | 14.5kB ± 0% | 14.6kB ± 0% | 14.7kB ± 0% | 14.6kB ± 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 | 176B ± 0% | 656B ± 0% | 368B ± 0% | 224B ± 0% | 1856B ± 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.18MB ± 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.18MB ± 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.63kB | 1.71kB | 1.67kB | 1.65kB | 1.77kB
|
|
| 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.98k ± 0% | 2.01k ± 0% | 1.98k ± 0% | 2.00k ± 0% | 1.99k ± 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.99k ± 0% | 1.95k ± 0% | 1.97k ± 0% | 1.99k ± 0% | 1.98k ± 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 | 294 ± 0% | 303 ± 0% | 304 ± 0% | 306 ± 0% | 304 ± 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 | 4.00 ± 0% | 14.00 ± 0% | 8.00 ± 0% | 5.00 ± 0% | 39.00 ± 0%
|
VarianceAggregateInt/count=1000-8 | 25.5k ± 0% | 25.6k ± 0% | 25.6k ± 0% | 25.5k ± 0% | 25.6k ± 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.6k ± 0% | 25.5k ± 0% | 25.6k ± 0% | 25.6k ± 0% | 25.6k ± 0%
|
StdDevAggregateInt/count=1000-8 | 25.6k ± 0% | 25.6k ± 0% | 25.6k ± 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.6k ± 0% | 25.6k ± 0% | 25.6k ± 0% | 25.6k ± 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] | 33.9 | 35.4 | 34.7 | 34.2 | 36.7
|
|