Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/o.summ.pg

Created December 1, 2021 01:06
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/0d5e9c68388cefeb24713f6947a397cf to your computer and use it in GitHub Desktop.
Save mdcallag/0d5e9c68388cefeb24713f6947a397cf to your computer and use it in GitHub Desktop.
Download ZIP
r.10mrows.300s.1u.prep1 - 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.000326 0 0 0.881 84033 x.pg124.x5.pk1
0.000310 0 0 0.868 89285 x.pg134.x5.pk1
0.000295 0 0 0.848 88495 x.pg140.x5.pk1
--- relative to first result
0.95 1 1 0.99 1.06 x.pg134.x5.pk1
0.90 1 1 0.96 1.05 x.pg140.x5.pk1
point-query.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001131 0 0 0 24002 x.pg124.x5.pk1
0.001121 0 0 0 24117 x.pg134.x5.pk1
0.001120 0 0 0 23982 x.pg140.x5.pk1
--- relative to first result
0.99 1 1 1 1.00 x.pg134.x5.pk1
0.99 1 1 1 1.00 x.pg140.x5.pk1
random-points.pre.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002142 0 0 0 12209 x.pg124.x5.pk1
0.002166 0 0 0 11994 x.pg134.x5.pk1
0.002145 0 0 0 12102 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.98 x.pg134.x5.pk1
1.00 1 1 1 0.99 x.pg140.x5.pk1
random-points.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011037 0 0 0 2257 x.pg124.x5.pk1
0.011618 0 0 0 2139 x.pg134.x5.pk1
0.011336 0 0 0.001 2195 x.pg140.x5.pk1
--- relative to first result
1.05 1 1 1 0.95 x.pg134.x5.pk1
1.03 1 1 inf 0.97 x.pg140.x5.pk1
random-points.pre.range1000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.101287 0 0 0.002 256 x.pg124.x5.pk1
0.106962 0 0 0.003 243 x.pg134.x5.pk1
0.103953 0 0 0.007 248 x.pg140.x5.pk1
--- relative to first result
1.06 1 1 1.50 0.95 x.pg134.x5.pk1
1.03 1 1 3.50 0.97 x.pg140.x5.pk1
read-only.pre.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001340 0 0 0 19674 x.pg124.x5.pk1
0.001333 0 0 0 19800 x.pg134.x5.pk1
0.001333 0 0 0 19638 x.pg140.x5.pk1
--- relative to first result
0.99 1 1 1 1.01 x.pg134.x5.pk1
0.99 1 1 1 1.00 x.pg140.x5.pk1
read-only.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001860 0 0 0 14007 x.pg124.x5.pk1
0.001834 0 0 0 14149 x.pg134.x5.pk1
0.001805 0 0 0 14334 x.pg140.x5.pk1
--- relative to first result
0.99 1 1 1 1.01 x.pg134.x5.pk1
0.97 1 1 1 1.02 x.pg140.x5.pk1
read-only.pre.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.085142 0 0 0.002 318 x.pg124.x5.pk1
0.085146 0 0 0.002 318 x.pg134.x5.pk1
0.084470 0 0 0.002 319 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1.00 1.00 x.pg134.x5.pk1
0.99 1 1 1.00 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.008986 0 0 0 2599 x.pg124.x5.pk1
0.009234 0 0 0 2528 x.pg134.x5.pk1
0.009058 0 0 0 2554 x.pg140.x5.pk1
--- relative to first result
1.03 1 1 1 0.97 x.pg134.x5.pk1
1.01 1 1 1 0.98 x.pg140.x5.pk1
points-notcovered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011518 0 0 0 2172 x.pg124.x5.pk1
0.012237 0 0 0 2040 x.pg134.x5.pk1
0.011853 0 0 0 2093 x.pg140.x5.pk1
--- relative to first result
1.06 1 1 1 0.94 x.pg134.x5.pk1
1.03 1 1 1 0.96 x.pg140.x5.pk1
points-covered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.009021 0 0 0 2583 x.pg124.x5.pk1
0.009161 0 0 0 2536 x.pg134.x5.pk1
0.009258 0 0 0 2525 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1 0.98 x.pg134.x5.pk1
1.03 1 1 1 0.98 x.pg140.x5.pk1
points-notcovered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011411 0 0 0 2188 x.pg124.x5.pk1
0.011717 0 0 0 2128 x.pg134.x5.pk1
0.011658 0 0 0 2130 x.pg140.x5.pk1
--- relative to first result
1.03 1 1 1 0.97 x.pg134.x5.pk1
1.02 1 1 1 0.97 x.pg140.x5.pk1
range-covered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002544 0 0 0 10284 x.pg124.x5.pk1
0.002517 0 0 0 10380 x.pg134.x5.pk1
0.002481 0 0 0 10415 x.pg140.x5.pk1
--- relative to first result
0.99 1 1 1 1.01 x.pg134.x5.pk1
0.98 1 1 1 1.01 x.pg140.x5.pk1
range-notcovered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003410 0 0 0 7870 x.pg124.x5.pk1
0.003455 0 0 0 7753 x.pg134.x5.pk1
0.003425 0 0 0 7805 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.99 x.pg134.x5.pk1
1.00 1 1 1 0.99 x.pg140.x5.pk1
range-covered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002885 0 0 0 9014 x.pg124.x5.pk1
0.002875 0 0 0 9035 x.pg134.x5.pk1
0.002832 0 0 0 9073 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1 1.00 x.pg134.x5.pk1
0.98 1 1 1 1.01 x.pg140.x5.pk1
range-notcovered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.005878 0 0 0 4370 x.pg124.x5.pk1
0.006069 0 0 0 4249 x.pg134.x5.pk1
0.005914 0 0 0 4335 x.pg140.x5.pk1
--- relative to first result
1.03 1 1 1 0.97 x.pg134.x5.pk1
1.01 1 1 1 0.99 x.pg140.x5.pk1
update-inlist.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.005140 0 0 9.126 5698 x.pg124.x5.pk1
0.005234 0 0 10.371 5609 x.pg134.x5.pk1
0.004559 0 0 10.17 5747 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1.14 0.98 x.pg134.x5.pk1
0.89 1 1 1.11 1.01 x.pg140.x5.pk1
update-index.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002352 0 0 2.439 14086 x.pg124.x5.pk1
0.002415 0 0 2.391 13852 x.pg134.x5.pk1
0.002156 0 0 2.065 13802 x.pg140.x5.pk1
--- relative to first result
1.03 1 1 0.98 0.98 x.pg134.x5.pk1
0.92 1 1 0.85 0.98 x.pg140.x5.pk1
update-nonindex.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002155 0 0 1.257 15381 x.pg124.x5.pk1
0.002175 0 0 1.323 15180 x.pg134.x5.pk1
0.001856 0 0 1.286 15678 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1.05 0.99 x.pg134.x5.pk1
0.86 1 1 1.02 1.02 x.pg140.x5.pk1
update-one.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002145 0 0 0.824 15436 x.pg124.x5.pk1
0.002111 0 0 0.851 15785 x.pg134.x5.pk1
0.001817 0 0 0.749 15996 x.pg140.x5.pk1
--- relative to first result
0.98 1 1 1.03 1.02 x.pg134.x5.pk1
0.85 1 1 0.91 1.04 x.pg140.x5.pk1
update-zipf.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002130 0 0 1.556 15558 x.pg124.x5.pk1
0.002170 0 0 1.576 15217 x.pg134.x5.pk1
0.001870 0 0 1.545 15662 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1.01 0.98 x.pg134.x5.pk1
0.88 1 1 0.99 1.01 x.pg140.x5.pk1
write-only.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001389 0 0 1.124 22383 x.pg124.x5.pk1
0.001429 0 0 1.127 22190 x.pg134.x5.pk1
0.001334 0 0 1.077 22081 x.pg140.x5.pk1
--- relative to first result
1.03 1 1 1.00 0.99 x.pg134.x5.pk1
0.96 1 1 0.96 0.99 x.pg140.x5.pk1
read-write.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001643 0 0 1.075 19178 x.pg124.x5.pk1
0.001636 0 0 1.065 18980 x.pg134.x5.pk1
0.001515 0 0 1.025 18926 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 0.99 0.99 x.pg134.x5.pk1
0.92 1 1 0.95 0.99 x.pg140.x5.pk1
read-only.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001358 0 0 0 19321 x.pg124.x5.pk1
0.001344 0 0 0 19492 x.pg134.x5.pk1
0.001346 0 0 0 19312 x.pg140.x5.pk1
--- relative to first result
0.99 1 1 1 1.01 x.pg134.x5.pk1
0.99 1 1 1 1.00 x.pg140.x5.pk1
read-only.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002000 0 0 0 12850 x.pg124.x5.pk1
0.001981 0 0 0 12965 x.pg134.x5.pk1
0.001965 0 0 0 13020 x.pg140.x5.pk1
--- relative to first result
0.99 1 1 1 1.01 x.pg134.x5.pk1
0.98 1 1 1 1.01 x.pg140.x5.pk1
read-only.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.097641 0 0 0.002 273 x.pg124.x5.pk1
0.097658 0 0 0.006 274 x.pg134.x5.pk1
0.096473 0 0 0.003 276 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 3.00 1.00 x.pg134.x5.pk1
0.99 1 1 1.50 1.01 x.pg140.x5.pk1
point-query.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001111 0 0 0 24314 x.pg124.x5.pk1
0.001114 0 0 0 24233 x.pg134.x5.pk1
0.001123 0 0 0 23808 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.98 x.pg140.x5.pk1
random-points.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002173 0 0 0 12051 x.pg124.x5.pk1
0.002191 0 0 0 11888 x.pg134.x5.pk1
0.002170 0 0 0 11919 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.99 x.pg134.x5.pk1
1.00 1 1 1 0.99 x.pg140.x5.pk1
random-points.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011430 0 0 0 2191 x.pg124.x5.pk1
0.012148 0 0 0 2053 x.pg134.x5.pk1
0.011728 0 0 0 2118 x.pg140.x5.pk1
--- relative to first result
1.06 1 1 1 0.94 x.pg134.x5.pk1
1.03 1 1 1 0.97 x.pg140.x5.pk1
random-points.range1000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.105729 0 0 0.003 248 x.pg124.x5.pk1
0.111141 0 0 0.003 236 x.pg134.x5.pk1
0.107369 0 0 0.003 241 x.pg140.x5.pk1
--- relative to first result
1.05 1 1 1.00 0.95 x.pg134.x5.pk1
1.02 1 1 1.00 0.97 x.pg140.x5.pk1
hot-points.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.006305 0 0 0 4068 x.pg124.x5.pk1
0.006699 0 0 0 3826 x.pg134.x5.pk1
0.006542 0 0 0 3885 x.pg140.x5.pk1
--- relative to first result
1.06 1 1 1 0.94 x.pg134.x5.pk1
1.04 1 1 1 0.96 x.pg140.x5.pk1
points-covered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.009117 0 0 0 2551 x.pg124.x5.pk1
0.009323 0 0 0 2479 x.pg134.x5.pk1
0.009358 0 0 0 2518 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1 0.97 x.pg134.x5.pk1
1.03 1 1 1 0.99 x.pg140.x5.pk1
points-notcovered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.012283 0 0 0 2033 x.pg124.x5.pk1
0.012592 0 0 0.001 1987 x.pg134.x5.pk1
0.012103 0 0 0 2047 x.pg140.x5.pk1
--- relative to first result
1.03 1 1 inf 0.98 x.pg134.x5.pk1
0.99 1 1 1 1.01 x.pg140.x5.pk1
points-covered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.009446 0 0 0 2516 x.pg124.x5.pk1
0.009262 0 0 0 2474 x.pg134.x5.pk1
0.009336 0 0 0 2513 x.pg140.x5.pk1
--- relative to first result
0.98 1 1 1 0.98 x.pg134.x5.pk1
0.99 1 1 1 1.00 x.pg140.x5.pk1
points-notcovered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011757 0 0 0 2118 x.pg124.x5.pk1
0.012352 0 0 0.001 2006 x.pg134.x5.pk1
0.011771 0 0 0 2109 x.pg140.x5.pk1
--- relative to first result
1.05 1 1 inf 0.95 x.pg134.x5.pk1
1.00 1 1 1 1.00 x.pg140.x5.pk1
range-covered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002671 0 0 0 9686 x.pg124.x5.pk1
0.002680 0 0 0 9661 x.pg134.x5.pk1
0.002658 0 0 0 9713 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1 1.00 x.pg134.x5.pk1
1.00 1 1 1 1.00 x.pg140.x5.pk1
range-notcovered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003877 0 0 0 6823 x.pg124.x5.pk1
0.003919 0 0 0 6748 x.pg134.x5.pk1
0.003823 0 0 0 6892 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.99 x.pg134.x5.pk1
0.99 1 1 1 1.01 x.pg140.x5.pk1
range-covered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002911 0 0 0 8912 x.pg124.x5.pk1
0.002929 0 0 0 8841 x.pg134.x5.pk1
0.002861 0 0 0 8960 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.99 x.pg134.x5.pk1
0.98 1 1 1 1.01 x.pg140.x5.pk1
range-notcovered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.006040 0 0 0 4255 x.pg124.x5.pk1
0.006140 0 0 0 4179 x.pg134.x5.pk1
0.006022 0 0 0 4251 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1 0.98 x.pg134.x5.pk1
1.00 1 1 1 1.00 x.pg140.x5.pk1
scan.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000010 0 0 0 2238739 x.pg124.x5.pk1
0.000013 0 0 0 1847200 x.pg134.x5.pk1
0.000011 0 0 0 2124541 x.pg140.x5.pk1
--- relative to first result
1.30 1 1 1 0.83 x.pg134.x5.pk1
1.10 1 1 1 0.95 x.pg140.x5.pk1
delete.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001624 0 0 1.298 21234 x.pg124.x5.pk1
0.001657 0 0 1.315 20850 x.pg134.x5.pk1
0.001455 0 0 1.184 20947 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1.01 0.98 x.pg134.x5.pk1
0.90 1 1 0.91 0.99 x.pg140.x5.pk1
insert.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002446 0 0 1.562 13085 x.pg124.x5.pk1
0.002516 0 0 1.702 12863 x.pg134.x5.pk1
0.002274 0 0 1.535 12654 x.pg140.x5.pk1
--- relative to first result
1.03 1 1 1.09 0.98 x.pg134.x5.pk1
0.93 1 1 0.98 0.97 x.pg140.x5.pk1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment