v3 vs Gen4

Comparing vtgate planner v3 and Gen4 for main

The GitHub issue used to track Gen4's progress can be found here.

OLTP

v3 Gen4 Improved by %
QPS Total 64,141.0 63,701.2 -0.7
QPS Reads 40,088.1 39,813.3 -0.7
QPS Writes 16,035.2 15,925.3 -0.7
QPS Other 8,017.6 7,962.7 -0.7
TPS 4,008.8 3,981.3 -0.7
Latency 38.6 38.6 0.0
Errors 0.0 0.0 0.0
Reconnects 0.0 0.0 0.0
Time 900 900 0
Threads 0.0 0.0 0.0
Total CPU time 48,099.75 48,227.70 -0.27
CPU time vtgate 25,371.30 25,276.20 0.37
CPU time vttablet 22,728.45 22,951.45 -0.98
Total Allocs bytes 6.2 TB 6.2 TB 0.11
Allocs bytes vtgate 3.0 TB 3.0 TB 0.17
Allocs bytes vttablet 3.2 TB 3.2 TB 0.07

TPCC

v3 Gen4 Improved by %
QPS Total 82,248.6 70,726.6 -16.3
QPS Reads 37,614.7 28,665.7 -31.2
QPS Writes 38,794.8 19,561.8 -98.3
QPS Other 5,839.2 22,499.0 74.0
TPS 2,919.4 6,358.0 54.1
Latency 240.0 84.5 64.8
Errors 12.7 4,891.3 -38,444.7
Reconnects 0.0 0.0 0.0
Time 900 900 0
Threads 0.0 0.0 0.0
Total CPU time 88,800.20 90,630.90 -2.06
CPU time vtgate 55,499.90 54,954.40 0.98
CPU time vttablet 33,300.30 35,676.50 -7.14
Total Allocs bytes 11 TB 11 TB -0.64
Allocs bytes vtgate 6.7 TB 6.6 TB 1.07
Allocs bytes vttablet 3.9 TB 4.0 TB -3.59