Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/o.summ.pg

Created December 6, 2021 19:20
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/3d215619e09e773cd98be321ecd57850 to your computer and use it in GitHub Desktop.
Save mdcallag/3d215619e09e773cd98be321ecd57850 to your computer and use it in GitHub Desktop.
Download ZIP
400m rows, 1800 secs
Raw
o.summ.pg
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000362 0.003 0.248 1.33 74892 x.pg124.x5.pk1
0.000343 0.003 0.311 1.22 84139 x.pg134.x5.pk1
0.000326 0.003 0.322 1.223 84370 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.30 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.005538 1.413 11.592 0 2988 x.pg124.x5.pk1
0.005686 1.41 11.573 0 2946 x.pg134.x5.pk1
0.004816 1.411 11.595 0 3147 x.pg140.x5.pk1
--- relative to first result
1.03 1.00 1.00 1 0.99 x.pg134.x5.pk1
0.87 1.00 1.00 1 1.05 x.pg140.x5.pk1
random-points.pre.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.024319 14.113 116.029 0.002 477 x.pg124.x5.pk1
0.024423 14.106 116.045 0.002 476 x.pg134.x5.pk1
0.021939 14.112 116.099 0.004 488 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 1.00 1.00 x.pg134.x5.pk1
0.90 1.00 1.00 2.00 1.02 x.pg140.x5.pk1
random-points.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.181488 141.099 1159.73 0.013 54 x.pg124.x5.pk1
0.180703 141.059 1160.2 0.016 54 x.pg134.x5.pk1
0.169301 141.059 1160.59 0.032 55 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 1.23 1.00 x.pg134.x5.pk1
0.93 1.00 1.00 2.46 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.732804 1409.68 11588.3 0.133 6 x.pg124.x5.pk1
1.741029 1411.28 11612.4 0.154 6 x.pg134.x5.pk1
1.650240 1409.48 11601.3 0.318 6 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 1.16 1.00 x.pg134.x5.pk1
0.95 1.00 1.00 2.39 1.00 x.pg140.x5.pk1
read-only.pre.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.004001 1.304 11.192 0 3773 x.pg124.x5.pk1
0.004281 1.303 11.192 0.001 3600 x.pg134.x5.pk1
0.003561 1.303 11.2 0 3929 x.pg140.x5.pk1
--- relative to first result
1.07 1.00 1.00 inf 0.95 x.pg134.x5.pk1
0.89 1.00 1.00 1 1.04 x.pg140.x5.pk1
read-only.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.008411 1.951 30.782 0 2090 x.pg124.x5.pk1
0.008696 1.95 30.752 0.001 2043 x.pg134.x5.pk1
0.007720 1.95 30.778 0 2132 x.pg140.x5.pk1
--- relative to first result
1.03 1.00 1.00 inf 0.98 x.pg134.x5.pk1
0.92 1.00 1.00 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.100747 7.335 612.859 0.004 257 x.pg124.x5.pk1
0.100870 7.344 613.377 0.003 257 x.pg134.x5.pk1
0.097693 7.342 613.189 0.003 258 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 0.75 1.00 x.pg134.x5.pk1
0.97 1.00 1.00 0.75 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.014817 0.352 3.525 0.001 1535 x.pg124.x5.pk1
0.015017 0.358 3.575 0 1513 x.pg134.x5.pk1
0.014887 0.356 3.573 0.001 1516 x.pg140.x5.pk1
--- relative to first result
1.01 1.02 1.01 0.00 0.99 x.pg134.x5.pk1
1.00 1.01 1.01 1.00 0.99 x.pg140.x5.pk1
points-notcovered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.168497 137.096 1124.13 0.029 57 x.pg124.x5.pk1
0.171836 137.137 1123.92 0.014 56 x.pg134.x5.pk1
0.158481 137.198 1126.06 0.014 57 x.pg140.x5.pk1
--- relative to first result
1.02 1.00 1.00 0.48 0.98 x.pg134.x5.pk1
0.94 1.00 1.00 0.48 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.015138 0.399 3.94 0.001 1489 x.pg124.x5.pk1
0.015279 0.349 3.463 0 1485 x.pg134.x5.pk1
0.015157 0.348 3.458 0.001 1487 x.pg140.x5.pk1
--- relative to first result
1.01 0.87 0.88 0.00 1.00 x.pg134.x5.pk1
1.00 0.87 0.88 1.00 1.00 x.pg140.x5.pk1
points-notcovered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.169536 137.194 1125.32 0.012 57 x.pg124.x5.pk1
0.167128 130.078 1065.69 0.016 59 x.pg134.x5.pk1
0.150327 130.182 1067.72 0.012 61 x.pg140.x5.pk1
--- relative to first result
0.99 0.95 0.95 1.33 1.04 x.pg134.x5.pk1
0.89 0.95 0.95 1.00 1.07 x.pg140.x5.pk1
range-covered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002963 0.064 0.779 0 8585 x.pg124.x5.pk1
0.002915 0.063 0.769 0 8692 x.pg134.x5.pk1
0.002901 0.065 0.796 0 8403 x.pg140.x5.pk1
--- relative to first result
0.98 0.98 0.99 1 1.01 x.pg134.x5.pk1
0.98 1.02 1.02 1 0.98 x.pg140.x5.pk1
range-notcovered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.012906 4.083 94.595 0.001 1355 x.pg124.x5.pk1
0.013270 4.084 94.642 0.001 1338 x.pg134.x5.pk1
0.012193 4.083 94.596 0.001 1363 x.pg140.x5.pk1
--- relative to first result
1.03 1.00 1.00 1.00 0.99 x.pg134.x5.pk1
0.94 1.00 1.00 1.00 1.01 x.pg140.x5.pk1
range-covered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003610 0.08 0.971 0 6897 x.pg124.x5.pk1
0.003659 0.07 0.84 0 6805 x.pg134.x5.pk1
0.003549 0.07 0.847 0 6748 x.pg140.x5.pk1
--- relative to first result
1.01 0.88 0.87 1 0.99 x.pg134.x5.pk1
0.98 0.88 0.87 1 0.98 x.pg140.x5.pk1
range-notcovered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.119543 90.743 732.024 0.009 83 x.pg124.x5.pk1
0.120528 90.73 731.644 0.011 83 x.pg134.x5.pk1
0.113402 90.8 732.21 0.008 84 x.pg140.x5.pk1
--- relative to first result
1.01 1.00 1.00 1.22 1.00 x.pg134.x5.pk1
0.95 1.00 1.00 0.89 1.01 x.pg140.x5.pk1
update-inlist.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.113363 21.523 174.356 378.231 179 x.pg124.x5.pk1
0.114080 21.231 172.212 382.164 176 x.pg134.x5.pk1
0.098576 21.28 172.414 374.32 169 x.pg140.x5.pk1
--- relative to first result
1.01 0.99 0.99 1.01 0.98 x.pg134.x5.pk1
0.87 0.99 0.99 0.99 0.94 x.pg140.x5.pk1
update-index.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.016735 2.184 17.726 42.234 1290 x.pg124.x5.pk1
0.017152 2.142 17.414 41.955 1253 x.pg134.x5.pk1
0.015673 2.142 17.393 41.658 1233 x.pg140.x5.pk1
--- relative to first result
1.02 0.98 0.98 0.99 0.97 x.pg134.x5.pk1
0.94 0.98 0.98 0.99 0.96 x.pg140.x5.pk1
update-nonindex.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.015293 1.821 14.701 28.607 1453 x.pg124.x5.pk1
0.015246 1.811 14.632 28.578 1465 x.pg134.x5.pk1
0.014624 1.82 14.691 28.817 1421 x.pg140.x5.pk1
--- relative to first result
1.00 0.99 1.00 1.00 1.01 x.pg134.x5.pk1
0.96 1.00 1.00 1.01 0.98 x.pg140.x5.pk1
update-one.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002963 0 0 0.381 10740 x.pg124.x5.pk1
0.003019 0 0 0.382 10643 x.pg134.x5.pk1
0.002556 0 0 0.45 10773 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1.00 0.99 x.pg134.x5.pk1
0.86 1 1 1.18 1.00 x.pg140.x5.pk1
update-zipf.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.010113 0.995 8.059 17.33 2249 x.pg124.x5.pk1
0.010087 0.99 8.024 17.361 2254 x.pg134.x5.pk1
0.009660 0.998 8.085 17.308 2183 x.pg140.x5.pk1
--- relative to first result
1.00 0.99 1.00 1.00 1.00 x.pg134.x5.pk1
0.96 1.00 1.00 1.00 0.97 x.pg140.x5.pk1
write-only.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011080 1.048 8.486 18.81 2035 x.pg124.x5.pk1
0.010908 1.034 8.394 18.713 2079 x.pg134.x5.pk1
0.010668 1.037 8.399 18.655 2030 x.pg140.x5.pk1
--- relative to first result
0.98 0.99 0.99 0.99 1.02 x.pg134.x5.pk1
0.96 0.99 0.99 0.99 1.00 x.pg140.x5.pk1
read-write.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011834 1.438 11.981 15.586 1746 x.pg124.x5.pk1
0.011691 1.436 11.967 15.559 1778 x.pg134.x5.pk1
0.010922 1.435 11.958 15.476 1806 x.pg140.x5.pk1
--- relative to first result
0.99 1.00 1.00 1.00 1.02 x.pg134.x5.pk1
0.92 1.00 1.00 0.99 1.03 x.pg140.x5.pk1
read-write.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.014312 2.156 29.754 21.789 1406 x.pg124.x5.pk1
0.014258 2.155 29.737 21.763 1400 x.pg134.x5.pk1
0.013168 2.15 29.665 21.376 1437 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 1.00 1.00 x.pg134.x5.pk1
0.92 1.00 1.00 0.98 1.02 x.pg140.x5.pk1
read-only.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.004434 1.376 11.794 0 3455 x.pg124.x5.pk1
0.004334 1.376 11.792 0 3512 x.pg134.x5.pk1
0.003754 1.375 11.784 0 3707 x.pg140.x5.pk1
--- relative to first result
0.98 1.00 1.00 1 1.02 x.pg134.x5.pk1
0.85 1.00 1.00 1 1.07 x.pg140.x5.pk1
read-only.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.008519 2.215 33.235 0 1963 x.pg124.x5.pk1
0.008717 2.215 33.218 0 1939 x.pg134.x5.pk1
0.008007 2.21 33.18 0 1967 x.pg140.x5.pk1
--- relative to first result
1.02 1.00 1.00 1 0.99 x.pg134.x5.pk1
0.94 1.00 1.00 1 1.00 x.pg140.x5.pk1
read-only.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.104373 8.93 637.734 0.003 236 x.pg124.x5.pk1
0.104454 8.949 639.645 0.003 236 x.pg134.x5.pk1
0.101209 8.878 638.999 0.003 236 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 1.00 1.00 x.pg134.x5.pk1
0.97 0.99 1.00 1.00 1.00 x.pg140.x5.pk1
point-query.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.005680 1.45 11.966 0 2897 x.pg124.x5.pk1
0.005342 1.448 11.947 0 3035 x.pg134.x5.pk1
0.005150 1.45 11.964 0 2954 x.pg140.x5.pk1
--- relative to first result
0.94 1.00 1.00 1 1.05 x.pg134.x5.pk1
0.91 1.00 1.00 1 1.02 x.pg140.x5.pk1
random-points.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.022635 14.131 116.216 0.001 492 x.pg124.x5.pk1
0.022653 14.127 116.206 0.002 494 x.pg134.x5.pk1
0.021012 14.122 116.088 0.001 496 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 2.00 1.00 x.pg134.x5.pk1
0.93 1.00 1.00 1.00 1.01 x.pg140.x5.pk1
random-points.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.173937 141.201 1160.93 0.014 55 x.pg124.x5.pk1
0.175643 141.289 1161.5 0.014 55 x.pg134.x5.pk1
0.167896 141.308 1161.56 0.013 55 x.pg140.x5.pk1
--- relative to first result
1.01 1.00 1.00 1.00 1.00 x.pg134.x5.pk1
0.97 1.00 1.00 0.93 1.00 x.pg140.x5.pk1
random-points.range1000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
1.706659 1413.58 11628 0.133 6 x.pg124.x5.pk1
1.702811 1411.44 11608.9 0.14 6 x.pg134.x5.pk1
1.622828 1412.22 11617.6 0.264 6 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 1.05 1.00 x.pg134.x5.pk1
0.95 1.00 1.00 1.98 1.00 x.pg140.x5.pk1
hot-points.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.008373 0 0 0 3019 x.pg124.x5.pk1
0.008717 0 0 0 2901 x.pg134.x5.pk1
0.008487 0 0 0 2970 x.pg140.x5.pk1
--- relative to first result
1.04 1 1 1 0.96 x.pg134.x5.pk1
1.01 1 1 1 0.98 x.pg140.x5.pk1
points-covered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.014809 0.236 2.324 0 1551 x.pg124.x5.pk1
0.014991 0.24 2.359 0.001 1527 x.pg134.x5.pk1
0.014850 0.239 2.356 0.001 1530 x.pg140.x5.pk1
--- relative to first result
1.01 1.02 1.02 inf 0.98 x.pg134.x5.pk1
1.00 1.01 1.01 inf 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.174401 137.22 1124.98 0.014 56 x.pg124.x5.pk1
0.172209 137.261 1125.32 0.013 56 x.pg134.x5.pk1
0.159101 137.289 1125.96 0.03 57 x.pg140.x5.pk1
--- relative to first result
0.99 1.00 1.00 0.93 1.00 x.pg134.x5.pk1
0.91 1.00 1.00 2.14 1.02 x.pg140.x5.pk1
points-covered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.015198 0.401 3.958 0.001 1483 x.pg124.x5.pk1
0.015236 0.348 3.457 0 1489 x.pg134.x5.pk1
0.015174 0.348 3.457 0.001 1487 x.pg140.x5.pk1
--- relative to first result
1.00 0.87 0.87 0.00 1.00 x.pg134.x5.pk1
1.00 0.87 0.87 1.00 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.174304 137.343 1126.13 0.013 56 x.pg124.x5.pk1
0.163539 130.336 1068.05 0.012 59 x.pg134.x5.pk1
0.155689 130.341 1068.54 0.018 60 x.pg140.x5.pk1
--- relative to first result
0.94 0.95 0.95 0.92 1.05 x.pg134.x5.pk1
0.89 0.95 0.95 1.38 1.07 x.pg140.x5.pk1
range-covered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002982 0.065 0.79 0 8457 x.pg124.x5.pk1
0.002965 0.065 0.782 0 8556 x.pg134.x5.pk1
0.002925 0.066 0.802 0 8329 x.pg140.x5.pk1
--- relative to first result
0.99 1.00 0.99 1 1.01 x.pg134.x5.pk1
0.98 1.02 1.02 1 0.98 x.pg140.x5.pk1
range-notcovered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.014853 4.589 99.746 0.001 1165 x.pg124.x5.pk1
0.015277 4.589 99.761 0.001 1146 x.pg134.x5.pk1
0.013936 4.578 99.632 0.001 1164 x.pg140.x5.pk1
--- relative to first result
1.03 1.00 1.00 1.00 0.98 x.pg134.x5.pk1
0.94 1.00 1.00 1.00 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.003646 0.082 0.997 0 6796 x.pg124.x5.pk1
0.003603 0.069 0.825 0 6916 x.pg134.x5.pk1
0.003550 0.07 0.844 0 6761 x.pg140.x5.pk1
--- relative to first result
0.99 0.84 0.83 1 1.02 x.pg134.x5.pk1
0.97 0.85 0.85 1 0.99 x.pg140.x5.pk1
range-notcovered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.119968 90.966 733.589 0.01 83 x.pg124.x5.pk1
0.120071 91.023 733.837 0.009 83 x.pg134.x5.pk1
0.114555 90.972 733.467 0.01 83 x.pg140.x5.pk1
--- relative to first result
1.00 1.00 1.00 0.90 1.00 x.pg134.x5.pk1
0.95 1.00 1.00 1.00 1.00 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.22 0 1936047 x.pg124.x5.pk1
0.000015 0.002 0.22 0 1624886 x.pg134.x5.pk1
0.000014 0.002 0.22 0 1791634 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.010980 1.457 11.752 14.85 2036 x.pg124.x5.pk1
0.010887 1.456 11.742 14.981 2059 x.pg134.x5.pk1
0.009809 1.458 11.758 14.764 2008 x.pg140.x5.pk1
--- relative to first result
0.99 1.00 1.00 1.01 1.01 x.pg134.x5.pk1
0.89 1.00 1.00 0.99 0.99 x.pg140.x5.pk1
insert.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.009748 0.679 13.929 26.41 2341 x.pg124.x5.pk1
0.009456 0.631 13.54 26.123 2430 x.pg134.x5.pk1
0.009399 0.637 13.642 25.699 2175 x.pg140.x5.pk1
--- relative to first result
0.97 0.93 0.97 0.99 1.04 x.pg134.x5.pk1
0.96 0.94 0.98 0.97 0.93 x.pg140.x5.pk1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment