| time/op
|
---|
AvgAggregateInt/count=1000-8 | 164µs ± 0% | 181µs ± 0% | 174µs ± 0% | 163µs ± 0% | 168µs ± 0%
|
AvgAggregateSmallInt/count=1000-8 | 59.9µs ± 0% | 57.8µs ± 0% | 58.8µs ± 0% | 57.4µs ± 0% | 61.0µs ± 0%
|
AvgAggregateFloat/count=1000-8 | 25.1µs ± 0% | 25.0µs ± 0% | 23.3µs ± 0% | 27.1µs ± 0% | 23.4µs ± 0%
|
AvgAggregateDecimal/count=1000-8 | 324µs ± 0% | 334µs ± 0% | 305µs ± 0% | 298µs ± 0% | 310µs ± 0%
|
CountAggregate/count=1000-8 | 17.2µs ± 0% | 16.4µs ± 0% | 17.8µs ± 0% | 19.4µs ± 0% | 17.3µs ± 0%
|
SumIntAggregateInt/count=1000-8 | 39.7µs ± 0% | 37.5µs ± 0% | 37.7µs ± 0% | 41.2µs ± 0% | 37.8µs ± 0%
|
SumAggregateInt/count=1000-8 | 142µs ± 0% | 166µs ± 0% | 148µs ± 0% | 149µs ± 0% | 147µs ± 0%
|
SumAggregateSmallInt/count=1000-8 | 47.3µs ± 0% | 48.3µs ± 0% | 45.2µs ± 0% | 47.6µs ± 0% | 49.5µs ± 0%
|
SumAggregateFloat/count=1000-8 | 18.0µs ± 0% | 18.3µs ± 0% | 20.1µs ± 0% | 19.2µs ± 0% | 19.3µs ± 0%
|
SumAggregateDecimal/count=1000-8 | 301µs ± 0% | 298µs ± 0% | 301µs ± 0% | 312µs ± 0% | 298µs ± 0%
|
MaxAggregateInt/count=1000-8 | 22.9µs ± 0% | 22.1µs ± 0% | 23.5µs ± 0% | 25.1µs ± 0% | 23.0µs ± 0%
|
MaxAggregateFloat/count=1000-8 | 23.7µs ± 0% | 22.9µs ± 0% | 22.2µs ± 0% | 22.7µs ± 0% | 23.8µs ± 0%
|
MaxAggregateDecimal/count=1000-8 | 174µs ± 0% | 123µs ± 0% | 124µs ± 0% | 199µs ± 0% | 124µs ± 0%
|
MinAggregateInt/count=1000-8 | 22.8µs ± 0% | 22.3µs ± 0% | 24.1µs ± 0% | 22.7µs ± 0% | 23.8µs ± 0%
|
MinAggregateFloat/count=1000-8 | 23.4µs ± 0% | 24.8µs ± 0% | 25.8µs ± 0% | 29.9µs ± 0% | 24.2µs ± 0%
|
MinAggregateDecimal/count=1000-8 | 100µs ± 0% | 95µs ± 0% | 109µs ± 0% | 111µs ± 0% | 88µs ± 0%
|
VarianceAggregateInt/count=1000-8 | 16.1ms ± 0% | 15.2ms ± 0% | 16.3ms ± 0% | 18.7ms ± 0% | 16.0ms ± 0%
|
VarianceAggregateFloat/count=1000-8 | 21.2µs ± 0% | 21.6µs ± 0% | 21.3µs ± 0% | 28.5µs ± 0% | 22.1µs ± 0%
|
VarianceAggregateDecimal/count=1000-8 | 16.2ms ± 0% | 15.1ms ± 0% | 15.0ms ± 0% | 14.6ms ± 0% | 16.3ms ± 0%
|
StdDevAggregateInt/count=1000-8 | 15.0ms ± 0% | 15.5ms ± 0% | 18.0ms ± 0% | 19.1ms ± 0% | 16.9ms ± 0%
|
StdDevAggregateFloat/count=1000-8 | 24.8µs ± 0% | 27.3µs ± 0% | 25.3µs ± 0% | 31.2µs ± 0% | 27.3µs ± 0%
|
StdDevAggregateDecimal/count=1000-8 | 16.6ms ± 0% | 16.3ms ± 0% | 17.3ms ± 0% | 15.9ms ± 0% | 16.8ms ± 0%
|
LikeWithCache-8 | 3.50µs ± 0% | 3.45µs ± 0% | 3.07µs ± 0% | 4.06µs ± 0% | 3.53µs ± 0%
|
LikeWithoutCache-8 | 36.2µs ± 0% | 37.6µs ± 0% | 36.9µs ± 0% | 35.6µs ± 0% | 37.6µs ± 0%
|
ILikeWithCache-8 | 4.13µs ± 0% | 4.05µs ± 0% | 4.40µs ± 0% | 4.18µs ± 0% | 4.18µs ± 0%
|
ILikeWithoutCache-8 | 42.6µs ± 0% | 37.6µs ± 0% | 42.0µs ± 0% | 43.4µs ± 0% | 39.5µs ± 0%
|
Parse-8 | 39.3µs ± 0% | 43.3µs ± 0% | 39.6µs ± 0% | 43.0µs ± 0% | 42.0µs ± 0%
|
EncodeSQLString/old_version-8 | 1.59ms ± 0% | 1.19ms ± 0% | 1.61ms ± 0% | 1.22ms ± 0% | 1.17ms ± 0%
|
EncodeSQLString/new_version-8 | 403µs ± 0% | 413µs ± 0% | 417µs ± 0% | 447µs ± 0% | 411µs ± 0%
|
[Geo mean] | 111µs | 109µs | 111µs | 117µs | 110µ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 | 80.1kB ± 0% | 78.2kB ± 0% | 79.9kB ± 0% | 78.1kB ± 0% | 79.9kB ± 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.6kB ± 0% | 79.2kB ± 0% | 77.9kB ± 0% | 77.8kB ± 0% | 78.4kB ± 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 | 27.0kB ± 0% | 15.0kB ± 0% | 13.9kB ± 0% | 22.8kB ± 0% | 14.7kB ± 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 | 704B ± 0% | 416B ± 0% | 704B ± 0% | 800B ± 0% | 1088B ± 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.68kB | 1.71kB | 1.74kB | 1.74kB
|
|
| 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 | 2.00k ± 0% | 1.95k ± 0% | 1.99k ± 0% | 1.95k ± 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.99k ± 0% | 1.98k ± 0% | 1.95k ± 0% | 1.94k ± 0% | 1.96k ± 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 | 563 ± 0% | 312 ± 0% | 289 ± 0% | 476 ± 0% | 307 ± 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 | 15.0 ± 0% | 9.0 ± 0% | 15.0 ± 0% | 17.0 ± 0% | 23.0 ± 0%
|
VarianceAggregateInt/count=1000-8 | 25.6k ± 0% | 25.6k ± 0% | 25.5k ± 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.5k ± 0% | 25.6k ± 0% | 25.5k ± 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.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] | 36.3 | 34.9 | 35.4 | 36.2 | 36.0
|
|