Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/o.summ.pg

Created December 1, 2021 01:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/d00dd199d975ee571a2b48834b000fea to your computer and use it in GitHub Desktop.
Save mdcallag/d00dd199d975ee571a2b48834b000fea to your computer and use it in GitHub Desktop.
Download ZIP
r.400mrows.300s.1u.prep0 - o.summ.pg
Raw
o.summ.pg
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000361 0.003 0.248 1.33 75046 x.pg124.x5.pk1
0.000343 0.003 0.31 1.219 83857 x.pg134.x5.pk1
0.000325 0.003 0.325 1.222 84459 x.pg140.x5.pk1
--- relative to first result
0.95 1.00 1.25 0.92 1.12 x.pg134.x5.pk1
0.90 1.00 1.31 0.92 1.13 x.pg140.x5.pk1
point-query.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.005798 1.368 11.09 0.002 2913 x.pg124.x5.pk1
0.006655 1.483 12.125 0.002 2592 x.pg134.x5.pk1
0.006282 1.499 12.27 0.003 2550 x.pg140.x5.pk1
--- relative to first result
1.15 1.08 1.09 1.00 0.89 x.pg134.x5.pk1
1.08 1.10 1.11 1.50 0.88 x.pg140.x5.pk1
random-points.pre.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.023921 14.129 116.102 0.013 480 x.pg124.x5.pk1
0.022683 14.144 116.453 0.009 492 x.pg134.x5.pk1
0.022466 14.117 116.204 0.01 483 x.pg140.x5.pk1
--- relative to first result
0.95 1.00 1.00 0.69 1.02 x.pg134.x5.pk1
0.94 1.00 1.00 0.77 1.01 x.pg140.x5.pk1
random-points.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.180020 141.132 1160.8 0.079 54 x.pg124.x5.pk1
0.176816 141.103 1160.43 0.086 55 x.pg134.x5.pk1
0.169799 140.902 1159.42 0.108 55 x.pg140.x5.pk1
--- relative to first result
0.98 1.00 1.00 1.09 1.02 x.pg134.x5.pk1
0.94 1.00 1.00 1.37 1.02 x.pg140.x5.pk1
random-points.pre.range1000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
1.780014 1409.58 11598.6 1.087 5 x.pg124.x5.pk1
1.759091 1408.96 11598.3 0.759 6 x.pg134.x5.pk1
1.655238 1411.1 11614.5 0.892 6 x.pg140.x5.pk1
--- relative to first result
0.99 1.00 1.00 0.70 1.20 x.pg134.x5.pk1
0.93 1.00 1.00 0.82 1.20 x.pg140.x5.pk1
read-only.pre.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.004084 1.296 11.131 0.002 3701 x.pg124.x5.pk1
0.004204 1.296 11.122 0.001 3626 x.pg134.x5.pk1
0.003954 1.307 11.214 0.002 3640 x.pg140.x5.pk1
--- relative to first result
1.03 1.00 1.00 0.50 0.98 x.pg134.x5.pk1
0.97 1.01 1.01 1.00 0.98 x.pg140.x5.pk1
read-only.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.008152 1.924 30.46 0.003 2128 x.pg124.x5.pk1
0.007877 1.922 30.407 0.002 2180 x.pg134.x5.pk1
0.007740 1.921 30.408 0.003 2121 x.pg140.x5.pk1
--- relative to first result
0.97 1.00 1.00 0.67 1.02 x.pg134.x5.pk1
0.95 1.00 1.00 1.00 1.00 x.pg140.x5.pk1
read-only.pre.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.100871 7.445 617.229 0.019 254 x.pg124.x5.pk1
0.101175 7.458 617.463 0.016 255 x.pg134.x5.pk1
0.098445 7.451 617.416 0.023 255 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 0.84 1.00 x.pg134.x5.pk1
0.98 1.00 1.00 1.21 1.00 x.pg140.x5.pk1
points-covered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.017836 3.095 30.996 0.003 1034 x.pg124.x5.pk1
0.017824 3.065 30.731 0.003 1042 x.pg134.x5.pk1
0.017547 3.064 30.744 0.003 1042 x.pg140.x5.pk1
--- relative to first result
1.00 0.99 0.99 1.00 1.01 x.pg134.x5.pk1
0.98 0.99 0.99 1.00 1.01 x.pg140.x5.pk1
points-notcovered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.153411 120.371 975.037 0.069 64 x.pg124.x5.pk1
0.149023 120.871 979.218 0.051 64 x.pg134.x5.pk1
0.149456 120.034 972.714 0.093 64 x.pg140.x5.pk1
--- relative to first result
0.97 1.00 1.00 0.74 1.00 x.pg134.x5.pk1
0.97 1.00 1.00 1.35 1.00 x.pg140.x5.pk1
points-covered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.018778 3.685 36.314 0.004 955 x.pg124.x5.pk1
0.017734 2.888 28.623 0.003 1061 x.pg134.x5.pk1
0.017632 2.901 28.83 0.003 1055 x.pg140.x5.pk1
--- relative to first result
0.94 0.78 0.79 0.75 1.11 x.pg134.x5.pk1
0.94 0.79 0.79 0.75 1.10 x.pg140.x5.pk1
points-notcovered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.157906 120.889 979.767 0.082 63 x.pg124.x5.pk1
0.138322 110.395 891.135 0.06 70 x.pg134.x5.pk1
0.141725 110.396 891.068 0.076 68 x.pg140.x5.pk1
--- relative to first result
0.88 0.91 0.91 0.73 1.11 x.pg134.x5.pk1
0.90 0.91 0.91 0.93 1.08 x.pg140.x5.pk1
range-covered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003985 0.557 6.76 0.001 4888 x.pg124.x5.pk1
0.003854 0.543 6.587 0.001 5081 x.pg134.x5.pk1
0.003729 0.546 6.626 0.001 5043 x.pg140.x5.pk1
--- relative to first result
0.97 0.97 0.97 1.00 1.04 x.pg134.x5.pk1
0.94 0.98 0.98 1.00 1.03 x.pg140.x5.pk1
range-notcovered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.012155 3.883 94.853 0.004 1433 x.pg124.x5.pk1
0.011369 3.911 95.353 0.003 1486 x.pg134.x5.pk1
0.011327 3.895 95.088 0.003 1457 x.pg140.x5.pk1
--- relative to first result
0.94 1.01 1.01 0.75 1.04 x.pg134.x5.pk1
0.93 1.00 1.00 0.75 1.02 x.pg140.x5.pk1
range-covered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.004693 0.615 7.457 0.001 4179 x.pg124.x5.pk1
0.004429 0.521 6.257 0.001 4602 x.pg134.x5.pk1
0.004195 0.519 6.241 0.001 4603 x.pg140.x5.pk1
--- relative to first result
0.94 0.85 0.84 1.00 1.10 x.pg134.x5.pk1
0.89 0.84 0.84 1.00 1.10 x.pg140.x5.pk1
range-notcovered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.119965 93.392 752.122 0.061 82 x.pg124.x5.pk1
0.121835 93.446 752.206 0.052 81 x.pg134.x5.pk1
0.115063 93.227 750.486 0.064 82 x.pg140.x5.pk1
--- relative to first result
1.02 1.00 1.00 0.85 0.99 x.pg134.x5.pk1
0.96 1.00 1.00 1.05 1.00 x.pg140.x5.pk1
update-inlist.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.100945 24.688 200.314 338.699 187 x.pg124.x5.pk1
0.098630 24.339 197.876 337.093 190 x.pg134.x5.pk1
0.079815 24.285 196.997 316.86 195 x.pg140.x5.pk1
--- relative to first result
0.98 0.99 0.99 1.00 1.02 x.pg134.x5.pk1
0.79 0.98 0.98 0.94 1.04 x.pg140.x5.pk1
update-index.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.016607 2.185 17.77 44.407 1302 x.pg124.x5.pk1
0.016407 2.138 17.422 43.551 1341 x.pg134.x5.pk1
0.015129 2.131 17.35 43.17 1307 x.pg140.x5.pk1
--- relative to first result
0.99 0.98 0.98 0.98 1.03 x.pg134.x5.pk1
0.91 0.98 0.98 0.97 1.00 x.pg140.x5.pk1
update-nonindex.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.016488 2.096 17.022 38.98 1301 x.pg124.x5.pk1
0.016945 2.051 16.682 39.432 1250 x.pg134.x5.pk1
0.015714 2.063 16.751 39.152 1211 x.pg140.x5.pk1
--- relative to first result
1.03 0.98 0.98 1.01 0.96 x.pg134.x5.pk1
0.95 0.98 0.98 1.00 0.93 x.pg140.x5.pk1
update-one.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003027 0 0 1.385 10561 x.pg124.x5.pk1
0.002982 0 0 1.267 10696 x.pg134.x5.pk1
0.002590 0 0 1.197 10693 x.pg140.x5.pk1
--- relative to first result
0.99 1 1 0.91 1.01 x.pg134.x5.pk1
0.86 1 1 0.86 1.01 x.pg140.x5.pk1
update-zipf.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011604 1.393 11.408 21.144 1854 x.pg124.x5.pk1
0.012681 1.379 11.321 21.432 1676 x.pg134.x5.pk1
0.011446 1.382 11.325 22.319 1660 x.pg140.x5.pk1
--- relative to first result
1.09 0.99 0.99 1.01 0.90 x.pg134.x5.pk1
0.99 0.99 0.99 1.06 0.90 x.pg140.x5.pk1
write-only.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.010010 1.089 8.834 21.325 2092 x.pg124.x5.pk1
0.010237 1.069 8.686 20.933 2053 x.pg134.x5.pk1
0.009129 1.067 8.644 20.239 2109 x.pg140.x5.pk1
--- relative to first result
1.02 0.98 0.98 0.98 0.98 x.pg134.x5.pk1
0.91 0.98 0.98 0.95 1.01 x.pg140.x5.pk1
read-write.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.010224 1.426 11.935 13.31 1750 x.pg124.x5.pk1
0.011337 1.419 11.89 13.658 1526 x.pg134.x5.pk1
0.009793 1.413 11.857 14.668 1612 x.pg140.x5.pk1
--- relative to first result
1.11 1.00 1.00 1.03 0.87 x.pg134.x5.pk1
0.96 0.99 0.99 1.10 0.92 x.pg140.x5.pk1
read-only.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.004256 1.308 11.168 0.002 3581 x.pg124.x5.pk1
0.004401 1.327 11.318 0.001 3495 x.pg134.x5.pk1
0.004103 1.311 11.185 0.002 3558 x.pg140.x5.pk1
--- relative to first result
1.03 1.01 1.01 0.50 0.98 x.pg134.x5.pk1
0.96 1.00 1.00 1.00 0.99 x.pg140.x5.pk1
read-only.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.007962 1.995 31.118 0.003 2115 x.pg124.x5.pk1
0.008299 2.001 31.21 0.002 2071 x.pg134.x5.pk1
0.007528 1.998 31.124 0.003 2117 x.pg140.x5.pk1
--- relative to first result
1.04 1.00 1.00 0.67 0.98 x.pg134.x5.pk1
0.95 1.00 1.00 1.00 1.00 x.pg140.x5.pk1
read-only.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.102743 7.867 624.014 0.02 247 x.pg124.x5.pk1
0.102360 7.875 625.297 0.018 246 x.pg134.x5.pk1
0.099634 7.865 624.395 0.022 247 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 0.90 1.00 x.pg134.x5.pk1
0.97 1.00 1.00 1.10 1.00 x.pg140.x5.pk1
point-query.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.006154 1.581 13.158 0.002 2657 x.pg124.x5.pk1
0.006294 1.579 13.126 0.002 2620 x.pg134.x5.pk1
0.006033 1.583 13.184 0.002 2578 x.pg140.x5.pk1
--- relative to first result
1.02 1.00 1.00 1.00 0.99 x.pg134.x5.pk1
0.98 1.00 1.00 1.00 0.97 x.pg140.x5.pk1
random-points.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.022551 14.248 117.564 0.01 494 x.pg124.x5.pk1
0.022753 14.262 117.648 0.009 490 x.pg134.x5.pk1
0.020665 14.265 117.682 0.011 500 x.pg140.x5.pk1
--- relative to first result
1.01 1.00 1.00 0.90 0.99 x.pg134.x5.pk1
0.92 1.00 1.00 1.10 1.01 x.pg140.x5.pk1
random-points.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.173658 141.241 1161.6 0.108 55 x.pg124.x5.pk1
0.174168 141.183 1161.43 0.07 55 x.pg134.x5.pk1
0.168235 141.173 1161.23 0.106 55 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 0.65 1.00 x.pg134.x5.pk1
0.97 1.00 1.00 0.98 1.00 x.pg140.x5.pk1
random-points.range1000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
1.680246 1412.29 11616.4 1.061 6 x.pg124.x5.pk1
1.692116 1412.03 11616.4 0.858 6 x.pg134.x5.pk1
1.537456 1412.26 11627.2 0.969 6 x.pg140.x5.pk1
--- relative to first result
1.01 1.00 1.00 0.81 1.00 x.pg134.x5.pk1
0.92 1.00 1.00 0.91 1.00 x.pg140.x5.pk1
hot-points.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.008429 0 0 0 2989 x.pg124.x5.pk1
0.008453 0 0 0 2990 x.pg134.x5.pk1
0.008542 0 0 0 2959 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1 1.00 x.pg134.x5.pk1
1.01 1 1 1 0.99 x.pg140.x5.pk1
points-covered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.016516 1.777 17.497 0.002 1220 x.pg124.x5.pk1
0.016615 1.79 17.592 0.002 1210 x.pg134.x5.pk1
0.016080 1.754 17.17 0.003 1235 x.pg140.x5.pk1
--- relative to first result
1.01 1.01 1.01 1.00 0.99 x.pg134.x5.pk1
0.97 0.99 0.98 1.50 1.01 x.pg140.x5.pk1
points-notcovered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.150646 120.49 975.98 0.081 64 x.pg124.x5.pk1
0.150759 120.159 972.872 0.057 64 x.pg134.x5.pk1
0.135548 120.756 978.446 0.085 66 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 0.70 1.00 x.pg134.x5.pk1
0.90 1.00 1.00 1.05 1.03 x.pg140.x5.pk1
points-covered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.018560 3.636 35.851 0.003 968 x.pg124.x5.pk1
0.017763 2.889 28.661 0.002 1060 x.pg134.x5.pk1
0.016966 2.802 27.774 0.003 1093 x.pg140.x5.pk1
--- relative to first result
0.96 0.79 0.80 0.67 1.10 x.pg134.x5.pk1
0.91 0.77 0.77 1.00 1.13 x.pg140.x5.pk1
points-notcovered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.151399 120.989 980.674 0.088 64 x.pg124.x5.pk1
0.140161 110.303 890.162 0.066 69 x.pg134.x5.pk1
0.133814 110.74 893.931 0.094 70 x.pg140.x5.pk1
--- relative to first result
0.93 0.91 0.91 0.75 1.08 x.pg134.x5.pk1
0.88 0.92 0.91 1.07 1.09 x.pg140.x5.pk1
range-covered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.004053 0.561 6.799 0.001 4846 x.pg124.x5.pk1
0.004067 0.56 6.797 0.001 4856 x.pg134.x5.pk1
0.003794 0.554 6.711 0.001 4929 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 1.00 1.00 x.pg134.x5.pk1
0.94 0.99 0.99 1.00 1.02 x.pg140.x5.pk1
range-notcovered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.013010 4.074 96.761 0.003 1327 x.pg124.x5.pk1
0.012468 4.085 96.758 0.002 1359 x.pg134.x5.pk1
0.012183 4.081 96.822 0.004 1333 x.pg140.x5.pk1
--- relative to first result
0.96 1.00 1.00 0.67 1.02 x.pg134.x5.pk1
0.94 1.00 1.00 1.33 1.00 x.pg140.x5.pk1
range-covered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.004632 0.615 7.458 0.001 4170 x.pg124.x5.pk1
0.004389 0.519 6.239 0.001 4602 x.pg134.x5.pk1
0.004315 0.529 6.36 0.001 4489 x.pg140.x5.pk1
--- relative to first result
0.95 0.84 0.84 1.00 1.10 x.pg134.x5.pk1
0.93 0.86 0.85 1.00 1.08 x.pg140.x5.pk1
range-notcovered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.121545 93.308 751.448 0.07 81 x.pg124.x5.pk1
0.120337 93.259 750.75 0.042 81 x.pg134.x5.pk1
0.109464 93.223 750.436 0.082 83 x.pg140.x5.pk1
--- relative to first result
0.99 1.00 1.00 0.60 1.00 x.pg134.x5.pk1
0.90 1.00 1.00 1.17 1.02 x.pg140.x5.pk1
scan.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000013 0.002 0.217 0 1943109 x.pg124.x5.pk1
0.000015 0.002 0.217 0 1630745 x.pg134.x5.pk1
0.000014 0.002 0.217 0 1803292 x.pg140.x5.pk1
--- relative to first result
1.15 1.00 1.00 1 0.84 x.pg134.x5.pk1
1.08 1.00 1.00 1 0.93 x.pg140.x5.pk1
delete.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.010966 1.661 13.517 10.395 2038 x.pg124.x5.pk1
0.011059 1.663 13.515 11.478 2037 x.pg134.x5.pk1
0.009123 1.657 13.482 9.829 2076 x.pg140.x5.pk1
--- relative to first result
1.01 1.00 1.00 1.10 1.00 x.pg134.x5.pk1
0.83 1.00 1.00 0.95 1.02 x.pg140.x5.pk1
insert.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.012966 1.442 20.288 25.923 1736 x.pg124.x5.pk1
0.013028 1.434 20.081 27.204 1733 x.pg134.x5.pk1
0.011692 1.446 19.982 25.312 1732 x.pg140.x5.pk1
--- relative to first result
1.00 0.99 0.99 1.05 1.00 x.pg134.x5.pk1
0.90 1.00 0.98 0.98 1.00 x.pg140.x5.pk1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment