| time/op
|
---|
AvgAggregateInt/count=1000-8 | 174µs ± 0% | 174µs ± 0% | 171µs ± 0% | 171µs ± 0% | 169µs ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 61.2µs ± 0% | 59.5µs ± 0% | 58.3µs ± 0% | 59.9µs ± 0% | 59.4µs ± 0%
|
AvgAggregateFloat/count=1000-8 | 25.0µs ± 0% | 24.8µs ± 0% | 24.5µs ± 0% | 23.9µs ± 0% | 24.2µs ± 0%
|
AvgAggregateDecimal/count=1000-8 | 309µs ± 0% | 304µs ± 0% | 292µs ± 0% | 289µs ± 0% | 286µs ± 0%
|
CountAggregate/count=1000-8 | 19.4µs ± 0% | 19.5µs ± 0% | 18.1µs ± 0% | 18.0µs ± 0% | 18.3µs ± 0%
|
SumIntAggregateInt/count=1000-8 | 42.0µs ± 0% | 42.4µs ± 0% | 40.0µs ± 0% | 39.5µs ± 0% | 40.4µs ± 0%
|
SumAggregateInt/count=1000-8 | 163µs ± 0% | 156µs ± 0% | 156µs ± 0% | 155µs ± 0% | 154µs ± 0%
|
SumAggregateSmallInt/count=1000-8 | 50.2µs ± 0% | 50.2µs ± 0% | 49.2µs ± 0% | 48.5µs ± 0% | 48.9µs ± 0%
|
SumAggregateFloat/count=1000-8 | 19.7µs ± 0% | 20.0µs ± 0% | 19.3µs ± 0% | 18.9µs ± 0% | 18.9µs ± 0%
|
SumAggregateDecimal/count=1000-8 | 283µs ± 0% | 288µs ± 0% | 277µs ± 0% | 287µs ± 0% | 283µs ± 0%
|
MaxAggregateInt/count=1000-8 | 23.8µs ± 0% | 24.3µs ± 0% | 23.3µs ± 0% | 23.8µs ± 0% | 24.4µs ± 0%
|
MaxAggregateFloat/count=1000-8 | 24.5µs ± 0% | 25.0µs ± 0% | 24.8µs ± 0% | 24.1µs ± 0% | 24.1µs ± 0%
|
MaxAggregateDecimal/count=1000-8 | 114µs ± 0% | 166µs ± 0% | 141µs ± 0% | 118µs ± 0% | 107µs ± 0%
|
MinAggregateInt/count=1000-8 | 23.8µs ± 0% | 24.4µs ± 0% | 23.2µs ± 0% | 23.3µs ± 0% | 23.8µs ± 0%
|
MinAggregateFloat/count=1000-8 | 27.6µs ± 0% | 24.2µs ± 0% | 23.5µs ± 0% | 23.7µs ± 0% | 24.6µs ± 0%
|
MinAggregateDecimal/count=1000-8 | 96.8µs ± 0% | 87.9µs ± 0% | 85.0µs ± 0% | 85.2µs ± 0% | 102.4µs ± 0%
|
VarianceAggregateInt/count=1000-8 | 14.9ms ± 0% | 14.7ms ± 0% | 14.6ms ± 0% | 14.5ms ± 0% | 14.2ms ± 0%
|
VarianceAggregateFloat/count=1000-8 | 22.1µs ± 0% | 21.9µs ± 0% | 21.1µs ± 0% | 21.3µs ± 0% | 21.7µs ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 14.8ms ± 0% | 14.7ms ± 0% | 14.9ms ± 0% | 14.9ms ± 0% | 14.9ms ± 0%
|
StdDevAggregateInt/count=1000-8 | 15.0ms ± 0% | 14.9ms ± 0% | 14.8ms ± 0% | 15.0ms ± 0% | 14.5ms ± 0%
|
StdDevAggregateFloat/count=1000-8 | 26.1µs ± 0% | 25.8µs ± 0% | 25.6µs ± 0% | 25.6µs ± 0% | 25.4µs ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 14.5ms ± 0% | 14.3ms ± 0% | 14.3ms ± 0% | 14.4ms ± 0% | 14.3ms ± 0%
|
LikeWithCache-8 | 3.27µs ± 0% | 3.20µs ± 0% | 3.37µs ± 0% | 3.24µs ± 0% | 3.28µs ± 0%
|
LikeWithoutCache-8 | 34.5µs ± 0% | 32.3µs ± 0% | 33.1µs ± 0% | 32.4µs ± 0% | 33.1µs ± 0%
|
ILikeWithCache-8 | 4.18µs ± 0% | 4.03µs ± 0% | 4.11µs ± 0% | 4.08µs ± 0% | 3.99µs ± 0%
|
ILikeWithoutCache-8 | 38.8µs ± 0% | 37.2µs ± 0% | 37.7µs ± 0% | 38.1µs ± 0% | 36.8µs ± 0%
|
Parse-8 | 52.6µs ± 0% | 48.1µs ± 0% | 52.1µs ± 0% | 52.0µs ± 0% | 50.0µs ± 0%
|
EncodeSQLString/old_version-8 | 1.18ms ± 0% | 1.14ms ± 0% | 1.12ms ± 0% | 1.15ms ± 0% | 1.16ms ± 0%
|
EncodeSQLString/new_version-8 | 387µs ± 0% | 384µs ± 0% | 380µs ± 0% | 385µs ± 0% | 378µs ± 0%
|
[Geo mean] | 110µs | 109µs | 107µs | 107µs | 107µ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.1kB ± 0% | 80.1kB ± 0% | 79.0kB ± 0% | 78.6kB ± 0% | 78.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 | 78.0kB ± 0% | 78.2kB ± 0% | 78.4kB ± 0% | 79.9kB ± 0% | 79.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.6kB ± 0% | 30.4kB ± 0% | 23.6kB ± 0% | 14.2kB ± 0% | 13.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 | 992B ± 0% | 512B ± 0% | 272B ± 0% | 32B ± 0% | 1040B ± 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.19MB ± 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.73kB | 1.74kB | 1.68kB | 1.54kB | 1.73kB
|
|
| 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.00k ± 0% | 1.97k ± 0% | 1.96k ± 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.95k ± 0% | 1.95k ± 0% | 1.96k ± 0% | 2.00k ± 0% | 1.97k ± 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 | 304 ± 0% | 634 ± 0% | 492 ± 0% | 297 ± 0% | 271 ± 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 | 21.0 ± 0% | 11.0 ± 0% | 6.0 ± 0% | 1.0 ± 0% | 22.0 ± 0%
|
VarianceAggregateInt/count=1000-8 | 25.5k ± 0% | 25.6k ± 0% | 25.6k ± 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.6k ± 0% | 25.6k ± 0% | 25.5k ± 0% | 25.5k ± 0% | 25.5k ± 0%
|
StdDevAggregateInt/count=1000-8 | 25.7k ± 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.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] | 35.9 | 36.0 | 35.0 | 32.3 | 35.8
|
|