| time/op
|
---|
AvgAggregateInt/count=1000-8 | 158µs ± 0% | 158µs ± 0% | 159µs ± 0% | 160µs ± 0% | 158µs ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 53.8µs ± 0% | 54.3µs ± 0% | 54.8µs ± 0% | 54.9µs ± 0% | 53.7µs ± 0%
|
AvgAggregateFloat/count=1000-8 | 24.3µs ± 0% | 24.1µs ± 0% | 23.7µs ± 0% | 24.3µs ± 0% | 24.1µs ± 0%
|
AvgAggregateDecimal/count=1000-8 | 277µs ± 0% | 283µs ± 0% | 283µs ± 0% | 276µs ± 0% | 284µs ± 0%
|
CountAggregate/count=1000-8 | 18.9µs ± 0% | 18.8µs ± 0% | 18.7µs ± 0% | 18.7µs ± 0% | 18.9µs ± 0%
|
SumIntAggregateInt/count=1000-8 | 37.6µs ± 0% | 38.5µs ± 0% | 37.4µs ± 0% | 37.2µs ± 0% | 37.4µs ± 0%
|
SumAggregateInt/count=1000-8 | 146µs ± 0% | 147µs ± 0% | 142µs ± 0% | 143µs ± 0% | 144µs ± 0%
|
SumAggregateSmallInt/count=1000-8 | 44.3µs ± 0% | 44.1µs ± 0% | 43.1µs ± 0% | 44.0µs ± 0% | 44.0µs ± 0%
|
SumAggregateFloat/count=1000-8 | 20.7µs ± 0% | 20.2µs ± 0% | 20.0µs ± 0% | 19.9µs ± 0% | 20.1µs ± 0%
|
SumAggregateDecimal/count=1000-8 | 269µs ± 0% | 263µs ± 0% | 274µs ± 0% | 264µs ± 0% | 272µs ± 0%
|
MaxAggregateInt/count=1000-8 | 23.4µs ± 0% | 23.3µs ± 0% | 23.5µs ± 0% | 23.4µs ± 0% | 23.3µs ± 0%
|
MaxAggregateFloat/count=1000-8 | 23.7µs ± 0% | 23.8µs ± 0% | 23.9µs ± 0% | 24.9µs ± 0% | 23.8µs ± 0%
|
MaxAggregateDecimal/count=1000-8 | 190µs ± 0% | 141µs ± 0% | 118µs ± 0% | 173µs ± 0% | 110µs ± 0%
|
MinAggregateInt/count=1000-8 | 23.3µs ± 0% | 23.4µs ± 0% | 23.4µs ± 0% | 23.9µs ± 0% | 23.7µs ± 0%
|
MinAggregateFloat/count=1000-8 | 23.9µs ± 0% | 23.8µs ± 0% | 23.8µs ± 0% | 23.9µs ± 0% | 23.9µs ± 0%
|
MinAggregateDecimal/count=1000-8 | 86.6µs ± 0% | 84.2µs ± 0% | 86.4µs ± 0% | 95.0µs ± 0% | 87.4µs ± 0%
|
VarianceAggregateInt/count=1000-8 | 13.9ms ± 0% | 13.9ms ± 0% | 13.7ms ± 0% | 13.9ms ± 0% | 14.0ms ± 0%
|
VarianceAggregateFloat/count=1000-8 | 21.6µs ± 0% | 21.9µs ± 0% | 21.4µs ± 0% | 21.6µs ± 0% | 21.7µs ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 13.8ms ± 0% | 13.9ms ± 0% | 14.1ms ± 0% | 14.0ms ± 0% | 13.8ms ± 0%
|
StdDevAggregateInt/count=1000-8 | 13.8ms ± 0% | 14.0ms ± 0% | 14.1ms ± 0% | 13.9ms ± 0% | 14.4ms ± 0%
|
StdDevAggregateFloat/count=1000-8 | 25.6µs ± 0% | 25.1µs ± 0% | 25.2µs ± 0% | 25.4µs ± 0% | 26.5µs ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 13.9ms ± 0% | 13.8ms ± 0% | 13.9ms ± 0% | 13.8ms ± 0% | 13.7ms ± 0%
|
LikeWithCache-8 | 3.09µs ± 0% | 3.11µs ± 0% | 3.15µs ± 0% | 3.10µs ± 0% | 3.11µs ± 0%
|
LikeWithoutCache-8 | 31.7µs ± 0% | 32.0µs ± 0% | 32.8µs ± 0% | 31.3µs ± 0% | 31.6µs ± 0%
|
ILikeWithCache-8 | 3.95µs ± 0% | 3.82µs ± 0% | 3.81µs ± 0% | 3.90µs ± 0% | 3.91µs ± 0%
|
ILikeWithoutCache-8 | 36.7µs ± 0% | 36.5µs ± 0% | 36.6µs ± 0% | 35.9µs ± 0% | 36.2µs ± 0%
|
Parse-8 | 36.3µs ± 0% | 35.7µs ± 0% | 36.2µs ± 0% | 36.1µs ± 0% | 35.4µs ± 0%
|
EncodeSQLString/old_version-8 | 1.08ms ± 0% | 1.09ms ± 0% | 1.08ms ± 0% | 1.09ms ± 0% | 1.09ms ± 0%
|
EncodeSQLString/new_version-8 | 372µs ± 0% | 370µs ± 0% | 362µs ± 0% | 362µs ± 0% | 380µs ± 0%
|
[Geo mean] | 104µs | 103µs | 102µs | 104µs | 102µ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 | 78.3kB ± 0% | 79.1kB ± 0% | 79.8kB ± 0% | 78.6kB ± 0% | 79.3kB ± 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.3kB ± 0% | 77.5kB ± 0% | 77.5kB ± 0% | 78.0kB ± 0% | 79.9kB ± 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 | 41.6kB ± 0% | 25.2kB ± 0% | 17.3kB ± 0% | 36.2kB ± 0% | 15.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 | 608B ± 0% | 752B ± 0% | 1040B ± 0% | 416B ± 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.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.76kB | 1.75kB | 1.74kB | 1.73kB | 1.63kB
|
|
| 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.96k ± 0% | 1.97k ± 0% | 1.99k ± 0% | 1.96k ± 0% | 1.98k ± 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.98k ± 0% | 1.94k ± 0% | 1.94k ± 0% | 1.95k ± 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 | 866 ± 0% | 525 ± 0% | 361 ± 0% | 754 ± 0% | 313 ± 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 | 13.0 ± 0% | 16.0 ± 0% | 22.0 ± 0% | 9.0 ± 0% | 4.0 ± 0%
|
VarianceAggregateInt/count=1000-8 | 25.6k ± 0% | 25.5k ± 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.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.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.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] | 36.6 | 36.2 | 36.2 | 36.0 | 34.0
|
|