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

Click here to see the query plans comparison for this benchmark.

v3 Gen4 Improved by %
QPS Total 26,146.7 25,904.4 -0.9
QPS Reads 18,302.7 18,133.1 -0.9
QPS Writes 5,221.8 5,176.1 -0.9
QPS Other 2,622.2 2,595.2 -1.0
TPS 1,307.3 1,295.2 -0.9
Latency 44.2 44.2 0.0
Errors 0.0 0.0 0.0
Reconnects 0.0 0.0 0.0
Time 600 600 0
Threads 0.0 0.0 0.0
Total CPU time 12,502.00 12,459.80 0.34
CPU time vtgate 7,136.56 7,284.82 -2.08
CPU time vttablet 5,365.42 5,174.99 3.55
Total Allocs bytes 909 GB 900 GB 1.06
Allocs bytes vtgate 514 GB 511 GB 0.62
Allocs bytes vttablet 395 GB 388 GB 1.64

TPCC

Click here to see the query plans comparison for this benchmark.

v3 Gen4 Improved by %
QPS Total 3,228.8 3,189.2 -1.2
QPS Reads 1,473.9 1,456.2 -1.2
QPS Writes 1,527.5 1,507.3 -1.3
QPS Other 227.4 225.7 -0.7
TPS 113.7 112.8 -0.7
Latency 893.6 893.6 0.0
Errors 0.5 0.5 7.8
Reconnects 0.0 0.0 0.0
Time 600 601 0
Threads 0.0 0.0 0.0
Total CPU time 2,907.72 2,890.93 0.58
CPU time vtgate 1,666.58 1,660.83 0.35
CPU time vttablet 1,241.14 1,230.09 0.89
Total Allocs bytes 66 GB 66 GB 0.37
Allocs bytes vtgate 42 GB 42 GB 0.35
Allocs bytes vttablet 24 GB 24 GB 0.41