| time/op
|
---|
AvgAggregateInt/count=1000-8 | 166µs ± 0% | 175µs ± 0% | 165µs ± 0% | 166µs ± 0% | 176µs ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 56.1µs ± 0% | 56.7µs ± 0% | 57.2µs ± 0% | 58.0µs ± 0% | 56.6µs ± 0%
|
AvgAggregateFloat/count=1000-8 | 24.7µs ± 0% | 24.3µs ± 0% | 24.3µs ± 0% | 24.9µs ± 0% | 24.3µs ± 0%
|
AvgAggregateDecimal/count=1000-8 | 301µs ± 0% | 304µs ± 0% | 290µs ± 0% | 294µs ± 0% | 284µs ± 0%
|
CountAggregate/count=1000-8 | 18.3µs ± 0% | 18.1µs ± 0% | 18.3µs ± 0% | 18.3µs ± 0% | 18.3µs ± 0%
|
SumIntAggregateInt/count=1000-8 | 38.8µs ± 0% | 39.1µs ± 0% | 38.9µs ± 0% | 38.5µs ± 0% | 39.3µs ± 0%
|
SumAggregateInt/count=1000-8 | 151µs ± 0% | 151µs ± 0% | 150µs ± 0% | 149µs ± 0% | 162µs ± 0%
|
SumAggregateSmallInt/count=1000-8 | 48.3µs ± 0% | 47.4µs ± 0% | 46.7µs ± 0% | 45.3µs ± 0% | 46.0µs ± 0%
|
SumAggregateFloat/count=1000-8 | 18.7µs ± 0% | 19.5µs ± 0% | 19.2µs ± 0% | 19.1µs ± 0% | 20.2µs ± 0%
|
SumAggregateDecimal/count=1000-8 | 282µs ± 0% | 274µs ± 0% | 273µs ± 0% | 272µs ± 0% | 278µs ± 0%
|
MaxAggregateInt/count=1000-8 | 24.0µs ± 0% | 23.3µs ± 0% | 22.7µs ± 0% | 23.3µs ± 0% | 24.2µs ± 0%
|
MaxAggregateFloat/count=1000-8 | 23.2µs ± 0% | 24.0µs ± 0% | 23.6µs ± 0% | 23.4µs ± 0% | 23.2µs ± 0%
|
MaxAggregateDecimal/count=1000-8 | 118µs ± 0% | 103µs ± 0% | 112µs ± 0% | 125µs ± 0% | 119µs ± 0%
|
MinAggregateInt/count=1000-8 | 23.3µs ± 0% | 23.1µs ± 0% | 23.7µs ± 0% | 23.2µs ± 0% | 23.2µs ± 0%
|
MinAggregateFloat/count=1000-8 | 23.7µs ± 0% | 24.4µs ± 0% | 23.7µs ± 0% | 23.8µs ± 0% | 23.1µs ± 0%
|
MinAggregateDecimal/count=1000-8 | 88.7µs ± 0% | 94.8µs ± 0% | 89.0µs ± 0% | 95.1µs ± 0% | 94.4µs ± 0%
|
VarianceAggregateInt/count=1000-8 | 15.0ms ± 0% | 14.7ms ± 0% | 14.6ms ± 0% | 14.6ms ± 0% | 14.4ms ± 0%
|
VarianceAggregateFloat/count=1000-8 | 21.4µs ± 0% | 21.9µs ± 0% | 21.2µs ± 0% | 21.6µs ± 0% | 22.6µs ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 14.1ms ± 0% | 15.4ms ± 0% | 14.5ms ± 0% | 14.4ms ± 0% | 14.2ms ± 0%
|
StdDevAggregateInt/count=1000-8 | 15.0ms ± 0% | 15.2ms ± 0% | 15.2ms ± 0% | 14.7ms ± 0% | 14.0ms ± 0%
|
StdDevAggregateFloat/count=1000-8 | 26.2µs ± 0% | 26.0µs ± 0% | 25.8µs ± 0% | 26.1µs ± 0% | 25.6µs ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 14.7ms ± 0% | 14.4ms ± 0% | 15.5ms ± 0% | 15.0ms ± 0% | 14.4ms ± 0%
|
LikeWithCache-8 | 3.27µs ± 0% | 3.24µs ± 0% | 3.31µs ± 0% | 3.29µs ± 0% | 3.27µs ± 0%
|
LikeWithoutCache-8 | 34.0µs ± 0% | 34.7µs ± 0% | 34.5µs ± 0% | 32.8µs ± 0% | 33.6µs ± 0%
|
ILikeWithCache-8 | 4.06µs ± 0% | 4.06µs ± 0% | 4.04µs ± 0% | 4.04µs ± 0% | 4.11µs ± 0%
|
ILikeWithoutCache-8 | 39.0µs ± 0% | 38.0µs ± 0% | 38.1µs ± 0% | 38.1µs ± 0% | 37.9µs ± 0%
|
Parse-8 | 45.6µs ± 0% | 45.4µs ± 0% | 45.5µs ± 0% | 45.8µs ± 0% | 46.2µs ± 0%
|
EncodeSQLString/old_version-8 | 1.16ms ± 0% | 1.14ms ± 0% | 1.12ms ± 0% | 1.14ms ± 0% | 1.13ms ± 0%
|
EncodeSQLString/new_version-8 | 406µs ± 0% | 381µs ± 0% | 376µs ± 0% | 368µs ± 0% | 382µs ± 0%
|
[Geo mean] | 106µs | 106µs | 106µs | 106µs | 106µ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.7kB ± 0% | 77.9kB ± 0% | 79.3kB ± 0% | 78.0kB ± 0% | 79.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 | 77.6kB ± 0% | 79.3kB ± 0% | 79.6kB ± 0% | 79.6kB ± 0% | 77.2kB ± 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 | 16.7kB ± 0% | 12.2kB ± 0% | 15.2kB ± 0% | 17.6kB ± 0% | 16.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 | 128B ± 0% | 1280B ± 0% | 800B ± 0% | 1328B ± 0% | 1376B ± 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.62kB | 1.73kB | 1.72kB | 1.76kB | 1.76kB
|
|
| 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.99k ± 0% | 1.94k ± 0% | 1.98k ± 0% | 1.95k ± 0% | 1.97k ± 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.94k ± 0% | 1.98k ± 0% | 1.99k ± 0% | 1.99k ± 0% | 1.93k ± 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 | 349 ± 0% | 254 ± 0% | 316 ± 0% | 368 ± 0% | 350 ± 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 | 3.00 ± 0% | 27.00 ± 0% | 17.00 ± 0% | 28.00 ± 0% | 29.00 ± 0%
|
VarianceAggregateInt/count=1000-8 | 25.5k ± 0% | 25.6k ± 0% | 25.5k ± 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.6k ± 0% | 25.6k ± 0% | 25.5k ± 0% | 25.5k ± 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.7k ± 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] | 33.7 | 36.0 | 35.7 | 36.5 | 36.5
|
|