Skip to content

Instantly share code, notes, and snippets.

@yuzefovich
Created January 24, 2023 04:34
Show Gist options
  • Save yuzefovich/669c295a8a4fdffa6490532284c5a719 to your computer and use it in GitHub Desktop.
Save yuzefovich/669c295a8a4fdffa6490532284c5a719 to your computer and use it in GitHub Desktop.
name old time/op new time/op delta
Count/InProcessTenantCockroach-24 19.9ms ± 3% 20.1ms ± 1% +1.50% (p=0.002 n=10+10)
Count/SepProcessTenantCockroach-24 34.1ms ± 4% 20.9ms ± 0% -38.62% (p=0.000 n=10+8)
CountTwoCF/InProcessTenantCockroach-24 39.0ms ± 2% 38.9ms ± 0% ~ (p=0.447 n=10+9)
CountTwoCF/SepProcessTenantCockroach-24 63.2ms ± 3% 39.7ms ± 0% -37.22% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=1/limit=0-24 320µs ± 2% 328µs ± 2% +2.53% (p=0.000 n=9+10)
Scan/InProcessTenantCockroach/count=1/limit=1-24 321µs ± 2% 333µs ± 2% +4.00% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=1/limit=10-24 322µs ± 2% 341µs ± 1% +6.00% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=1/limit=100-24 324µs ± 2% 337µs ± 1% +3.83% (p=0.000 n=10+9)
Scan/InProcessTenantCockroach/count=10/limit=0-24 333µs ± 2% 346µs ± 2% +3.77% (p=0.000 n=8+8)
Scan/InProcessTenantCockroach/count=10/limit=1-24 327µs ± 2% 339µs ± 1% +3.41% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=10/limit=10-24 335µs ± 2% 354µs ± 1% +5.39% (p=0.000 n=10+9)
Scan/InProcessTenantCockroach/count=10/limit=100-24 339µs ± 2% 355µs ± 2% +4.49% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=100/limit=0-24 388µs ± 2% 403µs ± 1% +3.80% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=100/limit=1-24 331µs ± 2% 346µs ± 1% +4.41% (p=0.000 n=9+10)
Scan/InProcessTenantCockroach/count=100/limit=10-24 344µs ± 3% 360µs ± 1% +4.68% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=100/limit=100-24 392µs ± 0% 412µs ± 2% +5.13% (p=0.000 n=7+10)
Scan/InProcessTenantCockroach/count=1000/limit=0-24 820µs ± 2% 849µs ± 0% +3.51% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=1000/limit=1-24 334µs ± 3% 347µs ± 2% +3.75% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=1000/limit=10-24 342µs ± 2% 361µs ± 3% +5.63% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=1000/limit=100-24 391µs ± 2% 417µs ± 3% +6.65% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=10000/limit=0-24 3.65ms ± 5% 4.26ms ± 1% +16.73% (p=0.000 n=9+9)
Scan/InProcessTenantCockroach/count=10000/limit=1-24 337µs ± 3% 349µs ± 3% +3.49% (p=0.001 n=10+10)
Scan/InProcessTenantCockroach/count=10000/limit=10-24 342µs ± 2% 359µs ± 2% +4.95% (p=0.000 n=10+9)
Scan/InProcessTenantCockroach/count=10000/limit=100-24 389µs ± 2% 418µs ± 2% +7.60% (p=0.000 n=9+10)
Scan/SepProcessTenantCockroach/count=1/limit=0-24 922µs ± 3% 926µs ± 3% ~ (p=0.529 n=10+10)
Scan/SepProcessTenantCockroach/count=1/limit=1-24 933µs ± 3% 943µs ± 2% ~ (p=0.218 n=10+10)
Scan/SepProcessTenantCockroach/count=1/limit=10-24 929µs ± 2% 957µs ± 4% +3.05% (p=0.000 n=10+10)
Scan/SepProcessTenantCockroach/count=1/limit=100-24 930µs ± 1% 938µs ± 1% +0.89% (p=0.024 n=9+9)
Scan/SepProcessTenantCockroach/count=10/limit=0-24 945µs ± 2% 958µs ± 2% ~ (p=0.136 n=9+9)
Scan/SepProcessTenantCockroach/count=10/limit=1-24 939µs ± 3% 949µs ± 3% ~ (p=0.280 n=10+10)
Scan/SepProcessTenantCockroach/count=10/limit=10-24 947µs ± 3% 982µs ± 2% +3.65% (p=0.000 n=10+10)
Scan/SepProcessTenantCockroach/count=10/limit=100-24 944µs ± 1% 984µs ± 3% +4.15% (p=0.000 n=9+9)
Scan/SepProcessTenantCockroach/count=100/limit=0-24 1.02ms ± 4% 1.04ms ± 3% ~ (p=0.105 n=10+10)
Scan/SepProcessTenantCockroach/count=100/limit=1-24 940µs ± 3% 958µs ± 2% +1.83% (p=0.023 n=10+10)
Scan/SepProcessTenantCockroach/count=100/limit=10-24 959µs ± 1% 990µs ± 2% +3.17% (p=0.000 n=10+10)
Scan/SepProcessTenantCockroach/count=100/limit=100-24 1.01ms ± 3% 1.05ms ± 2% +3.10% (p=0.000 n=9+10)
Scan/SepProcessTenantCockroach/count=1000/limit=0-24 1.61ms ± 2% 1.54ms ± 1% -4.11% (p=0.000 n=9+10)
Scan/SepProcessTenantCockroach/count=1000/limit=1-24 959µs ± 1% 974µs ± 3% +1.60% (p=0.043 n=9+10)
Scan/SepProcessTenantCockroach/count=1000/limit=10-24 953µs ± 3% 996µs ± 3% +4.49% (p=0.000 n=10+10)
Scan/SepProcessTenantCockroach/count=1000/limit=100-24 1.03ms ± 3% 1.07ms ± 1% +3.81% (p=0.000 n=10+9)
Scan/SepProcessTenantCockroach/count=10000/limit=0-24 5.19ms ± 2% 5.35ms ± 2% +3.15% (p=0.000 n=9+10)
Scan/SepProcessTenantCockroach/count=10000/limit=1-24 946µs ± 3% 967µs ± 2% +2.23% (p=0.005 n=10+10)
Scan/SepProcessTenantCockroach/count=10000/limit=10-24 959µs ± 2% 1005µs ± 3% +4.83% (p=0.000 n=9+10)
Scan/SepProcessTenantCockroach/count=10000/limit=100-24 1.04ms ± 4% 1.07ms ± 1% +3.13% (p=0.001 n=10+10)
ScanFilter/InProcessTenantCockroach/count1=25/count2=400/limit=1-24 2.13ms ± 9% 3.26ms ± 6% +52.92% (p=0.000 n=10+10)
ScanFilter/InProcessTenantCockroach/count1=25/count2=400/limit=10-24 402µs ± 2% 438µs ± 0% +8.93% (p=0.000 n=9+6)
ScanFilter/InProcessTenantCockroach/count1=25/count2=400/limit=50-24 1.46ms ± 2% 2.19ms ± 1% +49.98% (p=0.000 n=9+8)
ScanFilter/SepProcessTenantCockroach/count1=25/count2=400/limit=1-24 3.87ms ± 5% 4.41ms ± 6% +13.72% (p=0.000 n=10+10)
ScanFilter/SepProcessTenantCockroach/count1=25/count2=400/limit=10-24 1.07ms ± 3% 1.12ms ± 2% +4.94% (p=0.000 n=10+10)
ScanFilter/SepProcessTenantCockroach/count1=25/count2=400/limit=50-24 2.65ms ± 3% 3.09ms ± 4% +16.83% (p=0.000 n=9+10)
SkipScan/InProcessTenantCockroach/OnlyKey-24 704µs ± 2% 722µs ± 1% +2.52% (p=0.000 n=10+10)
SkipScan/InProcessTenantCockroach/OnlyValue-24 739µs ± 1% 778µs ± 1% +5.32% (p=0.000 n=10+9)
SkipScan/InProcessTenantCockroach/Both-24 810µs ± 1% 871µs ± 1% +7.56% (p=0.000 n=10+10)
SkipScan/SepProcessTenantCockroach/OnlyKey-24 1.53ms ± 1% 1.42ms ± 1% -7.15% (p=0.000 n=8+10)
SkipScan/SepProcessTenantCockroach/OnlyValue-24 1.57ms ± 1% 1.48ms ± 1% -6.21% (p=0.000 n=10+10)
SkipScan/SepProcessTenantCockroach/Both-24 1.64ms ± 2% 1.58ms ± 1% -3.51% (p=0.000 n=10+10)
WideTableIgnoreColumns/InProcessTenantCockroach-24 3.18ms ± 2% 3.15ms ± 1% -0.97% (p=0.006 n=9+10)
WideTableIgnoreColumns/SepProcessTenantCockroach-24 9.77ms ± 2% 4.79ms ± 1% -50.96% (p=0.000 n=10+10)
name old alloc/op new alloc/op delta
Count/InProcessTenantCockroach-24 4.47MB ± 1% 0.30MB ± 4% -93.28% (p=0.000 n=9+9)
Count/SepProcessTenantCockroach-24 21.6MB ± 1% 0.4MB ±17% -98.10% (p=0.000 n=10+10)
CountTwoCF/InProcessTenantCockroach-24 8.53MB ± 0% 0.16MB ±20% -98.17% (p=0.000 n=10+10)
CountTwoCF/SepProcessTenantCockroach-24 39.6MB ± 0% 0.3MB ±16% -99.36% (p=0.000 n=10+9)
Scan/InProcessTenantCockroach/count=1/limit=0-24 39.4kB ± 9% 45.2kB ±11% +14.86% (p=0.000 n=9+10)
Scan/InProcessTenantCockroach/count=1/limit=1-24 39.1kB ± 2% 44.8kB ± 3% +14.48% (p=0.000 n=8+9)
Scan/InProcessTenantCockroach/count=1/limit=10-24 40.9kB ±13% 44.7kB ± 1% +9.51% (p=0.003 n=10+8)
Scan/InProcessTenantCockroach/count=1/limit=100-24 40.7kB ± 1% 45.4kB ± 9% +11.55% (p=0.000 n=8+9)
Scan/InProcessTenantCockroach/count=10/limit=0-24 39.9kB ± 9% 45.7kB ± 1% +14.48% (p=0.000 n=8+8)
Scan/InProcessTenantCockroach/count=10/limit=1-24 40.5kB ± 7% 44.8kB ± 1% +10.86% (p=0.000 n=10+8)
Scan/InProcessTenantCockroach/count=10/limit=10-24 40.2kB ± 5% 46.7kB ± 1% +16.14% (p=0.000 n=9+8)
Scan/InProcessTenantCockroach/count=10/limit=100-24 42.6kB ± 7% 48.3kB ± 6% +13.17% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=100/limit=0-24 46.1kB ± 1% 53.7kB ± 0% +16.41% (p=0.000 n=8+8)
Scan/InProcessTenantCockroach/count=100/limit=1-24 40.4kB ±10% 45.7kB ±10% +13.22% (p=0.000 n=9+9)
Scan/InProcessTenantCockroach/count=100/limit=10-24 40.1kB ± 1% 47.1kB ± 3% +17.47% (p=0.000 n=8+8)
Scan/InProcessTenantCockroach/count=100/limit=100-24 47.7kB ± 9% 56.7kB ± 8% +18.81% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=1000/limit=0-24 104kB ± 3% 115kB ± 1% +10.14% (p=0.000 n=8+8)
Scan/InProcessTenantCockroach/count=1000/limit=1-24 39.4kB ± 4% 49.5kB ±18% +25.56% (p=0.000 n=8+10)
Scan/InProcessTenantCockroach/count=1000/limit=10-24 39.9kB ± 1% 46.8kB ± 1% +17.14% (p=0.000 n=8+8)
Scan/InProcessTenantCockroach/count=1000/limit=100-24 47.8kB ±19% 54.9kB ± 1% +14.86% (p=0.002 n=10+9)
Scan/InProcessTenantCockroach/count=10000/limit=0-24 854kB ± 8% 467kB ± 1% -45.33% (p=0.000 n=9+9)
Scan/InProcessTenantCockroach/count=10000/limit=1-24 39.0kB ± 5% 46.6kB ±17% +19.28% (p=0.000 n=8+9)
Scan/InProcessTenantCockroach/count=10000/limit=10-24 39.5kB ± 1% 46.4kB ± 1% +17.39% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=10000/limit=100-24 45.5kB ± 1% 54.3kB ± 0% +19.36% (p=0.000 n=8+8)
Scan/SepProcessTenantCockroach/count=1/limit=0-24 97.9kB ± 2% 107.0kB ± 9% +9.36% (p=0.000 n=8+9)
Scan/SepProcessTenantCockroach/count=1/limit=1-24 98.6kB ± 5% 104.1kB ± 1% +5.64% (p=0.000 n=9+8)
Scan/SepProcessTenantCockroach/count=1/limit=10-24 102kB ± 9% 108kB ±12% ~ (p=0.105 n=10+10)
Scan/SepProcessTenantCockroach/count=1/limit=100-24 103kB ±10% 108kB ± 9% +4.80% (p=0.023 n=10+10)
Scan/SepProcessTenantCockroach/count=10/limit=0-24 101kB ± 2% 110kB ± 7% +9.34% (p=0.000 n=8+9)
Scan/SepProcessTenantCockroach/count=10/limit=1-24 101kB ± 7% 108kB ± 7% +7.01% (p=0.029 n=10+10)
Scan/SepProcessTenantCockroach/count=10/limit=10-24 104kB ±10% 114kB ±18% +9.10% (p=0.029 n=10+10)
Scan/SepProcessTenantCockroach/count=10/limit=100-24 106kB ± 9% 113kB ± 7% +6.70% (p=0.019 n=10+10)
Scan/SepProcessTenantCockroach/count=100/limit=0-24 120kB ± 9% 125kB ± 8% +3.64% (p=0.014 n=9+9)
Scan/SepProcessTenantCockroach/count=100/limit=1-24 101kB ± 9% 107kB ±10% ~ (p=0.053 n=10+9)
Scan/SepProcessTenantCockroach/count=100/limit=10-24 100kB ± 1% 109kB ± 1% +9.03% (p=0.000 n=8+8)
Scan/SepProcessTenantCockroach/count=100/limit=100-24 122kB ± 8% 126kB ± 9% ~ (p=0.105 n=10+10)
Scan/SepProcessTenantCockroach/count=1000/limit=0-24 309kB ± 8% 213kB ± 1% -30.84% (p=0.000 n=9+8)
Scan/SepProcessTenantCockroach/count=1000/limit=1-24 106kB ±22% 111kB ±20% ~ (p=0.123 n=10+10)
Scan/SepProcessTenantCockroach/count=1000/limit=10-24 100kB ± 1% 112kB ±17% +11.87% (p=0.000 n=9+9)
Scan/SepProcessTenantCockroach/count=1000/limit=100-24 126kB ±24% 132kB ±23% ~ (p=0.052 n=10+10)
Scan/SepProcessTenantCockroach/count=10000/limit=0-24 2.49MB ± 8% 0.99MB ±19% -60.17% (p=0.000 n=10+9)
Scan/SepProcessTenantCockroach/count=10000/limit=1-24 98.7kB ± 2% 108.0kB ±12% +9.41% (p=0.000 n=9+9)
Scan/SepProcessTenantCockroach/count=10000/limit=10-24 100kB ± 1% 111kB ± 5% +10.83% (p=0.000 n=8+9)
Scan/SepProcessTenantCockroach/count=10000/limit=100-24 118kB ± 1% 126kB ±11% +7.01% (p=0.000 n=10+10)
ScanFilter/InProcessTenantCockroach/count1=25/count2=400/limit=1-24 630kB ± 6% 407kB ± 7% -35.46% (p=0.000 n=10+9)
ScanFilter/InProcessTenantCockroach/count1=25/count2=400/limit=10-24 56.5kB ±23% 66.4kB ±10% +17.65% (p=0.023 n=10+10)
ScanFilter/InProcessTenantCockroach/count1=25/count2=400/limit=50-24 351kB ±22% 523kB ± 3% +49.04% (p=0.000 n=9+9)
ScanFilter/SepProcessTenantCockroach/count1=25/count2=400/limit=1-24 2.29MB ± 4% 1.08MB ± 7% -52.82% (p=0.000 n=10+10)
ScanFilter/SepProcessTenantCockroach/count1=25/count2=400/limit=10-24 118kB ± 2% 140kB ± 4% +17.99% (p=0.000 n=9+8)
ScanFilter/SepProcessTenantCockroach/count1=25/count2=400/limit=50-24 1.20MB ± 2% 0.95MB ± 4% -20.59% (p=0.000 n=8+8)
SkipScan/InProcessTenantCockroach/OnlyKey-24 124kB ± 1% 104kB ± 9% -16.36% (p=0.000 n=8+10)
SkipScan/InProcessTenantCockroach/OnlyValue-24 124kB ± 1% 101kB ± 1% -18.25% (p=0.000 n=8+8)
SkipScan/InProcessTenantCockroach/Both-24 200kB ± 0% 214kB ± 0% +6.73% (p=0.000 n=9+9)
SkipScan/SepProcessTenantCockroach/OnlyKey-24 389kB ± 3% 211kB ± 1% -45.67% (p=0.000 n=9+8)
SkipScan/SepProcessTenantCockroach/OnlyValue-24 388kB ± 1% 211kB ± 1% -45.59% (p=0.000 n=9+9)
SkipScan/SepProcessTenantCockroach/Both-24 472kB ± 5% 357kB ± 3% -24.48% (p=0.000 n=10+9)
WideTableIgnoreColumns/InProcessTenantCockroach-24 2.21MB ± 0% 0.26MB ± 4% -88.10% (p=0.000 n=9+10)
WideTableIgnoreColumns/SepProcessTenantCockroach-24 8.81MB ± 1% 0.81MB ± 0% -90.84% (p=0.000 n=9+7)
name old allocs/op new allocs/op delta
Count/InProcessTenantCockroach-24 3.60k ± 6% 3.79k ± 1% +5.27% (p=0.006 n=9+8)
Count/SepProcessTenantCockroach-24 6.76k ± 9% 4.78k ±12% -29.36% (p=0.000 n=9+10)
CountTwoCF/InProcessTenantCockroach-24 815 ± 8% 916 ±16% +12.35% (p=0.000 n=9+10)
CountTwoCF/SepProcessTenantCockroach-24 2.02k ±17% 1.66k ± 3% -17.76% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=1/limit=0-24 323 ± 3% 373 ±10% +15.52% (p=0.000 n=8+9)
Scan/InProcessTenantCockroach/count=1/limit=1-24 318 ± 1% 369 ± 1% +16.16% (p=0.000 n=8+9)
Scan/InProcessTenantCockroach/count=1/limit=10-24 327 ±11% 369 ± 0% +12.81% (p=0.000 n=10+9)
Scan/InProcessTenantCockroach/count=1/limit=100-24 318 ± 0% 379 ± 8% +19.40% (p=0.000 n=8+10)
Scan/InProcessTenantCockroach/count=10/limit=0-24 350 ± 5% 411 ± 1% +17.70% (p=0.000 n=8+8)
Scan/InProcessTenantCockroach/count=10/limit=1-24 325 ± 1% 376 ± 1% +15.82% (p=0.000 n=8+9)
Scan/InProcessTenantCockroach/count=10/limit=10-24 336 ± 5% 416 ± 1% +23.81% (p=0.000 n=10+8)
Scan/InProcessTenantCockroach/count=10/limit=100-24 338 ± 9% 427 ± 6% +26.09% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=100/limit=0-24 471 ± 0% 570 ± 0% +21.03% (p=0.000 n=8+8)
Scan/InProcessTenantCockroach/count=100/limit=1-24 332 ± 5% 382 ± 7% +15.01% (p=0.000 n=9+9)
Scan/InProcessTenantCockroach/count=100/limit=10-24 336 ± 1% 429 ± 8% +27.79% (p=0.000 n=8+10)
Scan/InProcessTenantCockroach/count=100/limit=100-24 444 ± 7% 585 ± 6% +31.83% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=1000/limit=0-24 2.15k ± 0% 2.28k ± 0% +5.96% (p=0.000 n=9+8)
Scan/InProcessTenantCockroach/count=1000/limit=1-24 329 ± 5% 396 ±19% +20.23% (p=0.000 n=9+10)
Scan/InProcessTenantCockroach/count=1000/limit=10-24 334 ± 0% 419 ± 0% +25.37% (p=0.000 n=8+8)
Scan/InProcessTenantCockroach/count=1000/limit=100-24 447 ± 8% 577 ± 0% +29.00% (p=0.000 n=10+9)
Scan/InProcessTenantCockroach/count=10000/limit=0-24 20.4k ± 2% 20.4k ± 0% ~ (p=0.156 n=10+9)
Scan/InProcessTenantCockroach/count=10000/limit=1-24 327 ± 6% 377 ± 5% +15.27% (p=0.000 n=9+9)
Scan/InProcessTenantCockroach/count=10000/limit=10-24 332 ± 1% 418 ± 1% +25.84% (p=0.000 n=10+10)
Scan/InProcessTenantCockroach/count=10000/limit=100-24 434 ± 1% 574 ± 0% +32.32% (p=0.000 n=9+8)
Scan/SepProcessTenantCockroach/count=1/limit=0-24 1.02k ± 1% 1.10k ± 7% +7.52% (p=0.000 n=8+9)
Scan/SepProcessTenantCockroach/count=1/limit=1-24 1.01k ± 1% 1.07k ± 1% +5.52% (p=0.000 n=8+9)
Scan/SepProcessTenantCockroach/count=1/limit=10-24 1.04k ± 7% 1.09k ± 9% ~ (p=0.101 n=10+10)
Scan/SepProcessTenantCockroach/count=1/limit=100-24 1.01k ± 0% 1.09k ± 8% +7.23% (p=0.000 n=8+10)
Scan/SepProcessTenantCockroach/count=10/limit=0-24 1.06k ± 4% 1.13k ± 4% +6.92% (p=0.000 n=9+9)
Scan/SepProcessTenantCockroach/count=10/limit=1-24 1.04k ± 8% 1.11k ± 8% +5.83% (p=0.005 n=10+10)
Scan/SepProcessTenantCockroach/count=10/limit=10-24 1.04k ± 4% 1.14k ± 7% +9.14% (p=0.000 n=10+10)
Scan/SepProcessTenantCockroach/count=10/limit=100-24 1.06k ± 9% 1.14k ± 7% +7.60% (p=0.005 n=10+10)
Scan/SepProcessTenantCockroach/count=100/limit=0-24 1.19k ± 5% 1.30k ± 6% +10.05% (p=0.000 n=9+9)
Scan/SepProcessTenantCockroach/count=100/limit=1-24 1.05k ± 8% 1.09k ± 4% +4.05% (p=0.018 n=10+9)
Scan/SepProcessTenantCockroach/count=100/limit=10-24 1.04k ± 1% 1.13k ± 0% +8.88% (p=0.000 n=8+8)
Scan/SepProcessTenantCockroach/count=100/limit=100-24 1.17k ± 9% 1.31k ± 8% +11.99% (p=0.000 n=10+10)
Scan/SepProcessTenantCockroach/count=1000/limit=0-24 2.89k ± 6% 2.99k ± 0% +3.53% (p=0.005 n=9+8)
Scan/SepProcessTenantCockroach/count=1000/limit=1-24 1.03k ± 5% 1.11k ±12% +7.42% (p=0.008 n=9+10)
Scan/SepProcessTenantCockroach/count=1000/limit=10-24 1.04k ± 1% 1.12k ± 0% +8.43% (p=0.000 n=9+8)
Scan/SepProcessTenantCockroach/count=1000/limit=100-24 1.17k ± 9% 1.31k ± 7% +12.17% (p=0.000 n=10+9)
Scan/SepProcessTenantCockroach/count=10000/limit=0-24 21.4k ± 5% 21.4k ± 2% ~ (p=0.579 n=10+10)
Scan/SepProcessTenantCockroach/count=10000/limit=1-24 1.03k ± 2% 1.09k ± 2% +5.85% (p=0.000 n=9+8)
Scan/SepProcessTenantCockroach/count=10000/limit=10-24 1.04k ± 1% 1.15k ± 5% +10.68% (p=0.000 n=8+9)
Scan/SepProcessTenantCockroach/count=10000/limit=100-24 1.15k ± 1% 1.31k ± 4% +14.70% (p=0.000 n=10+10)
ScanFilter/InProcessTenantCockroach/count1=25/count2=400/limit=1-24 747 ±43% 1099 ±22% +47.16% (p=0.000 n=10+9)
ScanFilter/InProcessTenantCockroach/count1=25/count2=400/limit=10-24 484 ± 6% 677 ± 6% +39.91% (p=0.000 n=9+10)
ScanFilter/InProcessTenantCockroach/count1=25/count2=400/limit=50-24 888 ± 7% 2325 ± 1% +161.75% (p=0.000 n=9+8)
ScanFilter/SepProcessTenantCockroach/count1=25/count2=400/limit=1-24 1.83k ±24% 2.14k ±20% +17.07% (p=0.004 n=10+10)
ScanFilter/SepProcessTenantCockroach/count1=25/count2=400/limit=10-24 1.28k ± 2% 1.52k ± 3% +18.52% (p=0.000 n=9+10)
ScanFilter/SepProcessTenantCockroach/count1=25/count2=400/limit=50-24 1.81k ± 2% 3.32k ± 9% +83.21% (p=0.000 n=8+8)
SkipScan/InProcessTenantCockroach/OnlyKey-24 403 ± 3% 534 ± 3% +32.63% (p=0.000 n=8+8)
SkipScan/InProcessTenantCockroach/OnlyValue-24 401 ± 1% 530 ± 0% +32.02% (p=0.000 n=8+9)
SkipScan/InProcessTenantCockroach/Both-24 449 ± 0% 652 ± 1% +45.11% (p=0.000 n=9+9)
SkipScan/SepProcessTenantCockroach/OnlyKey-24 1.11k ± 1% 1.25k ± 1% +11.95% (p=0.000 n=8+8)
SkipScan/SepProcessTenantCockroach/OnlyValue-24 1.11k ± 0% 1.25k ± 0% +12.10% (p=0.000 n=9+9)
SkipScan/SepProcessTenantCockroach/Both-24 1.23k ±20% 1.37k ± 1% +11.28% (p=0.003 n=10+8)
WideTableIgnoreColumns/InProcessTenantCockroach-24 670 ± 2% 829 ± 3% +23.60% (p=0.000 n=9+9)
WideTableIgnoreColumns/SepProcessTenantCockroach-24 2.48k ± 1% 2.06k ± 0% -16.84% (p=0.000 n=10+8)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment