| time/op
|
---|
AvgAggregateInt/count=1000-8 | 156µs ± 0% | 203µs ± 0% | 158µs ± 0% | 168µs ± 0% | 164µs ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 58.9µs ± 0% | 53.3µs ± 0% | 53.7µs ± 0% | 53.3µs ± 0% | 58.0µs ± 0%
|
AvgAggregateFloat/count=1000-8 | 24.7µs ± 0% | 24.5µs ± 0% | 22.9µs ± 0% | 22.5µs ± 0% | 24.1µs ± 0%
|
AvgAggregateDecimal/count=1000-8 | 287µs ± 0% | 280µs ± 0% | 287µs ± 0% | 286µs ± 0% | 289µs ± 0%
|
CountAggregate/count=1000-8 | 16.3µs ± 0% | 17.0µs ± 0% | 17.5µs ± 0% | 17.6µs ± 0% | 17.4µs ± 0%
|
SumIntAggregateInt/count=1000-8 | 38.0µs ± 0% | 44.9µs ± 0% | 36.7µs ± 0% | 37.0µs ± 0% | 39.9µs ± 0%
|
SumAggregateInt/count=1000-8 | 143µs ± 0% | 143µs ± 0% | 150µs ± 0% | 143µs ± 0% | 149µs ± 0%
|
SumAggregateSmallInt/count=1000-8 | 53.0µs ± 0% | 44.0µs ± 0% | 46.7µs ± 0% | 46.1µs ± 0% | 45.3µs ± 0%
|
SumAggregateFloat/count=1000-8 | 20.2µs ± 0% | 21.9µs ± 0% | 18.0µs ± 0% | 18.2µs ± 0% | 18.2µs ± 0%
|
SumAggregateDecimal/count=1000-8 | 306µs ± 0% | 267µs ± 0% | 263µs ± 0% | 261µs ± 0% | 270µs ± 0%
|
MaxAggregateInt/count=1000-8 | 22.7µs ± 0% | 22.4µs ± 0% | 22.3µs ± 0% | 22.1µs ± 0% | 21.9µs ± 0%
|
MaxAggregateFloat/count=1000-8 | 22.6µs ± 0% | 22.8µs ± 0% | 23.0µs ± 0% | 22.9µs ± 0% | 24.6µs ± 0%
|
MaxAggregateDecimal/count=1000-8 | 119µs ± 0% | 165µs ± 0% | 110µs ± 0% | 109µs ± 0% | 110µs ± 0%
|
MinAggregateInt/count=1000-8 | 26.7µs ± 0% | 22.3µs ± 0% | 21.9µs ± 0% | 23.0µs ± 0% | 22.4µs ± 0%
|
MinAggregateFloat/count=1000-8 | 22.2µs ± 0% | 28.5µs ± 0% | 23.7µs ± 0% | 22.5µs ± 0% | 23.6µs ± 0%
|
MinAggregateDecimal/count=1000-8 | 99.1µs ± 0% | 125.8µs ± 0% | 83.9µs ± 0% | 84.3µs ± 0% | 84.4µs ± 0%
|
VarianceAggregateInt/count=1000-8 | 14.2ms ± 0% | 14.0ms ± 0% | 13.6ms ± 0% | 14.0ms ± 0% | 14.1ms ± 0%
|
VarianceAggregateFloat/count=1000-8 | 20.2µs ± 0% | 25.2µs ± 0% | 19.4µs ± 0% | 19.6µs ± 0% | 20.3µs ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 14.2ms ± 0% | 14.5ms ± 0% | 14.9ms ± 0% | 13.6ms ± 0% | 14.6ms ± 0%
|
StdDevAggregateInt/count=1000-8 | 14.1ms ± 0% | 14.4ms ± 0% | 15.8ms ± 0% | 14.1ms ± 0% | 16.1ms ± 0%
|
StdDevAggregateFloat/count=1000-8 | 27.6µs ± 0% | 25.3µs ± 0% | 24.7µs ± 0% | 24.8µs ± 0% | 25.3µs ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 13.6ms ± 0% | 14.5ms ± 0% | 14.1ms ± 0% | 14.1ms ± 0% | 14.6ms ± 0%
|
LikeWithCache-8 | 3.58µs ± 0% | 2.95µs ± 0% | 3.02µs ± 0% | 3.05µs ± 0% | 3.12µs ± 0%
|
LikeWithoutCache-8 | 36.5µs ± 0% | 32.5µs ± 0% | 35.0µs ± 0% | 34.2µs ± 0% | 34.8µs ± 0%
|
ILikeWithCache-8 | 3.90µs ± 0% | 3.89µs ± 0% | 3.82µs ± 0% | 3.98µs ± 0% | 4.00µs ± 0%
|
ILikeWithoutCache-8 | 45.8µs ± 0% | 41.0µs ± 0% | 37.5µs ± 0% | 36.8µs ± 0% | 38.6µs ± 0%
|
Parse-8 | 36.8µs ± 0% | 38.0µs ± 0% | 36.7µs ± 0% | 36.0µs ± 0% | 37.7µs ± 0%
|
EncodeSQLString/old_version-8 | 1.12ms ± 0% | 1.07ms ± 0% | 1.17ms ± 0% | 1.09ms ± 0% | 1.11ms ± 0%
|
EncodeSQLString/new_version-8 | 375µs ± 0% | 385µs ± 0% | 356µs ± 0% | 395µs ± 0% | 374µs ± 0%
|
[Geo mean] | 106µs | 108µs | 101µs | 101µs | 103µ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.4kB ± 0% | 77.2kB ± 0% | 80.0kB ± 0% | 80.2kB ± 0% | 77.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 | 76.9kB ± 0% | 79.5kB ± 0% | 79.1kB ± 0% | 79.5kB ± 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 | 15.5kB ± 0% | 14.0kB ± 0% | 13.4kB ± 0% | 15.2kB ± 0% | 14.3kB ± 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 | 1.28kB ± 0% | 0.70kB ± 0% | 1.86kB ± 0% | 0.94kB ± 0% | 0.85kB ± 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.75kB | 1.71kB | 1.76kB | 1.73kB | 1.72kB
|
|
| 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.93k ± 0% | 2.00k ± 0% | 2.00k ± 0% | 1.94k ± 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.92k ± 0% | 1.99k ± 0% | 1.98k ± 0% | 1.99k ± 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 | 323 ± 0% | 293 ± 0% | 280 ± 0% | 316 ± 0% | 299 ± 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 | 27.0 ± 0% | 15.0 ± 0% | 39.0 ± 0% | 20.0 ± 0% | 18.0 ± 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.6k ± 0% | 25.5k ± 0%
|
StdDevAggregateInt/count=1000-8 | 25.6k ± 0% | 25.6k ± 0% | 25.6k ± 0% | 25.7k ± 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.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] | 36.3 | 35.4 | 36.6 | 35.9 | 35.7
|
|