Skip to content

Instantly share code, notes, and snippets.

View mdcallag's full-sized avatar
🎯
Focusing

Mark Callaghan mdcallag

🎯
Focusing
View GitHub Profile
@mdcallag
mdcallag / o.summ.my
Created December 1, 2021 01:05
r.400mrows.300s.1u.prep0 - o.summ.my
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000320 0.013 0.314 1.271 66856 x.my5649.y8.pk1
0.000312 0.013 0.317 1.247 69601 x.my5735.y8.pk1
0.000497 0.013 0.317 1.235 57413 x.my8020.y8.pk1
0.000421 0.013 0.317 1.236 54149 x.my8022.y8.pk1
0.000427 0.013 0.317 1.236 53490 x.my8023.y8.pk1
0.000412 0.013 0.317 1.235 57151 x.my8026.y8.pk1
0.000495 0.014 0.334 1.259 58539 x.my8027.y8.pk1
@mdcallag
mdcallag / o.summ.my
Created December 1, 2021 01:04
r.10mrows.300s.1u.prep1 - o.summ.my
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000284 0 0.072 1.226 81967 x.my5649.y8.pk1
0.000284 0 0.069 0.872 82644 x.my5735.y8.pk1
0.000449 0 0 0.863 64935 x.my8020.y8.pk1
0.000370 0 0 0.865 61728 x.my8022.y8.pk1
0.000366 0 0 0.869 63291 x.my8023.y8.pk1
0.000359 0 0 0.86 65789 x.my8026.y8.pk1
0.000396 0 0.017 0.871 67567 x.my8027.y8.pk1
@mdcallag
mdcallag / gist:f9e974afda0d98ce6afd1ee813fb04e6
Created December 1, 2021 01:03
r.10mrows.300s.1u.prep0 - o.summ.my
point-query.warm.range100.pk1
--- absolute
cpu/o r/o rKB/o wKB/o o/s dbms
0.000283 0 0.072 1.224 82644 x.my5649.y8.pk1
0.000273 0 0.07 0.854 88495 x.my5735.y8.pk1
0.000438 0 0 0.858 67114 x.my8020.y8.pk1
0.000363 0 0 0.862 63694 x.my8022.y8.pk1
0.000369 0 0 0.862 62893 x.my8023.y8.pk1
0.000352 0 0 0.862 67114 x.my8026.y8.pk1
0.000399 0 0.017 0.888 67114 x.my8027.y8.pk1
@mdcallag
mdcallag / gist:a46d2df7924eed14438ae9a26cc5e279
Created December 1, 2021 00:55
r.400mrows.300s.1u.prep0 - o.sumr.r1.pg
db_1 = x.pg124.x5.pk1
db_2 = x.pg134.x5.pk1
db_3 = x.pg140.x5.pk1
db_1 db_2 db_3
1.00 1.12 1.13 point-query.warm.range100.pk1
1.00 0.89 0.88 point-query.pre.range100.pk1
1.00 1.02 1.01 random-points.pre.range10.pk1
1.00 1.02 1.02 random-points.pre.range100.pk1
1.00 1.20 1.20 random-points.pre.range1000.pk1
@mdcallag
mdcallag / gist:ad81f3869eef8e4ac0e3628a59b08553
Created December 1, 2021 00:55
r.10mrows.300s.1u.prep1 - o.sumr.r1.pg
db_1 = x.pg124.x5.pk1
db_2 = x.pg134.x5.pk1
db_3 = x.pg140.x5.pk1
db_1 db_2 db_3
1.00 1.06 1.05 point-query.warm.range100.pk1
1.00 1.00 1.00 point-query.pre.range100.pk1
1.00 0.98 0.99 random-points.pre.range10.pk1
1.00 0.95 0.97 random-points.pre.range100.pk1
1.00 0.95 0.97 random-points.pre.range1000.pk1
@mdcallag
mdcallag / gist:96c4db58348478d502ed2b6a4105f678
Created December 1, 2021 00:54
r.10mrows.300s.1u.prep0 - o.sumr.r1.pg
db_1 = x.pg124.x5.pk1
db_2 = x.pg134.x5.pk1
db_3 = x.pg140.x5.pk1
db_1 db_2 db_3
1.00 1.06 1.05 point-query.warm.range100.pk1
1.00 1.00 0.95 point-query.pre.range100.pk1
1.00 0.98 0.98 random-points.pre.range10.pk1
1.00 0.99 0.99 random-points.pre.range100.pk1
1.00 0.99 1.00 random-points.pre.range1000.pk1
@mdcallag
mdcallag / gist:981f65259e5661692efa0dd07bab120b
Created December 1, 2021 00:52
r.400mrows.300s.1u.prep0 - o.sumr.r1.my
db_1 = x.my5649.y8.pk1
db_2 = x.my5735.y8.pk1
db_3 = x.my8020.y8.pk1
db_4 = x.my8022.y8.pk1
db_5 = x.my8023.y8.pk1
db_6 = x.my8026.y8.pk1
db_7 = x.my8027.y8.pk1
db_1 db_2 db_3 db_4 db_5 db_6 db_7
1.00 1.04 0.86 0.81 0.80 0.85 0.88 point-query.warm.range100.pk1
@mdcallag
mdcallag / gist:0b1b6d45bcb19dd89a9a8122352f1166
Created December 1, 2021 00:52
r.10mrows.300s.1u.prep1 - o.sumr.r1.my
db_1 = x.my5649.y8.pk1
db_2 = x.my5735.y8.pk1
db_3 = x.my8020.y8.pk1
db_4 = x.my8022.y8.pk1
db_5 = x.my8023.y8.pk1
db_6 = x.my8026.y8.pk1
db_7 = x.my8027.y8.pk1
db_1 db_2 db_3 db_4 db_5 db_6 db_7
1.00 1.01 0.79 0.75 0.77 0.80 0.82 point-query.warm.range100.pk1
@mdcallag
mdcallag / gist:b09e642d7ca71fc3655a7404603fd9db
Created December 1, 2021 00:52
r.10mrows.300s.1u.prep0 - o.sumr.r1.my
db_1 = x.my5649.y8.pk1
db_2 = x.my5735.y8.pk1
db_3 = x.my8020.y8.pk1
db_4 = x.my8022.y8.pk1
db_5 = x.my8023.y8.pk1
db_6 = x.my8026.y8.pk1
db_7 = x.my8027.y8.pk1
db_1 db_2 db_3 db_4 db_5 db_6 db_7
1.00 1.07 0.81 0.77 0.76 0.81 0.81 point-query.warm.range100.pk1
ops_sec mb_sec size_gb c_wgb w_amp c_mbps c_secs usec_op p50 p99 p99.9 p99.99 pmax uptime stall% Nstall u_cpu s_cpu test date version job_id
557865 223.4 0.0 41.87 1.0 126.10 538.7 1.8 1.2 5 19 99 9310 340 0.3 6 0.7 0.1 fillseq.wal_disabled.v400 2021-11-22T12:07:30 6.0
523826 209.8 0.0 43.68 1.0 117.67 608.2 1.9 1.3 6 19 122 88700 380 2.6 113 0.8 0.1 fillseq.wal_disabled.v400 2021-11-22T15:19:46 6.1
543829 217.8 0.0 42.97 1.0 122.20 527.2 1.8 1.3 5 18 89 8570 360 0.0 0 0.7 0.1 fillseq.wal_disabled.v400 2021-11-22T18:36:15 6.2
489522 196.1 0.0 42.80 1.0 109.56 628.8 2.0 1.4 7 19 127 156652 400 2.1 130 0.8 0.1 fillseq.wal_disabled.v400 2021-11-22T21:54:11 6.3
539178 216.0 0.0 42.54 1