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/35ad03dbeee2253ced5096907bacf886 to your computer and use it in GitHub Desktop.
Save mdcallag/35ad03dbeee2253ced5096907bacf886 to your computer and use it in GitHub Desktop.
Download ZIP
r.10mrows.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.000327 0 0 0.875 84033 x.pg124.x5.pk1
0.000310 0 0 0.851 89285 x.pg134.x5.pk1
0.000296 0 0 0.848 88495 x.pg140.x5.pk1
--- relative to first result
0.95 1 1 0.97 1.06 x.pg134.x5.pk1
0.91 1 1 0.97 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.001833 0 0 0 14520 x.pg124.x5.pk1
0.001831 0 0 0 14480 x.pg134.x5.pk1
0.001907 0 0 0 13861 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1 1.00 x.pg134.x5.pk1
1.04 1 1 1 0.95 x.pg140.x5.pk1
random-points.pre.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003049 0 0 0 8513 x.pg124.x5.pk1
0.003107 0 0 0 8351 x.pg134.x5.pk1
0.003085 0 0 0 8372 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1 0.98 x.pg134.x5.pk1
1.01 1 1 1 0.98 x.pg140.x5.pk1
random-points.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.013216 0 0 0 1884 x.pg124.x5.pk1
0.013323 0 0 0 1860 x.pg134.x5.pk1
0.013212 0 0 0.001 1870 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.99 x.pg134.x5.pk1
1.00 1 1 inf 0.99 x.pg140.x5.pk1
random-points.pre.range1000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.112836 0 0 0.004 235 x.pg124.x5.pk1
0.113054 0 0 0.004 232 x.pg134.x5.pk1
0.110824 0 0 0.003 235 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1.00 0.99 x.pg134.x5.pk1
0.98 1 1 0.75 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.001838 0 0 0 14018 x.pg124.x5.pk1
0.001875 0 0 0 13725 x.pg134.x5.pk1
0.001864 0 0 0 13716 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1 0.98 x.pg134.x5.pk1
1.01 1 1 1 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.002378 0 0 0 10738 x.pg124.x5.pk1
0.002403 0 0 0 10661 x.pg134.x5.pk1
0.002391 0 0 0 10611 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.99 x.pg134.x5.pk1
1.01 1 1 1 0.99 x.pg140.x5.pk1
read-only.pre.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.085046 0 0 0.004 316 x.pg124.x5.pk1
0.085065 0 0 0.002 317 x.pg134.x5.pk1
0.084147 0 0 0.003 318 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 0.50 1.00 x.pg134.x5.pk1
0.99 1 1 0.75 1.01 x.pg140.x5.pk1
points-covered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.010860 0 0 0.001 2112 x.pg124.x5.pk1
0.011187 0 0 0 2082 x.pg134.x5.pk1
0.011063 0 0 0 2083 x.pg140.x5.pk1
--- relative to first result
1.03 1 1 0.00 0.99 x.pg134.x5.pk1
1.02 1 1 0.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.013463 0 0 0.001 1843 x.pg124.x5.pk1
0.013694 0 0 0 1827 x.pg134.x5.pk1
0.013666 0 0 0 1812 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 0.00 0.99 x.pg134.x5.pk1
1.02 1 1 0.00 0.98 x.pg140.x5.pk1
points-covered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011182 0 0 0.001 2081 x.pg124.x5.pk1
0.011293 0 0 0 2053 x.pg134.x5.pk1
0.011417 0 0 0 2036 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 0.00 0.99 x.pg134.x5.pk1
1.02 1 1 0.00 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.013734 0 0 0.001 1810 x.pg124.x5.pk1
0.013914 0 0 0 1790 x.pg134.x5.pk1
0.014561 0 0 0 1704 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 0.00 0.99 x.pg134.x5.pk1
1.06 1 1 0.00 0.94 x.pg140.x5.pk1
range-covered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002684 0 0 0 9691 x.pg124.x5.pk1
0.002692 0 0 0 9674 x.pg134.x5.pk1
0.002746 0 0 0 9442 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1 1.00 x.pg134.x5.pk1
1.02 1 1 1 0.97 x.pg140.x5.pk1
range-notcovered-pk.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003503 0 0 0 7608 x.pg124.x5.pk1
0.003548 0 0 0 7493 x.pg134.x5.pk1
0.003545 0 0 0 7479 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.98 x.pg134.x5.pk1
1.01 1 1 1 0.98 x.pg140.x5.pk1
range-covered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003015 0 0 0 8560 x.pg124.x5.pk1
0.003083 0 0 0 8372 x.pg134.x5.pk1
0.003060 0 0 0 8319 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1 0.98 x.pg134.x5.pk1
1.01 1 1 1 0.97 x.pg140.x5.pk1
range-notcovered-si.pre.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.006003 0 0 0 4270 x.pg124.x5.pk1
0.006159 0 0 0 4171 x.pg134.x5.pk1
0.006074 0 0 0 4220 x.pg140.x5.pk1
--- relative to first result
1.03 1 1 1 0.98 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.006159 0 0 10.094 4696 x.pg124.x5.pk1
0.006163 0 0 11.449 4718 x.pg134.x5.pk1
0.005227 0 0 10.932 4971 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1.13 1.00 x.pg134.x5.pk1
0.85 1 1 1.08 1.06 x.pg140.x5.pk1
update-index.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003463 0 0 3.333 9102 x.pg124.x5.pk1
0.003482 0 0 3.222 9092 x.pg134.x5.pk1
0.003090 0 0 2.731 9131 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 0.97 1.00 x.pg134.x5.pk1
0.89 1 1 0.82 1.00 x.pg140.x5.pk1
update-nonindex.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003247 0 0 2 9739 x.pg124.x5.pk1
0.003220 0 0 2.002 9763 x.pg134.x5.pk1
0.002760 0 0 1.909 9932 x.pg140.x5.pk1
--- relative to first result
0.99 1 1 1.00 1.00 x.pg134.x5.pk1
0.85 1 1 0.95 1.02 x.pg140.x5.pk1
update-one.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003241 0 0 1.205 9758 x.pg124.x5.pk1
0.003189 0 0 1.243 9951 x.pg134.x5.pk1
0.002765 0 0 1.039 9929 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.86 1.02 x.pg140.x5.pk1
update-zipf.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003180 0 0 2.169 9898 x.pg124.x5.pk1
0.003235 0 0 2.106 9774 x.pg134.x5.pk1
0.002788 0 0 2.068 9886 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 0.97 0.99 x.pg134.x5.pk1
0.88 1 1 0.95 1.00 x.pg140.x5.pk1
write-only.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002205 0 0 1.715 13741 x.pg124.x5.pk1
0.002208 0 0 1.686 13706 x.pg134.x5.pk1
0.002091 0 0 1.603 13549 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 0.98 1.00 x.pg134.x5.pk1
0.95 1 1 0.93 0.99 x.pg140.x5.pk1
read-write.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002340 0 0 1.471 13068 x.pg124.x5.pk1
0.002367 0 0 1.467 12879 x.pg134.x5.pk1
0.002218 0 0 1.402 12699 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1.00 0.99 x.pg134.x5.pk1
0.95 1 1 0.95 0.97 x.pg140.x5.pk1
read-only.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001850 0 0 0 13871 x.pg124.x5.pk1
0.001874 0 0 0 13735 x.pg134.x5.pk1
0.001873 0 0 0 13601 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.99 x.pg134.x5.pk1
1.01 1 1 1 0.98 x.pg140.x5.pk1
read-only.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002497 0 0 0 10153 x.pg124.x5.pk1
0.002502 0 0 0 10132 x.pg134.x5.pk1
0.002505 0 0 0 10062 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1 1.00 x.pg134.x5.pk1
1.00 1 1 1 0.99 x.pg140.x5.pk1
read-only.range10000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.094552 0 0 0.002 281 x.pg124.x5.pk1
0.094762 0 0 0.002 280 x.pg134.x5.pk1
0.094127 0 0 0.003 282 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1.00 1.00 x.pg134.x5.pk1
1.00 1 1 1.50 1.00 x.pg140.x5.pk1
point-query.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.001800 0 0 0 14775 x.pg124.x5.pk1
0.001857 0 0 0 14324 x.pg134.x5.pk1
0.001836 0 0 0 14326 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
random-points.range10.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003082 0 0 0 8353 x.pg124.x5.pk1
0.003125 0 0 0 8301 x.pg134.x5.pk1
0.003064 0 0 0 8302 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 0.99 x.pg134.x5.pk1
0.99 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.013420 0 0 0 1855 x.pg124.x5.pk1
0.013644 0 0 0 1827 x.pg134.x5.pk1
0.013312 0 0 0 1854 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1 0.98 x.pg134.x5.pk1
0.99 1 1 1 1.00 x.pg140.x5.pk1
random-points.range1000.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.114581 0 0 0.004 229 x.pg124.x5.pk1
0.114434 0 0 0.003 227 x.pg134.x5.pk1
0.111314 0 0 0.004 232 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 0.75 0.99 x.pg134.x5.pk1
0.97 1 1 1.00 1.01 x.pg140.x5.pk1
hot-points.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.007767 0 0 0 3266 x.pg124.x5.pk1
0.007947 0 0 0 3191 x.pg134.x5.pk1
0.007781 0 0 0 3252 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
points-covered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011240 0 0 0 2085 x.pg124.x5.pk1
0.011222 0 0 0 2059 x.pg134.x5.pk1
0.011156 0 0 0 2060 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1 0.99 x.pg134.x5.pk1
0.99 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.013727 0 0 0 1813 x.pg124.x5.pk1
0.013835 0 0 0.001 1799 x.pg134.x5.pk1
0.013789 0 0 0 1802 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 inf 0.99 x.pg134.x5.pk1
1.00 1 1 1 0.99 x.pg140.x5.pk1
points-covered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.011498 0 0 0 2037 x.pg124.x5.pk1
0.011723 0 0 0 2023 x.pg134.x5.pk1
0.011580 0 0 0 2026 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1 0.99 x.pg134.x5.pk1
1.01 1 1 1 0.99 x.pg140.x5.pk1
points-notcovered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.014072 0 0 0 1770 x.pg124.x5.pk1
0.014059 0 0 0.001 1768 x.pg134.x5.pk1
0.014687 0 0 0 1689 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 inf 1.00 x.pg134.x5.pk1
1.04 1 1 1 0.95 x.pg140.x5.pk1
range-covered-pk.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002818 0 0 0 9190 x.pg124.x5.pk1
0.002843 0 0 0 9175 x.pg134.x5.pk1
0.002846 0 0 0 9042 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1 1.00 x.pg134.x5.pk1
1.01 1 1 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.003898 0 0 0 6773 x.pg124.x5.pk1
0.003913 0 0 0 6728 x.pg134.x5.pk1
0.003918 0 0 0 6690 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1 0.99 x.pg134.x5.pk1
1.01 1 1 1 0.99 x.pg140.x5.pk1
range-covered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.003039 0 0 0 8512 x.pg124.x5.pk1
0.003101 0 0 0 8333 x.pg134.x5.pk1
0.003098 0 0 0 8279 x.pg140.x5.pk1
--- relative to first result
1.02 1 1 1 0.98 x.pg134.x5.pk1
1.02 1 1 1 0.97 x.pg140.x5.pk1
range-notcovered-si.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.006146 0 0 0 4174 x.pg124.x5.pk1
0.006234 0 0 0 4109 x.pg134.x5.pk1
0.006152 0 0 0 4157 x.pg140.x5.pk1
--- relative to first result
1.01 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 2241750 x.pg124.x5.pk1
0.000013 0 0 0 1843794 x.pg134.x5.pk1
0.000011 0 0 0 2147536 x.pg140.x5.pk1
--- relative to first result
1.30 1 1 1 0.82 x.pg134.x5.pk1
1.10 1 1 1 0.96 x.pg140.x5.pk1
delete.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002530 0 0 1.993 12869 x.pg124.x5.pk1
0.002553 0 0 1.996 12715 x.pg134.x5.pk1
0.002241 0 0 1.833 12728 x.pg140.x5.pk1
--- relative to first result
1.01 1 1 1.00 0.99 x.pg134.x5.pk1
0.89 1 1 0.92 0.99 x.pg140.x5.pk1
insert.range100.pk1.dop1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.002497 0 0 1.646 12885 x.pg124.x5.pk1
0.002496 0 0 1.899 12922 x.pg134.x5.pk1
0.002297 0 0 1.655 12517 x.pg140.x5.pk1
--- relative to first result
1.00 1 1 1.15 1.00 x.pg134.x5.pk1
0.92 1 1 1.01 0.97 x.pg140.x5.pk1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment