| time/op
|
---|
AvgAggregateInt/count=1000-8 | 165µs ± 0% | 165µs ± 0% | 171µs ± 0% | 169µs ± 0% | 169µs ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 55.8µs ± 0% | 55.5µs ± 0% | 58.1µs ± 0% | 57.0µs ± 0% | 56.9µs ± 0%
|
AvgAggregateFloat/count=1000-8 | 24.6µs ± 0% | 24.5µs ± 0% | 25.9µs ± 0% | 25.7µs ± 0% | 25.5µs ± 0%
|
AvgAggregateDecimal/count=1000-8 | 283µs ± 0% | 286µs ± 0% | 296µs ± 0% | 298µs ± 0% | 294µs ± 0%
|
CountAggregate/count=1000-8 | 19.8µs ± 0% | 19.8µs ± 0% | 20.3µs ± 0% | 20.2µs ± 0% | 20.2µs ± 0%
|
SumIntAggregateInt/count=1000-8 | 38.6µs ± 0% | 38.6µs ± 0% | 39.4µs ± 0% | 39.7µs ± 0% | 39.1µs ± 0%
|
SumAggregateInt/count=1000-8 | 151µs ± 0% | 149µs ± 0% | 151µs ± 0% | 154µs ± 0% | 157µs ± 0%
|
SumAggregateSmallInt/count=1000-8 | 45.2µs ± 0% | 45.5µs ± 0% | 47.0µs ± 0% | 46.7µs ± 0% | 46.4µs ± 0%
|
SumAggregateFloat/count=1000-8 | 20.8µs ± 0% | 21.1µs ± 0% | 21.5µs ± 0% | 21.8µs ± 0% | 21.4µs ± 0%
|
SumAggregateDecimal/count=1000-8 | 263µs ± 0% | 274µs ± 0% | 274µs ± 0% | 275µs ± 0% | 276µs ± 0%
|
MaxAggregateInt/count=1000-8 | 25.9µs ± 0% | 25.6µs ± 0% | 26.3µs ± 0% | 25.8µs ± 0% | 25.9µs ± 0%
|
MaxAggregateFloat/count=1000-8 | 24.6µs ± 0% | 25.2µs ± 0% | 26.5µs ± 0% | 26.0µs ± 0% | 26.5µs ± 0%
|
MaxAggregateDecimal/count=1000-8 | 107µs ± 0% | 107µs ± 0% | 116µs ± 0% | 116µs ± 0% | 113µs ± 0%
|
MinAggregateInt/count=1000-8 | 25.0µs ± 0% | 25.2µs ± 0% | 26.0µs ± 0% | 26.3µs ± 0% | 25.6µs ± 0%
|
MinAggregateFloat/count=1000-8 | 25.2µs ± 0% | 25.1µs ± 0% | 25.9µs ± 0% | 25.9µs ± 0% | 25.7µs ± 0%
|
MinAggregateDecimal/count=1000-8 | 98.2µs ± 0% | 87.7µs ± 0% | 98.2µs ± 0% | 101.9µs ± 0% | 87.6µs ± 0%
|
VarianceAggregateInt/count=1000-8 | 14.2ms ± 0% | 14.5ms ± 0% | 14.6ms ± 0% | 14.8ms ± 0% | 14.6ms ± 0%
|
VarianceAggregateFloat/count=1000-8 | 22.8µs ± 0% | 23.2µs ± 0% | 23.3µs ± 0% | 23.4µs ± 0% | 23.5µs ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 14.0ms ± 0% | 14.7ms ± 0% | 14.7ms ± 0% | 14.7ms ± 0% | 14.5ms ± 0%
|
StdDevAggregateInt/count=1000-8 | 14.3ms ± 0% | 14.2ms ± 0% | 14.5ms ± 0% | 14.8ms ± 0% | 14.6ms ± 0%
|
StdDevAggregateFloat/count=1000-8 | 25.8µs ± 0% | 26.3µs ± 0% | 26.8µs ± 0% | 26.8µs ± 0% | 26.5µs ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 14.0ms ± 0% | 14.2ms ± 0% | 14.3ms ± 0% | 14.4ms ± 0% | 14.6ms ± 0%
|
LikeWithCache-8 | 3.17µs ± 0% | 3.26µs ± 0% | 3.32µs ± 0% | 3.16µs ± 0% | 3.27µs ± 0%
|
LikeWithoutCache-8 | 32.7µs ± 0% | 32.6µs ± 0% | 33.8µs ± 0% | 33.4µs ± 0% | 33.0µs ± 0%
|
ILikeWithCache-8 | 3.97µs ± 0% | 3.99µs ± 0% | 4.09µs ± 0% | 3.98µs ± 0% | 4.25µs ± 0%
|
ILikeWithoutCache-8 | 36.6µs ± 0% | 36.7µs ± 0% | 37.6µs ± 0% | 36.4µs ± 0% | 37.8µs ± 0%
|
Parse-8 | 43.9µs ± 0% | 45.6µs ± 0% | 46.3µs ± 0% | 45.2µs ± 0% | 45.5µs ± 0%
|
EncodeSQLString/old_version-8 | 1.12ms ± 0% | 1.20ms ± 0% | 1.12ms ± 0% | 1.13ms ± 0% | 1.14ms ± 0%
|
EncodeSQLString/new_version-8 | 361µs ± 0% | 368µs ± 0% | 394µs ± 0% | 380µs ± 0% | 368µs ± 0%
|
[Geo mean] | 106µs | 106µs | 109µs | 109µs | 108µ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 | 77.5kB ± 0% | 79.7kB ± 0% | 79.1kB ± 0% | 79.8kB ± 0% | 80.1kB ± 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 | 75.2kB ± 0% | 78.9kB ± 0% | 78.3kB ± 0% | 78.3kB ± 0% | 80.0kB ± 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.0kB ± 0% | 12.9kB ± 0% | 14.3kB ± 0% | 15.0kB ± 0% | 13.8kB ± 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 | 320B ± 0% | 512B ± 0% | 416B ± 0% | 1424B ± 0% | 608B ± 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.19MB ± 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.66kB | 1.69kB | 1.68kB | 1.75kB | 1.70kB
|
|
| 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.93k ± 0% | 1.99k ± 0% | 1.97k ± 0% | 1.99k ± 0% | 2.00k ± 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.88k ± 0% | 1.97k ± 0% | 1.96k ± 0% | 1.96k ± 0% | 2.00k ± 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 | 291 ± 0% | 270 ± 0% | 299 ± 0% | 313 ± 0% | 288 ± 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 | 7.00 ± 0% | 11.00 ± 0% | 9.00 ± 0% | 30.00 ± 0% | 13.00 ± 0%
|
VarianceAggregateInt/count=1000-8 | 25.6k ± 0% | 25.6k ± 0% | 25.6k ± 0% | 25.6k ± 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.6k ± 0% | 25.6k ± 0% | 25.5k ± 0% | 25.5k ± 0% | 25.6k ± 0%
|
StdDevAggregateInt/count=1000-8 | 25.7k ± 0% | 25.6k ± 0% | 25.6k ± 0% | 25.6k ± 0% | 25.7k ± 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.7k ± 0% | 25.6k ± 0% | 25.7k ± 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] | 34.5 | 35.0 | 34.9 | 36.4 | 35.3
|
|