| time/op
|
---|
AvgAggregateInt/count=1000-8 | 164µs ± 0% | 180µs ± 0% | 190µs ± 0% | 176µs ± 0% | 163µs ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 59.6µs ± 0% | 60.8µs ± 0% | 61.3µs ± 0% | 59.4µs ± 0% | 56.5µs ± 0%
|
AvgAggregateFloat/count=1000-8 | 24.3µs ± 0% | 26.3µs ± 0% | 25.6µs ± 0% | 25.5µs ± 0% | 24.3µs ± 0%
|
AvgAggregateDecimal/count=1000-8 | 300µs ± 0% | 316µs ± 0% | 312µs ± 0% | 304µs ± 0% | 299µs ± 0%
|
CountAggregate/count=1000-8 | 18.0µs ± 0% | 19.3µs ± 0% | 19.2µs ± 0% | 17.9µs ± 0% | 18.1µs ± 0%
|
SumIntAggregateInt/count=1000-8 | 38.9µs ± 0% | 41.2µs ± 0% | 40.1µs ± 0% | 38.8µs ± 0% | 39.1µs ± 0%
|
SumAggregateInt/count=1000-8 | 152µs ± 0% | 161µs ± 0% | 157µs ± 0% | 147µs ± 0% | 154µs ± 0%
|
SumAggregateSmallInt/count=1000-8 | 47.6µs ± 0% | 52.8µs ± 0% | 50.3µs ± 0% | 45.6µs ± 0% | 48.4µs ± 0%
|
SumAggregateFloat/count=1000-8 | 19.0µs ± 0% | 20.3µs ± 0% | 20.9µs ± 0% | 19.6µs ± 0% | 19.6µs ± 0%
|
SumAggregateDecimal/count=1000-8 | 281µs ± 0% | 297µs ± 0% | 308µs ± 0% | 278µs ± 0% | 284µs ± 0%
|
MaxAggregateInt/count=1000-8 | 24.0µs ± 0% | 24.5µs ± 0% | 24.5µs ± 0% | 23.2µs ± 0% | 24.1µs ± 0%
|
MaxAggregateFloat/count=1000-8 | 24.2µs ± 0% | 25.0µs ± 0% | 25.3µs ± 0% | 24.1µs ± 0% | 24.4µs ± 0%
|
MaxAggregateDecimal/count=1000-8 | 126µs ± 0% | 120µs ± 0% | 127µs ± 0% | 114µs ± 0% | 120µs ± 0%
|
MinAggregateInt/count=1000-8 | 23.7µs ± 0% | 24.6µs ± 0% | 25.0µs ± 0% | 23.2µs ± 0% | 24.2µs ± 0%
|
MinAggregateFloat/count=1000-8 | 24.5µs ± 0% | 24.9µs ± 0% | 24.8µs ± 0% | 23.7µs ± 0% | 23.3µs ± 0%
|
MinAggregateDecimal/count=1000-8 | 92.0µs ± 0% | 103.7µs ± 0% | 90.6µs ± 0% | 93.0µs ± 0% | 96.9µs ± 0%
|
VarianceAggregateInt/count=1000-8 | 15.0ms ± 0% | 16.4ms ± 0% | 16.1ms ± 0% | 14.6ms ± 0% | 15.2ms ± 0%
|
VarianceAggregateFloat/count=1000-8 | 20.8µs ± 0% | 22.1µs ± 0% | 22.3µs ± 0% | 20.9µs ± 0% | 20.6µs ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 14.4ms ± 0% | 16.0ms ± 0% | 15.9ms ± 0% | 14.9ms ± 0% | 14.6ms ± 0%
|
StdDevAggregateInt/count=1000-8 | 14.6ms ± 0% | 16.8ms ± 0% | 15.2ms ± 0% | 15.0ms ± 0% | 14.9ms ± 0%
|
StdDevAggregateFloat/count=1000-8 | 24.8µs ± 0% | 27.4µs ± 0% | 25.1µs ± 0% | 25.9µs ± 0% | 25.1µs ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 14.7ms ± 0% | 15.8ms ± 0% | 15.8ms ± 0% | 15.1ms ± 0% | 14.8ms ± 0%
|
LikeWithCache-8 | 3.24µs ± 0% | 3.55µs ± 0% | 3.25µs ± 0% | 3.22µs ± 0% | 3.18µs ± 0%
|
LikeWithoutCache-8 | 38.2µs ± 0% | 38.3µs ± 0% | 36.1µs ± 0% | 35.1µs ± 0% | 37.4µs ± 0%
|
ILikeWithCache-8 | 4.30µs ± 0% | 4.34µs ± 0% | 4.17µs ± 0% | 4.12µs ± 0% | 4.33µs ± 0%
|
ILikeWithoutCache-8 | 41.7µs ± 0% | 43.0µs ± 0% | 40.4µs ± 0% | 40.8µs ± 0% | 41.6µs ± 0%
|
Parse-8 | 42.9µs ± 0% | 42.2µs ± 0% | 39.7µs ± 0% | 38.7µs ± 0% | 41.1µs ± 0%
|
EncodeSQLString/old_version-8 | 1.19ms ± 0% | 1.21ms ± 0% | 1.22ms ± 0% | 1.14ms ± 0% | 1.19ms ± 0%
|
EncodeSQLString/new_version-8 | 433µs ± 0% | 423µs ± 0% | 407µs ± 0% | 418µs ± 0% | 437µs ± 0%
|
[Geo mean] | 108µs | 114µs | 111µs | 107µ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 | 79.1kB ± 0% | 79.1kB ± 0% | 78.9kB ± 0% | 79.1kB ± 0% | 79.5kB ± 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.3kB ± 0% | 78.6kB ± 0% | 77.7kB ± 0% | 74.0kB ± 0% | 78.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 | 15.2kB ± 0% | 13.9kB ± 0% | 15.2kB ± 0% | 14.5kB ± 0% | 15.1kB ± 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% | 560B ± 0% | 176B ± 0% | 464B ± 0% | 272B ± 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.70kB | 1.69kB | 1.63kB | 1.68kB | 1.66kB
|
|
| 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% | 1.98k ± 0% | 1.97k ± 0% | 1.98k ± 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.96k ± 0% | 1.96k ± 0% | 1.94k ± 0% | 1.85k ± 0% | 1.95k ± 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 | 316 ± 0% | 290 ± 0% | 316 ± 0% | 302 ± 0% | 315 ± 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% | 12.0 ± 0% | 4.0 ± 0% | 10.0 ± 0% | 6.0 ± 0%
|
VarianceAggregateInt/count=1000-8 | 25.5k ± 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.6k ± 0% | 25.6k ± 0% | 25.5k ± 0% | 25.6k ± 0%
|
StdDevAggregateInt/count=1000-8 | 25.6k ± 0% | 25.7k ± 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.7k ± 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.4 | 35.2 | 33.9 | 34.9 | 34.4
|
|