Compare Query Plans

Comparing the query plans of two oltp benchmarks: A and B.

  • A benchmarked commit de06fca using the V3 query planner.
  • B benchmarked commit f085f12 using the V3 query planner.

Queries are ordered from the slowest to the fastest. The 50 slowest queries are shown.

select c from sbtest41 where id = :vtg1
select c from sbtest10 where id = :vtg1
select c from sbtest21 where id = :vtg1
select c from sbtest49 where id = :vtg1
select c from sbtest4 where id = :vtg1
select c from sbtest35 where id = :vtg1
select c from sbtest2 where id = :vtg1
select c from sbtest43 where id = :vtg1
select c from sbtest36 where id = :vtg1
select c from sbtest8 where id = :vtg1
select c from sbtest26 where id = :vtg1
select c from sbtest6 where id = :vtg1
select c from sbtest28 where id = :vtg1
select c from sbtest18 where id = :vtg1
select c from sbtest24 where id = :vtg1
select c from sbtest20 where id = :vtg1
select c from sbtest7 where id = :vtg1
select c from sbtest42 where id = :vtg1
select c from sbtest27 where id = :vtg1
select c from sbtest32 where id = :vtg1
select c from sbtest48 where id = :vtg1
select c from sbtest12 where id = :vtg1
select c from sbtest39 where id = :vtg1
select c from sbtest3 where id = :vtg1
select c from sbtest13 where id = :vtg1
select c from sbtest30 where id = :vtg1
select c from sbtest46 where id = :vtg1
select c from sbtest40 where id = :vtg1
select c from sbtest50 where id = :vtg1
select c from sbtest11 where id = :vtg1
select c from sbtest37 where id = :vtg1
select c from sbtest1 where id = :vtg1
select c from sbtest14 where id = :vtg1
select c from sbtest44 where id = :vtg1
select c from sbtest33 where id = :vtg1
select c from sbtest45 where id = :vtg1
select c from sbtest38 where id = :vtg1
select c from sbtest5 where id = :vtg1
select c from sbtest9 where id = :vtg1
select c from sbtest31 where id = :vtg1
select c from sbtest29 where id = :vtg1
select c from sbtest19 where id = :vtg1
select c from sbtest34 where id = :vtg1
select c from sbtest25 where id = :vtg1
select c from sbtest23 where id = :vtg1
select c from sbtest22 where id = :vtg1
select c from sbtest47 where id = :vtg1
select c from sbtest16 where id = :vtg1
select c from sbtest15 where id = :vtg1
select c from sbtest17 where id = :vtg1