new_report.txt

text/plain

Download

===== rows type nrows dist cols run mksort_op time =====
distinct:  63166 (ratio: 0.63166)
100000 int random 1 2 1 off 25.748
100000 int random 1 2 1 on 27.557 -0.07
100000 int random 1 2 2 off 25.620
100000 int random 1 2 2 on 27.843 -0.08
100000 int random 1 2 3 off 25.596
100000 int random 1 2 3 on 27.616 -0.07
distinct:  63230 (ratio: 0.6323)
100000 int random 1 5 1 off 27.184
100000 int random 1 5 1 on 28.771 -0.06
100000 int random 1 5 2 off 26.781
100000 int random 1 5 2 on 28.629 -0.06
100000 int random 1 5 3 off 26.540
100000 int random 1 5 3 on 28.406 -0.07
distinct:  63353 (ratio: 0.63353)
100000 int random 1 8 1 off 28.213
100000 int random 1 8 1 on 29.114 -0.03
100000 int random 1 8 2 off 27.218
100000 int random 1 8 2 on 29.222 -0.07
100000 int random 1 8 3 off 28.554
100000 int random 1 8 3 on 29.704 -0.04
distinct:  75021 (ratio: 0.75021)
100000 int correlated 1 2 1 off 11.584
100000 int correlated 1 2 1 on 11.663 -0.01
100000 int correlated 1 2 2 off 11.427
100000 int correlated 1 2 2 on 11.532 -0.01
100000 int correlated 1 2 3 off 11.403
100000 int correlated 1 2 3 on 11.700 -0.03
distinct:  74953 (ratio: 0.74953)
100000 int correlated 1 5 1 off 12.588
100000 int correlated 1 5 1 on 12.700 -0.01
100000 int correlated 1 5 2 off 12.451
100000 int correlated 1 5 2 on 12.532 -0.01
100000 int correlated 1 5 3 off 12.535
100000 int correlated 1 5 3 on 12.444 0.01
distinct:  74953 (ratio: 0.74953)
100000 int correlated 1 8 1 off 13.253
100000 int correlated 1 8 1 on 13.002 0.02
100000 int correlated 1 8 2 off 13.230
100000 int correlated 1 8 2 on 13.239 -0.00
100000 int correlated 1 8 3 off 13.189
100000 int correlated 1 8 3 on 13.251 -0.00
distinct:  100000 (ratio: 1)
100000 int sequential 1 2 1 off 10.861
100000 int sequential 1 2 1 on 10.813 0.00
100000 int sequential 1 2 2 off 10.801
100000 int sequential 1 2 2 on 10.719 0.01
100000 int sequential 1 2 3 off 10.741
100000 int sequential 1 2 3 on 11.427 -0.06
distinct:  100000 (ratio: 1)
100000 int sequential 1 5 1 off 11.608
100000 int sequential 1 5 1 on 11.590 0.00
100000 int sequential 1 5 2 off 11.522
100000 int sequential 1 5 2 on 11.653 -0.01
100000 int sequential 1 5 3 off 11.612
100000 int sequential 1 5 3 on 11.562 0.00
distinct:  100000 (ratio: 1)
100000 int sequential 1 8 1 off 12.107
100000 int sequential 1 8 1 on 12.077 0.00
100000 int sequential 1 8 2 off 11.965
100000 int sequential 1 8 2 on 12.122 -0.01
100000 int sequential 1 8 3 off 12.169
100000 int sequential 1 8 3 on 12.628 -0.04
distinct:  19879 (ratio: 0.19879)
100000 int random 5 2 1 off 29.634
100000 int random 5 2 1 on 29.843 -0.01
100000 int random 5 2 2 off 28.526
100000 int random 5 2 2 on 29.422 -0.03
100000 int random 5 2 3 off 28.719
100000 int random 5 2 3 on 29.681 -0.03
distinct:  19853 (ratio: 0.19853)
100000 int random 5 5 1 off 30.245
100000 int random 5 5 1 on 30.802 -0.02
100000 int random 5 5 2 off 30.054
100000 int random 5 5 2 on 30.999 -0.03
100000 int random 5 5 3 off 29.758
100000 int random 5 5 3 on 30.607 -0.03
distinct:  19857 (ratio: 0.19857)
100000 int random 5 8 1 off 31.383
100000 int random 5 8 1 on 31.865 -0.02
100000 int random 5 8 2 off 30.692
100000 int random 5 8 2 on 31.751 -0.03
100000 int random 5 8 3 off 30.896
100000 int random 5 8 3 on 31.628 -0.02
distinct:  19987 (ratio: 0.19987)
100000 int correlated 5 2 1 off 20.773
100000 int correlated 5 2 1 on 20.669 0.01
100000 int correlated 5 2 2 off 20.413
100000 int correlated 5 2 2 on 20.780 -0.02
100000 int correlated 5 2 3 off 20.626
100000 int correlated 5 2 3 on 20.694 -0.00
distinct:  19984 (ratio: 0.19984)
100000 int correlated 5 5 1 off 25.631
100000 int correlated 5 5 1 on 25.088 0.02
100000 int correlated 5 5 2 off 25.085
100000 int correlated 5 5 2 on 24.730 0.01
100000 int correlated 5 5 3 off 25.056
100000 int correlated 5 5 3 on 25.040 0.00
distinct:  19981 (ratio: 0.19981)
100000 int correlated 5 8 1 off 26.173
100000 int correlated 5 8 1 on 25.583 0.02
100000 int correlated 5 8 2 off 25.648
100000 int correlated 5 8 2 on 25.610 0.00
100000 int correlated 5 8 3 off 25.530
100000 int correlated 5 8 3 on 25.538 -0.00
distinct:  20001 (ratio: 0.20001)
100000 int sequential 5 2 1 off 12.010
100000 int sequential 5 2 1 on 11.871 0.01
100000 int sequential 5 2 2 off 11.771
100000 int sequential 5 2 2 on 11.917 -0.01
100000 int sequential 5 2 3 off 11.818
100000 int sequential 5 2 3 on 11.954 -0.01
distinct:  20001 (ratio: 0.20001)
100000 int sequential 5 5 1 off 14.896
100000 int sequential 5 5 1 on 14.717 0.01
100000 int sequential 5 5 2 off 14.846
100000 int sequential 5 5 2 on 14.720 0.01
100000 int sequential 5 5 3 off 14.769
100000 int sequential 5 5 3 on 14.673 0.01
distinct:  20001 (ratio: 0.20001)
100000 int sequential 5 8 1 off 17.084
100000 int sequential 5 8 1 on 17.007 0.00
100000 int sequential 5 8 2 off 17.182
100000 int sequential 5 8 2 on 17.012 0.01
100000 int sequential 5 8 3 off 17.240
100000 int sequential 5 8 3 on 16.977 0.02
distinct:  10001 (ratio: 0.10001)
100000 int random 10 2 1 off 31.036
100000 int random 10 2 1 on 30.770 0.01
100000 int random 10 2 2 off 30.455
100000 int random 10 2 2 on 30.906 -0.01
100000 int random 10 2 3 off 30.601
100000 int random 10 2 3 on 30.707 -0.00
distinct:   9999 (ratio: 0.09999)
100000 int random 10 5 1 off 32.336
100000 int random 10 5 1 on 31.963 0.01
100000 int random 10 5 2 off 32.281
100000 int random 10 5 2 on 31.970 0.01
100000 int random 10 5 3 off 31.657
100000 int random 10 5 3 on 32.381 -0.02
distinct:  10001 (ratio: 0.10001)
100000 int random 10 8 1 off 33.234
100000 int random 10 8 1 on 32.687 0.02
100000 int random 10 8 2 off 32.474
100000 int random 10 8 2 on 33.011 -0.02
100000 int random 10 8 3 off 32.413
100000 int random 10 8 3 on 33.058 -0.02
distinct:  10001 (ratio: 0.10001)
100000 int correlated 10 2 1 off 20.899
100000 int correlated 10 2 1 on 21.480 -0.03
100000 int correlated 10 2 2 off 20.750
100000 int correlated 10 2 2 on 21.429 -0.03
100000 int correlated 10 2 3 off 20.843
100000 int correlated 10 2 3 on 21.501 -0.03
distinct:  10002 (ratio: 0.10002)
100000 int correlated 10 5 1 off 28.899
100000 int correlated 10 5 1 on 28.490 0.01
100000 int correlated 10 5 2 off 28.676
100000 int correlated 10 5 2 on 28.426 0.01
100000 int correlated 10 5 3 off 28.575
100000 int correlated 10 5 3 on 28.555 0.00
distinct:  10001 (ratio: 0.10001)
100000 int correlated 10 8 1 off 30.914
100000 int correlated 10 8 1 on 29.874 0.03
100000 int correlated 10 8 2 off 29.779
100000 int correlated 10 8 2 on 29.588 0.01
100000 int correlated 10 8 3 off 29.812
100000 int correlated 10 8 3 on 29.614 0.01
distinct:  10001 (ratio: 0.10001)
100000 int sequential 10 2 1 off 12.153
100000 int sequential 10 2 1 on 12.180 -0.00
100000 int sequential 10 2 2 off 12.120
100000 int sequential 10 2 2 on 12.032 0.01
100000 int sequential 10 2 3 off 12.080
100000 int sequential 10 2 3 on 12.200 -0.01
distinct:  10001 (ratio: 0.10001)
100000 int sequential 10 5 1 off 15.018
100000 int sequential 10 5 1 on 14.920 0.01
100000 int sequential 10 5 2 off 15.194
100000 int sequential 10 5 2 on 15.148 0.00
100000 int sequential 10 5 3 off 15.093
100000 int sequential 10 5 3 on 14.927 0.01
distinct:  10001 (ratio: 0.10001)
100000 int sequential 10 8 1 off 17.430
100000 int sequential 10 8 1 on 17.318 0.01
100000 int sequential 10 8 2 off 17.500
100000 int sequential 10 8 2 on 17.381 0.01
100000 int sequential 10 8 3 off 17.364
100000 int sequential 10 8 3 on 17.546 -0.01
distinct:   5001 (ratio: 0.05001)
100000 int random 20 2 1 off 32.676
100000 int random 20 2 1 on 31.308 0.04
100000 int random 20 2 2 off 32.091
100000 int random 20 2 2 on 31.645 0.01
100000 int random 20 2 3 off 32.144
100000 int random 20 2 3 on 31.640 0.02
distinct:   5001 (ratio: 0.05001)
100000 int random 20 5 1 off 34.320
100000 int random 20 5 1 on 32.762 0.05
100000 int random 20 5 2 off 33.478
100000 int random 20 5 2 on 32.746 0.02
100000 int random 20 5 3 off 33.444
100000 int random 20 5 3 on 32.634 0.02
distinct:   5001 (ratio: 0.05001)
100000 int random 20 8 1 off 35.134
100000 int random 20 8 1 on 33.296 0.06
100000 int random 20 8 2 off 33.834
100000 int random 20 8 2 on 33.052 0.02
100000 int random 20 8 3 off 33.748
100000 int random 20 8 3 on 33.497 0.01
distinct:   5002 (ratio: 0.05002)
100000 int correlated 20 2 1 off 20.533
100000 int correlated 20 2 1 on 20.387 0.01
100000 int correlated 20 2 2 off 20.162
100000 int correlated 20 2 2 on 20.314 -0.01
100000 int correlated 20 2 3 off 20.088
100000 int correlated 20 2 3 on 20.424 -0.02
distinct:   5001 (ratio: 0.05001)
100000 int correlated 20 5 1 off 32.526
100000 int correlated 20 5 1 on 30.385 0.07
100000 int correlated 20 5 2 off 32.351
100000 int correlated 20 5 2 on 30.288 0.07
100000 int correlated 20 5 3 off 32.596
100000 int correlated 20 5 3 on 30.272 0.08
distinct:   5001 (ratio: 0.05001)
100000 int correlated 20 8 1 off 35.623
100000 int correlated 20 8 1 on 32.571 0.09
100000 int correlated 20 8 2 off 35.186
100000 int correlated 20 8 2 on 32.604 0.08
100000 int correlated 20 8 3 off 34.913
100000 int correlated 20 8 3 on 32.256 0.08
distinct:   5001 (ratio: 0.05001)
100000 int sequential 20 2 1 off 12.128
100000 int sequential 20 2 1 on 12.652 -0.04
100000 int sequential 20 2 2 off 12.144
100000 int sequential 20 2 2 on 12.157 -0.00
100000 int sequential 20 2 3 off 12.056
100000 int sequential 20 2 3 on 13.960 -0.14
distinct:   5001 (ratio: 0.05001)
100000 int sequential 20 5 1 off 15.243
100000 int sequential 20 5 1 on 15.112 0.01
100000 int sequential 20 5 2 off 14.989
100000 int sequential 20 5 2 on 15.006 -0.00
100000 int sequential 20 5 3 off 14.994
100000 int sequential 20 5 3 on 15.202 -0.01
distinct:   5001 (ratio: 0.05001)
100000 int sequential 20 8 1 off 17.826
100000 int sequential 20 8 1 on 17.881 -0.00
100000 int sequential 20 8 2 off 17.682
100000 int sequential 20 8 2 on 17.551 0.01
100000 int sequential 20 8 3 off 17.632
100000 int sequential 20 8 3 on 17.654 -0.00
distinct:   2001 (ratio: 0.02001)
100000 int random 50 2 1 off 34.496
100000 int random 50 2 1 on 32.991 0.05
100000 int random 50 2 2 off 34.217
100000 int random 50 2 2 on 32.978 0.04
100000 int random 50 2 3 off 34.050
100000 int random 50 2 3 on 32.925 0.03
distinct:   2001 (ratio: 0.02001)
100000 int random 50 5 1 off 35.942
100000 int random 50 5 1 on 34.957 0.03
100000 int random 50 5 2 off 35.903
100000 int random 50 5 2 on 34.307 0.05
100000 int random 50 5 3 off 35.616
100000 int random 50 5 3 on 34.124 0.04
distinct:   2001 (ratio: 0.02001)
100000 int random 50 8 1 off 37.606
100000 int random 50 8 1 on 35.104 0.07
100000 int random 50 8 2 off 36.199
100000 int random 50 8 2 on 35.042 0.03
100000 int random 50 8 3 off 36.638
100000 int random 50 8 3 on 35.182 0.04
distinct:   2001 (ratio: 0.02001)
100000 int correlated 50 2 1 off 19.534
100000 int correlated 50 2 1 on 19.077 0.02
100000 int correlated 50 2 2 off 19.232
100000 int correlated 50 2 2 on 19.282 -0.00
100000 int correlated 50 2 3 off 19.081
100000 int correlated 50 2 3 on 19.225 -0.01
distinct:   2002 (ratio: 0.02002)
100000 int correlated 50 5 1 off 36.195
100000 int correlated 50 5 1 on 32.915 0.10
100000 int correlated 50 5 2 off 36.091
100000 int correlated 50 5 2 on 32.986 0.09
100000 int correlated 50 5 3 off 35.896
100000 int correlated 50 5 3 on 32.972 0.09
distinct:   2001 (ratio: 0.02001)
100000 int correlated 50 8 1 off 42.961
100000 int correlated 50 8 1 on 37.445 0.15
100000 int correlated 50 8 2 off 42.336
100000 int correlated 50 8 2 on 37.769 0.12
100000 int correlated 50 8 3 off 42.485
100000 int correlated 50 8 3 on 37.377 0.14
distinct:   2001 (ratio: 0.02001)
100000 int sequential 50 2 1 off 12.260
100000 int sequential 50 2 1 on 12.292 -0.00
100000 int sequential 50 2 2 off 12.122
100000 int sequential 50 2 2 on 12.038 0.01
100000 int sequential 50 2 3 off 12.173
100000 int sequential 50 2 3 on 12.182 -0.00
distinct:   2001 (ratio: 0.02001)
100000 int sequential 50 5 1 off 15.497
100000 int sequential 50 5 1 on 15.228 0.02
100000 int sequential 50 5 2 off 15.268
100000 int sequential 50 5 2 on 15.122 0.01
100000 int sequential 50 5 3 off 15.027
100000 int sequential 50 5 3 on 15.217 -0.01
distinct:   2001 (ratio: 0.02001)
100000 int sequential 50 8 1 off 18.064
100000 int sequential 50 8 1 on 17.896 0.01
100000 int sequential 50 8 2 off 17.845
100000 int sequential 50 8 2 on 17.750 0.01
100000 int sequential 50 8 3 off 17.913
100000 int sequential 50 8 3 on 17.844 0.00
distinct:     11 (ratio: 0.00011)
100000 int random 10000 2 1 off 22.325
100000 int random 10000 2 1 on 20.916 0.07
100000 int random 10000 2 2 off 22.222
100000 int random 10000 2 2 on 21.143 0.05
100000 int random 10000 2 3 off 22.108
100000 int random 10000 2 3 on 20.859 0.06
distinct:     11 (ratio: 0.00011)
100000 int random 10000 5 1 off 66.679
100000 int random 10000 5 1 on 42.942 0.55
100000 int random 10000 5 2 off 66.775
100000 int random 10000 5 2 on 42.967 0.55
100000 int random 10000 5 3 off 67.543
100000 int random 10000 5 3 on 43.293 0.56
distinct:     11 (ratio: 0.00011)
100000 int random 10000 8 1 off 71.782
100000 int random 10000 8 1 on 45.418 0.58
100000 int random 10000 8 2 off 70.487
100000 int random 10000 8 2 on 45.356 0.55
100000 int random 10000 8 3 off 70.299
100000 int random 10000 8 3 on 45.069 0.56
distinct:     12 (ratio: 0.00012)
100000 int correlated 10000 2 1 off 16.278
100000 int correlated 10000 2 1 on 15.608 0.04
100000 int correlated 10000 2 2 off 16.139
100000 int correlated 10000 2 2 on 15.491 0.04
100000 int correlated 10000 2 3 off 16.246
100000 int correlated 10000 2 3 on 15.644 0.04
distinct:     11 (ratio: 0.00011)
100000 int correlated 10000 5 1 off 31.583
100000 int correlated 10000 5 1 on 25.885 0.22
100000 int correlated 10000 5 2 off 31.311
100000 int correlated 10000 5 2 on 25.930 0.21
100000 int correlated 10000 5 3 off 31.273
100000 int correlated 10000 5 3 on 25.919 0.21
distinct:     11 (ratio: 0.00011)
100000 int correlated 10000 8 1 off 53.441
100000 int correlated 10000 8 1 on 36.525 0.46
100000 int correlated 10000 8 2 off 53.606
100000 int correlated 10000 8 2 on 36.765 0.46
100000 int correlated 10000 8 3 off 53.809
100000 int correlated 10000 8 3 on 36.651 0.47
distinct:     11 (ratio: 0.00011)
100000 int sequential 10000 2 1 off 12.180
100000 int sequential 10000 2 1 on 12.025 0.01
100000 int sequential 10000 2 2 off 12.279
100000 int sequential 10000 2 2 on 12.217 0.01
100000 int sequential 10000 2 3 off 12.210
100000 int sequential 10000 2 3 on 12.186 0.00
distinct:     11 (ratio: 0.00011)
100000 int sequential 10000 5 1 off 15.299
100000 int sequential 10000 5 1 on 15.110 0.01
100000 int sequential 10000 5 2 off 15.106
100000 int sequential 10000 5 2 on 15.038 0.00
100000 int sequential 10000 5 3 off 15.057
100000 int sequential 10000 5 3 on 15.002 0.00
distinct:     11 (ratio: 0.00011)
100000 int sequential 10000 8 1 off 18.103
100000 int sequential 10000 8 1 on 18.611 -0.03
100000 int sequential 10000 8 2 off 18.234
100000 int sequential 10000 8 2 on 18.040 0.01
100000 int sequential 10000 8 3 off 18.102
100000 int sequential 10000 8 3 on 17.809 0.02
distinct:  63311 (ratio: 0.63311)
100000 bigint random 1 2 1 off 25.535
100000 bigint random 1 2 1 on 28.361 -0.10
100000 bigint random 1 2 2 off 24.861
100000 bigint random 1 2 2 on 28.083 -0.11
100000 bigint random 1 2 3 off 24.756
100000 bigint random 1 2 3 on 28.413 -0.13
distinct:  63201 (ratio: 0.63201)
100000 bigint random 1 5 1 off 28.138
100000 bigint random 1 5 1 on 29.873 -0.06
100000 bigint random 1 5 2 off 26.475
100000 bigint random 1 5 2 on 31.596 -0.16
100000 bigint random 1 5 3 off 26.966
100000 bigint random 1 5 3 on 29.780 -0.09
distinct:  63268 (ratio: 0.63268)
100000 bigint random 1 8 1 off 31.209
100000 bigint random 1 8 1 on 32.947 -0.05
100000 bigint random 1 8 2 off 30.997
100000 bigint random 1 8 2 on 31.940 -0.03
100000 bigint random 1 8 3 off 29.310
100000 bigint random 1 8 3 on 32.292 -0.09
distinct:  74879 (ratio: 0.74879)
100000 bigint correlated 1 2 1 off 12.038
100000 bigint correlated 1 2 1 on 12.075 -0.00
100000 bigint correlated 1 2 2 off 11.848
100000 bigint correlated 1 2 2 on 12.133 -0.02
100000 bigint correlated 1 2 3 off 11.997
100000 bigint correlated 1 2 3 on 12.054 -0.00
distinct:  74920 (ratio: 0.7492)
100000 bigint correlated 1 5 1 off 13.670
100000 bigint correlated 1 5 1 on 13.481 0.01
100000 bigint correlated 1 5 2 off 13.270
100000 bigint correlated 1 5 2 on 13.477 -0.02
100000 bigint correlated 1 5 3 off 13.294
100000 bigint correlated 1 5 3 on 13.500 -0.02
distinct:  75010 (ratio: 0.7501)
100000 bigint correlated 1 8 1 off 15.509
100000 bigint correlated 1 8 1 on 15.043 0.03
100000 bigint correlated 1 8 2 off 14.817
100000 bigint correlated 1 8 2 on 14.826 -0.00
100000 bigint correlated 1 8 3 off 14.927
100000 bigint correlated 1 8 3 on 15.037 -0.01
distinct:  100000 (ratio: 1)
100000 bigint sequential 1 2 1 off 11.406
100000 bigint sequential 1 2 1 on 11.342 0.01
100000 bigint sequential 1 2 2 off 11.211
100000 bigint sequential 1 2 2 on 11.256 -0.00
100000 bigint sequential 1 2 3 off 11.128
100000 bigint sequential 1 2 3 on 11.259 -0.01
distinct:  100000 (ratio: 1)
100000 bigint sequential 1 5 1 off 12.566
100000 bigint sequential 1 5 1 on 12.566 0.00
100000 bigint sequential 1 5 2 off 12.468
100000 bigint sequential 1 5 2 on 12.485 -0.00
100000 bigint sequential 1 5 3 off 12.380
100000 bigint sequential 1 5 3 on 12.601 -0.02
distinct:  100000 (ratio: 1)
100000 bigint sequential 1 8 1 off 13.916
100000 bigint sequential 1 8 1 on 13.900 0.00
100000 bigint sequential 1 8 2 off 13.821
100000 bigint sequential 1 8 2 on 13.911 -0.01
100000 bigint sequential 1 8 3 off 13.936
100000 bigint sequential 1 8 3 on 14.217 -0.02
distinct:  19877 (ratio: 0.19877)
100000 bigint random 5 2 1 off 28.978
100000 bigint random 5 2 1 on 30.108 -0.04
100000 bigint random 5 2 2 off 28.215
100000 bigint random 5 2 2 on 31.422 -0.10
100000 bigint random 5 2 3 off 28.516
100000 bigint random 5 2 3 on 30.737 -0.07
distinct:  19870 (ratio: 0.1987)
100000 bigint random 5 5 1 off 31.213
100000 bigint random 5 5 1 on 31.748 -0.02
100000 bigint random 5 5 2 off 31.106
100000 bigint random 5 5 2 on 32.109 -0.03
100000 bigint random 5 5 3 off 29.878
100000 bigint random 5 5 3 on 31.973 -0.07
distinct:  19871 (ratio: 0.19871)
100000 bigint random 5 8 1 off 35.470
100000 bigint random 5 8 1 on 34.420 0.03
100000 bigint random 5 8 2 off 32.234
100000 bigint random 5 8 2 on 36.350 -0.11
100000 bigint random 5 8 3 off 32.480
100000 bigint random 5 8 3 on 34.126 -0.05
distinct:  19982 (ratio: 0.19982)
100000 bigint correlated 5 2 1 off 19.847
100000 bigint correlated 5 2 1 on 20.875 -0.05
100000 bigint correlated 5 2 2 off 19.505
100000 bigint correlated 5 2 2 on 21.086 -0.07
100000 bigint correlated 5 2 3 off 20.116
100000 bigint correlated 5 2 3 on 20.975 -0.04
distinct:  19983 (ratio: 0.19983)
100000 bigint correlated 5 5 1 off 25.131
100000 bigint correlated 5 5 1 on 25.535 -0.02
100000 bigint correlated 5 5 2 off 24.440
100000 bigint correlated 5 5 2 on 25.291 -0.03
100000 bigint correlated 5 5 3 off 24.452
100000 bigint correlated 5 5 3 on 25.259 -0.03
distinct:  19979 (ratio: 0.19979)
100000 bigint correlated 5 8 1 off 27.109
100000 bigint correlated 5 8 1 on 27.147 -0.00
100000 bigint correlated 5 8 2 off 26.385
100000 bigint correlated 5 8 2 on 27.198 -0.03
100000 bigint correlated 5 8 3 off 26.223
100000 bigint correlated 5 8 3 on 27.316 -0.04
distinct:  20001 (ratio: 0.20001)
100000 bigint sequential 5 2 1 off 12.419
100000 bigint sequential 5 2 1 on 12.475 -0.00
100000 bigint sequential 5 2 2 off 12.432
100000 bigint sequential 5 2 2 on 12.392 0.00
100000 bigint sequential 5 2 3 off 12.279
100000 bigint sequential 5 2 3 on 12.303 -0.00
distinct:  20001 (ratio: 0.20001)
100000 bigint sequential 5 5 1 off 15.914
100000 bigint sequential 5 5 1 on 16.055 -0.01
100000 bigint sequential 5 5 2 off 15.908
100000 bigint sequential 5 5 2 on 16.634 -0.04
100000 bigint sequential 5 5 3 off 16.285
100000 bigint sequential 5 5 3 on 16.046 0.01
distinct:  20001 (ratio: 0.20001)
100000 bigint sequential 5 8 1 off 19.391
100000 bigint sequential 5 8 1 on 18.985 0.02
100000 bigint sequential 5 8 2 off 19.215
100000 bigint sequential 5 8 2 on 19.211 0.00
100000 bigint sequential 5 8 3 off 19.388
100000 bigint sequential 5 8 3 on 19.445 -0.00
distinct:  10000 (ratio: 0.1)
100000 bigint random 10 2 1 off 31.411
100000 bigint random 10 2 1 on 31.417 -0.00
100000 bigint random 10 2 2 off 30.198
100000 bigint random 10 2 2 on 31.350 -0.04
100000 bigint random 10 2 3 off 30.285
100000 bigint random 10 2 3 on 31.443 -0.04
distinct:  10001 (ratio: 0.10001)
100000 bigint random 10 5 1 off 34.526
100000 bigint random 10 5 1 on 33.774 0.02
100000 bigint random 10 5 2 off 32.102
100000 bigint random 10 5 2 on 33.255 -0.03
100000 bigint random 10 5 3 off 32.044
100000 bigint random 10 5 3 on 33.036 -0.03
distinct:  10001 (ratio: 0.10001)
100000 bigint random 10 8 1 off 37.055
100000 bigint random 10 8 1 on 35.649 0.04
100000 bigint random 10 8 2 off 33.783
100000 bigint random 10 8 2 on 34.935 -0.03
100000 bigint random 10 8 3 off 33.840
100000 bigint random 10 8 3 on 34.983 -0.03
distinct:  10001 (ratio: 0.10001)
100000 bigint correlated 10 2 1 off 20.207
100000 bigint correlated 10 2 1 on 21.779 -0.07
100000 bigint correlated 10 2 2 off 19.873
100000 bigint correlated 10 2 2 on 21.731 -0.09
100000 bigint correlated 10 2 3 off 19.740
100000 bigint correlated 10 2 3 on 21.687 -0.09
distinct:  10002 (ratio: 0.10002)
100000 bigint correlated 10 5 1 off 28.671
100000 bigint correlated 10 5 1 on 29.276 -0.02
100000 bigint correlated 10 5 2 off 28.228
100000 bigint correlated 10 5 2 on 29.582 -0.05
100000 bigint correlated 10 5 3 off 28.403
100000 bigint correlated 10 5 3 on 28.937 -0.02
distinct:  10001 (ratio: 0.10001)
100000 bigint correlated 10 8 1 off 32.141
100000 bigint correlated 10 8 1 on 32.070 0.00
100000 bigint correlated 10 8 2 off 30.846
100000 bigint correlated 10 8 2 on 31.631 -0.02
100000 bigint correlated 10 8 3 off 30.828
100000 bigint correlated 10 8 3 on 31.365 -0.02
distinct:  10001 (ratio: 0.10001)
100000 bigint sequential 10 2 1 off 12.664
100000 bigint sequential 10 2 1 on 12.684 -0.00
100000 bigint sequential 10 2 2 off 12.504
100000 bigint sequential 10 2 2 on 12.754 -0.02
100000 bigint sequential 10 2 3 off 12.556
100000 bigint sequential 10 2 3 on 12.674 -0.01
distinct:  10001 (ratio: 0.10001)
100000 bigint sequential 10 5 1 off 16.140
100000 bigint sequential 10 5 1 on 16.414 -0.02
100000 bigint sequential 10 5 2 off 15.965
100000 bigint sequential 10 5 2 on 16.088 -0.01
100000 bigint sequential 10 5 3 off 15.936
100000 bigint sequential 10 5 3 on 16.097 -0.01
distinct:  10001 (ratio: 0.10001)
100000 bigint sequential 10 8 1 off 19.899
100000 bigint sequential 10 8 1 on 19.705 0.01
100000 bigint sequential 10 8 2 off 19.669
100000 bigint sequential 10 8 2 on 19.537 0.01
100000 bigint sequential 10 8 3 off 19.640
100000 bigint sequential 10 8 3 on 19.654 -0.00
distinct:   5001 (ratio: 0.05001)
100000 bigint random 20 2 1 off 33.083
100000 bigint random 20 2 1 on 32.201 0.03
100000 bigint random 20 2 2 off 32.061
100000 bigint random 20 2 2 on 32.159 -0.00
100000 bigint random 20 2 3 off 32.641
100000 bigint random 20 2 3 on 32.203 0.01
distinct:   5001 (ratio: 0.05001)
100000 bigint random 20 5 1 off 35.525
100000 bigint random 20 5 1 on 34.112 0.04
100000 bigint random 20 5 2 off 33.624
100000 bigint random 20 5 2 on 33.850 -0.01
100000 bigint random 20 5 3 off 33.587
100000 bigint random 20 5 3 on 33.645 -0.00
distinct:   5001 (ratio: 0.05001)
100000 bigint random 20 8 1 off 38.996
100000 bigint random 20 8 1 on 36.515 0.07
100000 bigint random 20 8 2 off 35.641
100000 bigint random 20 8 2 on 35.624 0.00
100000 bigint random 20 8 3 off 36.356
100000 bigint random 20 8 3 on 36.063 0.01
distinct:   5002 (ratio: 0.05002)
100000 bigint correlated 20 2 1 off 19.728
100000 bigint correlated 20 2 1 on 20.529 -0.04
100000 bigint correlated 20 2 2 off 19.300
100000 bigint correlated 20 2 2 on 20.455 -0.06
100000 bigint correlated 20 2 3 off 19.398
100000 bigint correlated 20 2 3 on 20.569 -0.06
distinct:   5002 (ratio: 0.05002)
100000 bigint correlated 20 5 1 off 32.709
100000 bigint correlated 20 5 1 on 31.271 0.05
100000 bigint correlated 20 5 2 off 32.360
100000 bigint correlated 20 5 2 on 31.124 0.04
100000 bigint correlated 20 5 3 off 32.143
100000 bigint correlated 20 5 3 on 31.284 0.03
distinct:   5001 (ratio: 0.05001)
100000 bigint correlated 20 8 1 off 37.441
100000 bigint correlated 20 8 1 on 34.674 0.08
100000 bigint correlated 20 8 2 off 36.492
100000 bigint correlated 20 8 2 on 34.371 0.06
100000 bigint correlated 20 8 3 off 36.336
100000 bigint correlated 20 8 3 on 34.273 0.06
distinct:   5001 (ratio: 0.05001)
100000 bigint sequential 20 2 1 off 12.658
100000 bigint sequential 20 2 1 on 12.687 -0.00
100000 bigint sequential 20 2 2 off 12.529
100000 bigint sequential 20 2 2 on 12.617 -0.01
100000 bigint sequential 20 2 3 off 12.511
100000 bigint sequential 20 2 3 on 12.686 -0.01
distinct:   5001 (ratio: 0.05001)
100000 bigint sequential 20 5 1 off 16.117
100000 bigint sequential 20 5 1 on 16.122 -0.00
100000 bigint sequential 20 5 2 off 16.062
100000 bigint sequential 20 5 2 on 16.431 -0.02
100000 bigint sequential 20 5 3 off 16.185
100000 bigint sequential 20 5 3 on 16.244 -0.00
distinct:   5001 (ratio: 0.05001)
100000 bigint sequential 20 8 1 off 20.092
100000 bigint sequential 20 8 1 on 19.926 0.01
100000 bigint sequential 20 8 2 off 20.137
100000 bigint sequential 20 8 2 on 19.886 0.01
100000 bigint sequential 20 8 3 off 19.866
100000 bigint sequential 20 8 3 on 20.188 -0.02
distinct:   2001 (ratio: 0.02001)
100000 bigint random 50 2 1 off 35.593
100000 bigint random 50 2 1 on 33.941 0.05
100000 bigint random 50 2 2 off 34.375
100000 bigint random 50 2 2 on 33.791 0.02
100000 bigint random 50 2 3 off 34.387
100000 bigint random 50 2 3 on 33.680 0.02
distinct:   2001 (ratio: 0.02001)
100000 bigint random 50 5 1 off 38.355
100000 bigint random 50 5 1 on 35.745 0.07
100000 bigint random 50 5 2 off 36.270
100000 bigint random 50 5 2 on 35.304 0.03
100000 bigint random 50 5 3 off 36.031
100000 bigint random 50 5 3 on 35.500 0.01
distinct:   2001 (ratio: 0.02001)
100000 bigint random 50 8 1 off 41.842
100000 bigint random 50 8 1 on 38.358 0.09
100000 bigint random 50 8 2 off 38.824
100000 bigint random 50 8 2 on 37.950 0.02
100000 bigint random 50 8 3 off 37.786
100000 bigint random 50 8 3 on 37.587 0.01
distinct:   2002 (ratio: 0.02002)
100000 bigint correlated 50 2 1 off 19.028
100000 bigint correlated 50 2 1 on 19.496 -0.02
100000 bigint correlated 50 2 2 off 18.490
100000 bigint correlated 50 2 2 on 19.490 -0.05
100000 bigint correlated 50 2 3 off 18.516
100000 bigint correlated 50 2 3 on 19.286 -0.04
distinct:   2001 (ratio: 0.02001)
100000 bigint correlated 50 5 1 off 37.357
100000 bigint correlated 50 5 1 on 35.159 0.06
100000 bigint correlated 50 5 2 off 36.640
100000 bigint correlated 50 5 2 on 33.908 0.08
100000 bigint correlated 50 5 3 off 36.212
100000 bigint correlated 50 5 3 on 33.680 0.08
distinct:   2002 (ratio: 0.02002)
100000 bigint correlated 50 8 1 off 45.033
100000 bigint correlated 50 8 1 on 39.434 0.14
100000 bigint correlated 50 8 2 off 43.707
100000 bigint correlated 50 8 2 on 39.090 0.12
100000 bigint correlated 50 8 3 off 43.766
100000 bigint correlated 50 8 3 on 39.276 0.11
distinct:   2001 (ratio: 0.02001)
100000 bigint sequential 50 2 1 off 12.645
100000 bigint sequential 50 2 1 on 12.751 -0.01
100000 bigint sequential 50 2 2 off 12.551
100000 bigint sequential 50 2 2 on 12.663 -0.01
100000 bigint sequential 50 2 3 off 12.553
100000 bigint sequential 50 2 3 on 12.759 -0.02
distinct:   2001 (ratio: 0.02001)
100000 bigint sequential 50 5 1 off 16.431
100000 bigint sequential 50 5 1 on 16.281 0.01
100000 bigint sequential 50 5 2 off 16.130
100000 bigint sequential 50 5 2 on 16.283 -0.01
100000 bigint sequential 50 5 3 off 16.069
100000 bigint sequential 50 5 3 on 16.310 -0.01
distinct:   2001 (ratio: 0.02001)
100000 bigint sequential 50 8 1 off 20.281
100000 bigint sequential 50 8 1 on 20.198 0.00
100000 bigint sequential 50 8 2 off 20.302
100000 bigint sequential 50 8 2 on 24.483 -0.17
100000 bigint sequential 50 8 3 off 20.023
100000 bigint sequential 50 8 3 on 19.952 0.00
distinct:     11 (ratio: 0.00011)
100000 bigint random 10000 2 1 off 23.394
100000 bigint random 10000 2 1 on 22.544 0.04
100000 bigint random 10000 2 2 off 22.950
100000 bigint random 10000 2 2 on 22.380 0.03
100000 bigint random 10000 2 3 off 22.693
100000 bigint random 10000 2 3 on 22.268 0.02
distinct:     11 (ratio: 0.00011)
100000 bigint random 10000 5 1 off 70.092
100000 bigint random 10000 5 1 on 45.360 0.55
100000 bigint random 10000 5 2 off 69.492
100000 bigint random 10000 5 2 on 44.896 0.55
100000 bigint random 10000 5 3 off 69.396
100000 bigint random 10000 5 3 on 44.865 0.55
distinct:     11 (ratio: 0.00011)
100000 bigint random 10000 8 1 off 76.241
100000 bigint random 10000 8 1 on 48.648 0.57
100000 bigint random 10000 8 2 off 75.156
100000 bigint random 10000 8 2 on 48.753 0.54
100000 bigint random 10000 8 3 off 75.440
100000 bigint random 10000 8 3 on 50.287 0.50
distinct:     11 (ratio: 0.00011)
100000 bigint correlated 10000 2 1 off 16.319
100000 bigint correlated 10000 2 1 on 16.166 0.01
100000 bigint correlated 10000 2 2 off 16.140
100000 bigint correlated 10000 2 2 on 16.006 0.01
100000 bigint correlated 10000 2 3 off 16.371
100000 bigint correlated 10000 2 3 on 16.218 0.01
distinct:     12 (ratio: 0.00012)
100000 bigint correlated 10000 5 1 off 33.004
100000 bigint correlated 10000 5 1 on 27.364 0.21
100000 bigint correlated 10000 5 2 off 32.664
100000 bigint correlated 10000 5 2 on 27.140 0.20
100000 bigint correlated 10000 5 3 off 32.645
100000 bigint correlated 10000 5 3 on 27.356 0.19
distinct:     11 (ratio: 0.00011)
100000 bigint correlated 10000 8 1 off 57.801
100000 bigint correlated 10000 8 1 on 39.218 0.47
100000 bigint correlated 10000 8 2 off 57.393
100000 bigint correlated 10000 8 2 on 39.243 0.46
100000 bigint correlated 10000 8 3 off 57.453
100000 bigint correlated 10000 8 3 on 39.522 0.45
distinct:     11 (ratio: 0.00011)
100000 bigint sequential 10000 2 1 off 12.637
100000 bigint sequential 10000 2 1 on 12.714 -0.01
100000 bigint sequential 10000 2 2 off 12.476
100000 bigint sequential 10000 2 2 on 12.797 -0.03
100000 bigint sequential 10000 2 3 off 12.651
100000 bigint sequential 10000 2 3 on 12.743 -0.01
distinct:     11 (ratio: 0.00011)
100000 bigint sequential 10000 5 1 off 16.724
100000 bigint sequential 10000 5 1 on 16.550 0.01
100000 bigint sequential 10000 5 2 off 16.231
100000 bigint sequential 10000 5 2 on 16.375 -0.01
100000 bigint sequential 10000 5 3 off 16.237
100000 bigint sequential 10000 5 3 on 16.621 -0.02
distinct:     11 (ratio: 0.00011)
100000 bigint sequential 10000 8 1 off 20.378
100000 bigint sequential 10000 8 1 on 20.242 0.01
100000 bigint sequential 10000 8 2 off 20.459
100000 bigint sequential 10000 8 2 on 20.291 0.01
100000 bigint sequential 10000 8 3 off 20.025
100000 bigint sequential 10000 8 3 on 20.193 -0.01
distinct:  100000 (ratio: 1)
100000 timestamptz random 1 2 1 off 24.499
100000 timestamptz random 1 2 1 on 25.961 -0.06
100000 timestamptz random 1 2 2 off 27.789
100000 timestamptz random 1 2 2 on 26.530 0.05
100000 timestamptz random 1 2 3 off 23.203
100000 timestamptz random 1 2 3 on 26.122 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz random 1 5 1 off 26.882
100000 timestamptz random 1 5 1 on 28.823 -0.07
100000 timestamptz random 1 5 2 off 25.234
100000 timestamptz random 1 5 2 on 28.213 -0.11
100000 timestamptz random 1 5 3 off 25.807
100000 timestamptz random 1 5 3 on 28.279 -0.09
distinct:  100000 (ratio: 1)
100000 timestamptz random 1 8 1 off 29.769
100000 timestamptz random 1 8 1 on 31.508 -0.06
100000 timestamptz random 1 8 2 off 27.527
100000 timestamptz random 1 8 2 on 29.930 -0.08
100000 timestamptz random 1 8 3 off 26.723
100000 timestamptz random 1 8 3 on 29.714 -0.10
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 1 2 1 off 11.441
100000 timestamptz correlated 1 2 1 on 11.304 0.01
100000 timestamptz correlated 1 2 2 off 11.265
100000 timestamptz correlated 1 2 2 on 11.256 0.00
100000 timestamptz correlated 1 2 3 off 11.119
100000 timestamptz correlated 1 2 3 on 11.260 -0.01
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 1 5 1 off 12.522
100000 timestamptz correlated 1 5 1 on 14.830 -0.16
100000 timestamptz correlated 1 5 2 off 12.563
100000 timestamptz correlated 1 5 2 on 12.838 -0.02
100000 timestamptz correlated 1 5 3 off 12.835
100000 timestamptz correlated 1 5 3 on 12.899 -0.00
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 1 8 1 off 14.176
100000 timestamptz correlated 1 8 1 on 14.074 0.01
100000 timestamptz correlated 1 8 2 off 13.955
100000 timestamptz correlated 1 8 2 on 13.804 0.01
100000 timestamptz correlated 1 8 3 off 13.807
100000 timestamptz correlated 1 8 3 on 13.757 0.00
distinct:  100000 (ratio: 1)
100000 timestamptz sequential 1 2 1 off 11.400
100000 timestamptz sequential 1 2 1 on 11.296 0.01
100000 timestamptz sequential 1 2 2 off 11.103
100000 timestamptz sequential 1 2 2 on 11.315 -0.02
100000 timestamptz sequential 1 2 3 off 11.372
100000 timestamptz sequential 1 2 3 on 11.247 0.01
distinct:  100000 (ratio: 1)
100000 timestamptz sequential 1 5 1 off 12.641
100000 timestamptz sequential 1 5 1 on 12.557 0.01
100000 timestamptz sequential 1 5 2 off 12.412
100000 timestamptz sequential 1 5 2 on 12.604 -0.02
100000 timestamptz sequential 1 5 3 off 12.629
100000 timestamptz sequential 1 5 3 on 12.482 0.01
distinct:  100000 (ratio: 1)
100000 timestamptz sequential 1 8 1 off 14.219
100000 timestamptz sequential 1 8 1 on 14.198 0.00
100000 timestamptz sequential 1 8 2 off 13.885
100000 timestamptz sequential 1 8 2 on 14.077 -0.01
100000 timestamptz sequential 1 8 3 off 13.835
100000 timestamptz sequential 1 8 3 on 13.958 -0.01
distinct:  100000 (ratio: 1)
100000 timestamptz random 5 2 1 off 24.566
100000 timestamptz random 5 2 1 on 26.225 -0.06
100000 timestamptz random 5 2 2 off 23.009
100000 timestamptz random 5 2 2 on 27.175 -0.15
100000 timestamptz random 5 2 3 off 23.924
100000 timestamptz random 5 2 3 on 26.744 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz random 5 5 1 off 26.925
100000 timestamptz random 5 5 1 on 28.495 -0.06
100000 timestamptz random 5 5 2 off 25.025
100000 timestamptz random 5 5 2 on 28.078 -0.11
100000 timestamptz random 5 5 3 off 24.948
100000 timestamptz random 5 5 3 on 27.982 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz random 5 8 1 off 29.986
100000 timestamptz random 5 8 1 on 31.627 -0.05
100000 timestamptz random 5 8 2 off 27.619
100000 timestamptz random 5 8 2 on 30.111 -0.08
100000 timestamptz random 5 8 3 off 27.075
100000 timestamptz random 5 8 3 on 30.035 -0.10
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 5 2 1 off 16.200
100000 timestamptz correlated 5 2 1 on 17.847 -0.09
100000 timestamptz correlated 5 2 2 off 15.877
100000 timestamptz correlated 5 2 2 on 17.865 -0.11
100000 timestamptz correlated 5 2 3 off 15.894
100000 timestamptz correlated 5 2 3 on 18.231 -0.13
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 5 5 1 off 17.516
100000 timestamptz correlated 5 5 1 on 19.130 -0.08
100000 timestamptz correlated 5 5 2 off 17.759
100000 timestamptz correlated 5 5 2 on 19.495 -0.09
100000 timestamptz correlated 5 5 3 off 17.232
100000 timestamptz correlated 5 5 3 on 19.209 -0.10
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 5 8 1 off 18.923
100000 timestamptz correlated 5 8 1 on 20.525 -0.08
100000 timestamptz correlated 5 8 2 off 18.581
100000 timestamptz correlated 5 8 2 on 20.362 -0.09
100000 timestamptz correlated 5 8 3 off 19.343
100000 timestamptz correlated 5 8 3 on 20.964 -0.08
distinct:  20001 (ratio: 0.20001)
100000 timestamptz sequential 5 2 1 off 12.371
100000 timestamptz sequential 5 2 1 on 12.373 -0.00
100000 timestamptz sequential 5 2 2 off 12.234
100000 timestamptz sequential 5 2 2 on 12.458 -0.02
100000 timestamptz sequential 5 2 3 off 12.203
100000 timestamptz sequential 5 2 3 on 12.408 -0.02
distinct:  20001 (ratio: 0.20001)
100000 timestamptz sequential 5 5 1 off 15.928
100000 timestamptz sequential 5 5 1 on 15.929 -0.00
100000 timestamptz sequential 5 5 2 off 15.726
100000 timestamptz sequential 5 5 2 on 15.689 0.00
100000 timestamptz sequential 5 5 3 off 15.637
100000 timestamptz sequential 5 5 3 on 15.669 -0.00
distinct:  20001 (ratio: 0.20001)
100000 timestamptz sequential 5 8 1 off 19.553
100000 timestamptz sequential 5 8 1 on 19.205 0.02
100000 timestamptz sequential 5 8 2 off 19.375
100000 timestamptz sequential 5 8 2 on 19.357 0.00
100000 timestamptz sequential 5 8 3 off 19.273
100000 timestamptz sequential 5 8 3 on 19.327 -0.00
distinct:  100000 (ratio: 1)
100000 timestamptz random 10 2 1 off 24.941
100000 timestamptz random 10 2 1 on 26.559 -0.06
100000 timestamptz random 10 2 2 off 23.115
100000 timestamptz random 10 2 2 on 26.369 -0.12
100000 timestamptz random 10 2 3 off 23.411
100000 timestamptz random 10 2 3 on 26.329 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz random 10 5 1 off 26.879
100000 timestamptz random 10 5 1 on 29.071 -0.08
100000 timestamptz random 10 5 2 off 25.529
100000 timestamptz random 10 5 2 on 28.218 -0.10
100000 timestamptz random 10 5 3 off 25.251
100000 timestamptz random 10 5 3 on 29.824 -0.15
distinct:  100000 (ratio: 1)
100000 timestamptz random 10 8 1 off 30.004
100000 timestamptz random 10 8 1 on 31.325 -0.04
100000 timestamptz random 10 8 2 off 27.484
100000 timestamptz random 10 8 2 on 30.504 -0.10
100000 timestamptz random 10 8 3 off 28.611
100000 timestamptz random 10 8 3 on 31.316 -0.09
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 10 2 1 off 16.472
100000 timestamptz correlated 10 2 1 on 18.417 -0.11
100000 timestamptz correlated 10 2 2 off 16.295
100000 timestamptz correlated 10 2 2 on 18.412 -0.11
100000 timestamptz correlated 10 2 3 off 16.355
100000 timestamptz correlated 10 2 3 on 18.441 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 10 5 1 off 17.977
100000 timestamptz correlated 10 5 1 on 19.840 -0.09
100000 timestamptz correlated 10 5 2 off 17.736
100000 timestamptz correlated 10 5 2 on 19.647 -0.10
100000 timestamptz correlated 10 5 3 off 17.541
100000 timestamptz correlated 10 5 3 on 19.681 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 10 8 1 off 20.212
100000 timestamptz correlated 10 8 1 on 21.605 -0.06
100000 timestamptz correlated 10 8 2 off 19.125
100000 timestamptz correlated 10 8 2 on 21.525 -0.11
100000 timestamptz correlated 10 8 3 off 19.442
100000 timestamptz correlated 10 8 3 on 21.474 -0.09
distinct:  10001 (ratio: 0.10001)
100000 timestamptz sequential 10 2 1 off 12.704
100000 timestamptz sequential 10 2 1 on 12.729 -0.00
100000 timestamptz sequential 10 2 2 off 12.576
100000 timestamptz sequential 10 2 2 on 12.841 -0.02
100000 timestamptz sequential 10 2 3 off 12.554
100000 timestamptz sequential 10 2 3 on 12.621 -0.01
distinct:  10001 (ratio: 0.10001)
100000 timestamptz sequential 10 5 1 off 16.299
100000 timestamptz sequential 10 5 1 on 16.552 -0.02
100000 timestamptz sequential 10 5 2 off 16.207
100000 timestamptz sequential 10 5 2 on 16.396 -0.01
100000 timestamptz sequential 10 5 3 off 16.248
100000 timestamptz sequential 10 5 3 on 16.253 -0.00
distinct:  10001 (ratio: 0.10001)
100000 timestamptz sequential 10 8 1 off 19.977
100000 timestamptz sequential 10 8 1 on 19.655 0.02
100000 timestamptz sequential 10 8 2 off 19.794
100000 timestamptz sequential 10 8 2 on 19.764 0.00
100000 timestamptz sequential 10 8 3 off 19.742
100000 timestamptz sequential 10 8 3 on 19.785 -0.00
distinct:  100000 (ratio: 1)
100000 timestamptz random 20 2 1 off 24.708
100000 timestamptz random 20 2 1 on 26.314 -0.06
100000 timestamptz random 20 2 2 off 22.978
100000 timestamptz random 20 2 2 on 26.135 -0.12
100000 timestamptz random 20 2 3 off 23.235
100000 timestamptz random 20 2 3 on 26.198 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz random 20 5 1 off 26.859
100000 timestamptz random 20 5 1 on 29.993 -0.10
100000 timestamptz random 20 5 2 off 25.676
100000 timestamptz random 20 5 2 on 28.275 -0.09
100000 timestamptz random 20 5 3 off 25.538
100000 timestamptz random 20 5 3 on 28.195 -0.09
distinct:  100000 (ratio: 1)
100000 timestamptz random 20 8 1 off 30.465
100000 timestamptz random 20 8 1 on 32.956 -0.08
100000 timestamptz random 20 8 2 off 28.899
100000 timestamptz random 20 8 2 on 30.956 -0.07
100000 timestamptz random 20 8 3 off 27.614
100000 timestamptz random 20 8 3 on 30.189 -0.09
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 20 2 1 off 16.994
100000 timestamptz correlated 20 2 1 on 19.110 -0.11
100000 timestamptz correlated 20 2 2 off 16.871
100000 timestamptz correlated 20 2 2 on 18.912 -0.11
100000 timestamptz correlated 20 2 3 off 16.726
100000 timestamptz correlated 20 2 3 on 18.846 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 20 5 1 off 18.534
100000 timestamptz correlated 20 5 1 on 20.394 -0.09
100000 timestamptz correlated 20 5 2 off 18.201
100000 timestamptz correlated 20 5 2 on 20.441 -0.11
100000 timestamptz correlated 20 5 3 off 18.099
100000 timestamptz correlated 20 5 3 on 20.275 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 20 8 1 off 20.588
100000 timestamptz correlated 20 8 1 on 22.370 -0.08
100000 timestamptz correlated 20 8 2 off 20.089
100000 timestamptz correlated 20 8 2 on 21.841 -0.08
100000 timestamptz correlated 20 8 3 off 19.995
100000 timestamptz correlated 20 8 3 on 21.935 -0.09
distinct:   5001 (ratio: 0.05001)
100000 timestamptz sequential 20 2 1 off 12.785
100000 timestamptz sequential 20 2 1 on 12.796 -0.00
100000 timestamptz sequential 20 2 2 off 12.581
100000 timestamptz sequential 20 2 2 on 12.689 -0.01
100000 timestamptz sequential 20 2 3 off 12.536
100000 timestamptz sequential 20 2 3 on 12.662 -0.01
distinct:   5001 (ratio: 0.05001)
100000 timestamptz sequential 20 5 1 off 16.269
100000 timestamptz sequential 20 5 1 on 16.183 0.01
100000 timestamptz sequential 20 5 2 off 16.662
100000 timestamptz sequential 20 5 2 on 16.234 0.03
100000 timestamptz sequential 20 5 3 off 16.053
100000 timestamptz sequential 20 5 3 on 16.459 -0.02
distinct:   5001 (ratio: 0.05001)
100000 timestamptz sequential 20 8 1 off 20.044
100000 timestamptz sequential 20 8 1 on 19.844 0.01
100000 timestamptz sequential 20 8 2 off 19.961
100000 timestamptz sequential 20 8 2 on 19.763 0.01
100000 timestamptz sequential 20 8 3 off 20.417
100000 timestamptz sequential 20 8 3 on 20.434 -0.00
distinct:  100000 (ratio: 1)
100000 timestamptz random 50 2 1 off 24.307
100000 timestamptz random 50 2 1 on 26.112 -0.07
100000 timestamptz random 50 2 2 off 22.841
100000 timestamptz random 50 2 2 on 25.925 -0.12
100000 timestamptz random 50 2 3 off 22.987
100000 timestamptz random 50 2 3 on 26.061 -0.12
distinct:  100000 (ratio: 1)
100000 timestamptz random 50 5 1 off 27.570
100000 timestamptz random 50 5 1 on 28.677 -0.04
100000 timestamptz random 50 5 2 off 24.923
100000 timestamptz random 50 5 2 on 27.626 -0.10
100000 timestamptz random 50 5 3 off 24.709
100000 timestamptz random 50 5 3 on 29.236 -0.15
distinct:  100000 (ratio: 1)
100000 timestamptz random 50 8 1 off 29.836
100000 timestamptz random 50 8 1 on 30.927 -0.04
100000 timestamptz random 50 8 2 off 27.686
100000 timestamptz random 50 8 2 on 30.446 -0.09
100000 timestamptz random 50 8 3 off 27.711
100000 timestamptz random 50 8 3 on 30.429 -0.09
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 50 2 1 off 17.617
100000 timestamptz correlated 50 2 1 on 19.789 -0.11
100000 timestamptz correlated 50 2 2 off 17.340
100000 timestamptz correlated 50 2 2 on 19.692 -0.12
100000 timestamptz correlated 50 2 3 off 17.339
100000 timestamptz correlated 50 2 3 on 19.511 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 50 5 1 off 19.743
100000 timestamptz correlated 50 5 1 on 21.614 -0.09
100000 timestamptz correlated 50 5 2 off 19.051
100000 timestamptz correlated 50 5 2 on 21.016 -0.09
100000 timestamptz correlated 50 5 3 off 19.021
100000 timestamptz correlated 50 5 3 on 21.258 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 50 8 1 off 21.925
100000 timestamptz correlated 50 8 1 on 23.584 -0.07
100000 timestamptz correlated 50 8 2 off 20.782
100000 timestamptz correlated 50 8 2 on 22.926 -0.09
100000 timestamptz correlated 50 8 3 off 20.823
100000 timestamptz correlated 50 8 3 on 23.080 -0.10
distinct:   2001 (ratio: 0.02001)
100000 timestamptz sequential 50 2 1 off 12.631
100000 timestamptz sequential 50 2 1 on 12.861 -0.02
100000 timestamptz sequential 50 2 2 off 12.604
100000 timestamptz sequential 50 2 2 on 12.797 -0.02
100000 timestamptz sequential 50 2 3 off 12.483
100000 timestamptz sequential 50 2 3 on 13.053 -0.04
distinct:   2001 (ratio: 0.02001)
100000 timestamptz sequential 50 5 1 off 16.282
100000 timestamptz sequential 50 5 1 on 16.321 -0.00
100000 timestamptz sequential 50 5 2 off 16.167
100000 timestamptz sequential 50 5 2 on 16.481 -0.02
100000 timestamptz sequential 50 5 3 off 16.498
100000 timestamptz sequential 50 5 3 on 16.336 0.01
distinct:   2001 (ratio: 0.02001)
100000 timestamptz sequential 50 8 1 off 20.534
100000 timestamptz sequential 50 8 1 on 20.286 0.01
100000 timestamptz sequential 50 8 2 off 20.273
100000 timestamptz sequential 50 8 2 on 20.086 0.01
100000 timestamptz sequential 50 8 3 off 20.044
100000 timestamptz sequential 50 8 3 on 20.039 0.00
distinct:  100000 (ratio: 1)
100000 timestamptz random 10000 2 1 off 24.310
100000 timestamptz random 10000 2 1 on 26.161 -0.07
100000 timestamptz random 10000 2 2 off 22.992
100000 timestamptz random 10000 2 2 on 25.915 -0.11
100000 timestamptz random 10000 2 3 off 22.799
100000 timestamptz random 10000 2 3 on 26.373 -0.14
distinct:  100000 (ratio: 1)
100000 timestamptz random 10000 5 1 off 27.074
100000 timestamptz random 10000 5 1 on 28.569 -0.05
100000 timestamptz random 10000 5 2 off 24.785
100000 timestamptz random 10000 5 2 on 28.177 -0.12
100000 timestamptz random 10000 5 3 off 25.097
100000 timestamptz random 10000 5 3 on 28.168 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz random 10000 8 1 off 30.216
100000 timestamptz random 10000 8 1 on 31.680 -0.05
100000 timestamptz random 10000 8 2 off 27.367
100000 timestamptz random 10000 8 2 on 30.782 -0.11
100000 timestamptz random 10000 8 3 off 27.396
100000 timestamptz random 10000 8 3 on 30.073 -0.09
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 10000 2 1 off 22.411
100000 timestamptz correlated 10000 2 1 on 24.364 -0.08
100000 timestamptz correlated 10000 2 2 off 21.472
100000 timestamptz correlated 10000 2 2 on 24.484 -0.12
100000 timestamptz correlated 10000 2 3 off 21.488
100000 timestamptz correlated 10000 2 3 on 24.040 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 10000 5 1 off 25.523
100000 timestamptz correlated 10000 5 1 on 27.182 -0.06
100000 timestamptz correlated 10000 5 2 off 23.629
100000 timestamptz correlated 10000 5 2 on 26.046 -0.09
100000 timestamptz correlated 10000 5 3 off 23.136
100000 timestamptz correlated 10000 5 3 on 26.057 -0.11
distinct:  100000 (ratio: 1)
100000 timestamptz correlated 10000 8 1 off 28.703
100000 timestamptz correlated 10000 8 1 on 29.277 -0.02
100000 timestamptz correlated 10000 8 2 off 25.614
100000 timestamptz correlated 10000 8 2 on 28.097 -0.09
100000 timestamptz correlated 10000 8 3 off 25.056
100000 timestamptz correlated 10000 8 3 on 27.642 -0.09
distinct:     11 (ratio: 0.00011)
100000 timestamptz sequential 10000 2 1 off 12.676
100000 timestamptz sequential 10000 2 1 on 12.817 -0.01
100000 timestamptz sequential 10000 2 2 off 12.920
100000 timestamptz sequential 10000 2 2 on 12.657 0.02
100000 timestamptz sequential 10000 2 3 off 12.639
100000 timestamptz sequential 10000 2 3 on 12.731 -0.01
distinct:     11 (ratio: 0.00011)
100000 timestamptz sequential 10000 5 1 off 16.359
100000 timestamptz sequential 10000 5 1 on 16.454 -0.01
100000 timestamptz sequential 10000 5 2 off 16.194
100000 timestamptz sequential 10000 5 2 on 16.421 -0.01
100000 timestamptz sequential 10000 5 3 off 16.251
100000 timestamptz sequential 10000 5 3 on 16.420 -0.01
distinct:     11 (ratio: 0.00011)
100000 timestamptz sequential 10000 8 1 off 20.405
100000 timestamptz sequential 10000 8 1 on 20.698 -0.01
100000 timestamptz sequential 10000 8 2 off 20.350
100000 timestamptz sequential 10000 8 2 on 20.250 0.00
100000 timestamptz sequential 10000 8 3 off 20.074
100000 timestamptz sequential 10000 8 3 on 20.074 0.00
distinct:  63071 (ratio: 0.63071)
100000 text random 1 2 1 off 190.753
100000 text random 1 2 1 on 185.041 0.03
100000 text random 1 2 2 off 192.627
100000 text random 1 2 2 on 184.931 0.04
100000 text random 1 2 3 off 190.673
100000 text random 1 2 3 on 185.081 0.03
distinct:  63065 (ratio: 0.63065)
100000 text random 1 5 1 off 191.564
100000 text random 1 5 1 on 185.476 0.03
100000 text random 1 5 2 off 191.810
100000 text random 1 5 2 on 185.341 0.03
100000 text random 1 5 3 off 192.357
100000 text random 1 5 3 on 186.442 0.03
distinct:  63180 (ratio: 0.6318)
100000 text random 1 8 1 off 195.703
100000 text random 1 8 1 on 189.970 0.03
100000 text random 1 8 2 off 195.213
100000 text random 1 8 2 on 189.617 0.03
100000 text random 1 8 3 off 195.560
100000 text random 1 8 3 on 188.791 0.04
distinct:  74904 (ratio: 0.74904)
100000 text correlated 1 2 1 off 186.947
100000 text correlated 1 2 1 on 167.256 0.12
100000 text correlated 1 2 2 off 186.961
100000 text correlated 1 2 2 on 163.526 0.14
100000 text correlated 1 2 3 off 186.713
100000 text correlated 1 2 3 on 163.647 0.14
distinct:  74988 (ratio: 0.74988)
100000 text correlated 1 5 1 off 193.527
100000 text correlated 1 5 1 on 166.371 0.16
100000 text correlated 1 5 2 off 192.629
100000 text correlated 1 5 2 on 166.479 0.16
100000 text correlated 1 5 3 off 192.722
100000 text correlated 1 5 3 on 166.141 0.16
distinct:  75010 (ratio: 0.7501)
100000 text correlated 1 8 1 off 194.350
100000 text correlated 1 8 1 on 167.838 0.16
100000 text correlated 1 8 2 off 193.917
100000 text correlated 1 8 2 on 167.115 0.16
100000 text correlated 1 8 3 off 194.335
100000 text correlated 1 8 3 on 167.467 0.16
distinct:  100000 (ratio: 1)
100000 text sequential 1 2 1 off 194.517
100000 text sequential 1 2 1 on 191.285 0.02
100000 text sequential 1 2 2 off 195.325
100000 text sequential 1 2 2 on 191.346 0.02
100000 text sequential 1 2 3 off 194.835
100000 text sequential 1 2 3 on 191.167 0.02
distinct:  100000 (ratio: 1)
100000 text sequential 1 5 1 off 196.816
100000 text sequential 1 5 1 on 192.371 0.02
100000 text sequential 1 5 2 off 196.395
100000 text sequential 1 5 2 on 192.487 0.02
100000 text sequential 1 5 3 off 196.218
100000 text sequential 1 5 3 on 192.470 0.02
distinct:  100000 (ratio: 1)
100000 text sequential 1 8 1 off 197.322
100000 text sequential 1 8 1 on 193.357 0.02
100000 text sequential 1 8 2 off 197.665
100000 text sequential 1 8 2 on 193.500 0.02
100000 text sequential 1 8 3 off 197.108
100000 text sequential 1 8 3 on 193.520 0.02
distinct:  19864 (ratio: 0.19864)
100000 text random 5 2 1 off 190.741
100000 text random 5 2 1 on 173.501 0.10
100000 text random 5 2 2 off 193.866
100000 text random 5 2 2 on 172.080 0.13
100000 text random 5 2 3 off 189.720
100000 text random 5 2 3 on 172.155 0.10
distinct:  19887 (ratio: 0.19887)
100000 text random 5 5 1 off 192.855
100000 text random 5 5 1 on 174.520 0.11
100000 text random 5 5 2 off 192.238
100000 text random 5 5 2 on 174.077 0.10
100000 text random 5 5 3 off 192.257
100000 text random 5 5 3 on 174.652 0.10
distinct:  19854 (ratio: 0.19854)
100000 text random 5 8 1 off 197.406
100000 text random 5 8 1 on 176.978 0.12
100000 text random 5 8 2 off 194.368
100000 text random 5 8 2 on 176.662 0.10
100000 text random 5 8 3 off 194.816
100000 text random 5 8 3 on 177.181 0.10
distinct:  19975 (ratio: 0.19975)
100000 text correlated 5 2 1 off 147.379
100000 text correlated 5 2 1 on 138.080 0.07
100000 text correlated 5 2 2 off 147.636
100000 text correlated 5 2 2 on 137.926 0.07
100000 text correlated 5 2 3 off 147.715
100000 text correlated 5 2 3 on 138.017 0.07
distinct:  19987 (ratio: 0.19987)
100000 text correlated 5 5 1 off 175.960
100000 text correlated 5 5 1 on 156.711 0.12
100000 text correlated 5 5 2 off 175.972
100000 text correlated 5 5 2 on 157.334 0.12
100000 text correlated 5 5 3 off 176.343
100000 text correlated 5 5 3 on 157.173 0.12
distinct:  19988 (ratio: 0.19988)
100000 text correlated 5 8 1 off 181.171
100000 text correlated 5 8 1 on 159.759 0.13
100000 text correlated 5 8 2 off 181.702
100000 text correlated 5 8 2 on 160.746 0.13
100000 text correlated 5 8 3 off 181.508
100000 text correlated 5 8 3 on 160.563 0.13
distinct:  20001 (ratio: 0.20001)
100000 text sequential 5 2 1 off 122.287
100000 text sequential 5 2 1 on 108.189 0.13
100000 text sequential 5 2 2 off 122.285
100000 text sequential 5 2 2 on 108.503 0.13
100000 text sequential 5 2 3 off 122.980
100000 text sequential 5 2 3 on 108.327 0.14
distinct:  20001 (ratio: 0.20001)
100000 text sequential 5 5 1 off 166.750
100000 text sequential 5 5 1 on 126.507 0.32
100000 text sequential 5 5 2 off 166.713
100000 text sequential 5 5 2 on 126.151 0.32
100000 text sequential 5 5 3 off 167.072
100000 text sequential 5 5 3 on 126.191 0.32
distinct:  20001 (ratio: 0.20001)
100000 text sequential 5 8 1 off 244.994
100000 text sequential 5 8 1 on 154.299 0.59
100000 text sequential 5 8 2 off 245.190
100000 text sequential 5 8 2 on 154.175 0.59
100000 text sequential 5 8 3 off 244.479
100000 text sequential 5 8 3 on 154.499 0.58
distinct:  10000 (ratio: 0.1)
100000 text random 10 2 1 off 179.638
100000 text random 10 2 1 on 160.854 0.12
100000 text random 10 2 2 off 179.974
100000 text random 10 2 2 on 160.754 0.12
100000 text random 10 2 3 off 179.748
100000 text random 10 2 3 on 160.922 0.12
distinct:  10001 (ratio: 0.10001)
100000 text random 10 5 1 off 183.210
100000 text random 10 5 1 on 164.579 0.11
100000 text random 10 5 2 off 182.894
100000 text random 10 5 2 on 163.911 0.12
100000 text random 10 5 3 off 184.119
100000 text random 10 5 3 on 163.614 0.13
distinct:  10001 (ratio: 0.10001)
100000 text random 10 8 1 off 183.804
100000 text random 10 8 1 on 163.771 0.12
100000 text random 10 8 2 off 183.300
100000 text random 10 8 2 on 163.664 0.12
100000 text random 10 8 3 off 183.980
100000 text random 10 8 3 on 163.856 0.12
distinct:  10001 (ratio: 0.10001)
100000 text correlated 10 2 1 off 127.944
100000 text correlated 10 2 1 on 122.059 0.05
100000 text correlated 10 2 2 off 127.781
100000 text correlated 10 2 2 on 121.015 0.06
100000 text correlated 10 2 3 off 127.979
100000 text correlated 10 2 3 on 121.315 0.05
distinct:  10002 (ratio: 0.10002)
100000 text correlated 10 5 1 off 171.599
100000 text correlated 10 5 1 on 156.492 0.10
100000 text correlated 10 5 2 off 172.081
100000 text correlated 10 5 2 on 152.766 0.13
100000 text correlated 10 5 3 off 171.759
100000 text correlated 10 5 3 on 152.580 0.13
distinct:  10001 (ratio: 0.10001)
100000 text correlated 10 8 1 off 180.248
100000 text correlated 10 8 1 on 158.698 0.14
100000 text correlated 10 8 2 off 180.195
100000 text correlated 10 8 2 on 159.135 0.13
100000 text correlated 10 8 3 off 180.485
100000 text correlated 10 8 3 on 158.925 0.14
distinct:  10001 (ratio: 0.10001)
100000 text sequential 10 2 1 off 95.100
100000 text sequential 10 2 1 on 86.517 0.10
100000 text sequential 10 2 2 off 95.315
100000 text sequential 10 2 2 on 86.285 0.10
100000 text sequential 10 2 3 off 95.465
100000 text sequential 10 2 3 on 86.275 0.11
distinct:  10001 (ratio: 0.10001)
100000 text sequential 10 5 1 off 134.266
100000 text sequential 10 5 1 on 106.212 0.26
100000 text sequential 10 5 2 off 134.294
100000 text sequential 10 5 2 on 106.111 0.27
100000 text sequential 10 5 3 off 134.385
100000 text sequential 10 5 3 on 106.290 0.26
distinct:  10001 (ratio: 0.10001)
100000 text sequential 10 8 1 off 202.602
100000 text sequential 10 8 1 on 137.421 0.47
100000 text sequential 10 8 2 off 201.890
100000 text sequential 10 8 2 on 137.420 0.47
100000 text sequential 10 8 3 off 206.272
100000 text sequential 10 8 3 on 137.579 0.50
distinct:   5001 (ratio: 0.05001)
100000 text random 20 2 1 off 187.616
100000 text random 20 2 1 on 164.337 0.14
100000 text random 20 2 2 off 187.481
100000 text random 20 2 2 on 164.201 0.14
100000 text random 20 2 3 off 187.399
100000 text random 20 2 3 on 164.267 0.14
distinct:   5001 (ratio: 0.05001)
100000 text random 20 5 1 off 190.571
100000 text random 20 5 1 on 166.415 0.15
100000 text random 20 5 2 off 189.703
100000 text random 20 5 2 on 166.288 0.14
100000 text random 20 5 3 off 189.790
100000 text random 20 5 3 on 165.655 0.15
distinct:   5001 (ratio: 0.05001)
100000 text random 20 8 1 off 189.846
100000 text random 20 8 1 on 167.801 0.13
100000 text random 20 8 2 off 189.688
100000 text random 20 8 2 on 168.178 0.13
100000 text random 20 8 3 off 190.223
100000 text random 20 8 3 on 168.537 0.13
distinct:   5001 (ratio: 0.05001)
100000 text correlated 20 2 1 off 116.564
100000 text correlated 20 2 1 on 107.077 0.09
100000 text correlated 20 2 2 off 116.667
100000 text correlated 20 2 2 on 107.543 0.08
100000 text correlated 20 2 3 off 116.355
100000 text correlated 20 2 3 on 107.407 0.08
distinct:   5002 (ratio: 0.05002)
100000 text correlated 20 5 1 off 177.926
100000 text correlated 20 5 1 on 151.811 0.17
100000 text correlated 20 5 2 off 177.992
100000 text correlated 20 5 2 on 151.611 0.17
100000 text correlated 20 5 3 off 178.096
100000 text correlated 20 5 3 on 151.413 0.18
distinct:   5001 (ratio: 0.05001)
100000 text correlated 20 8 1 off 195.853
100000 text correlated 20 8 1 on 163.403 0.20
100000 text correlated 20 8 2 off 196.127
100000 text correlated 20 8 2 on 163.179 0.20
100000 text correlated 20 8 3 off 196.171
100000 text correlated 20 8 3 on 163.322 0.20
distinct:   5001 (ratio: 0.05001)
100000 text sequential 20 2 1 off 85.914
100000 text sequential 20 2 1 on 77.677 0.11
100000 text sequential 20 2 2 off 85.619
100000 text sequential 20 2 2 on 77.588 0.10
100000 text sequential 20 2 3 off 85.410
100000 text sequential 20 2 3 on 77.303 0.10
distinct:   5001 (ratio: 0.05001)
100000 text sequential 20 5 1 off 127.872
100000 text sequential 20 5 1 on 104.205 0.23
100000 text sequential 20 5 2 off 127.886
100000 text sequential 20 5 2 on 103.983 0.23
100000 text sequential 20 5 3 off 127.818
100000 text sequential 20 5 3 on 103.885 0.23
distinct:   5001 (ratio: 0.05001)
100000 text sequential 20 8 1 off 201.837
100000 text sequential 20 8 1 on 142.067 0.42
100000 text sequential 20 8 2 off 202.268
100000 text sequential 20 8 2 on 142.076 0.42
100000 text sequential 20 8 3 off 202.123
100000 text sequential 20 8 3 on 142.001 0.42
distinct:   2001 (ratio: 0.02001)
100000 text random 50 2 1 off 191.448
100000 text random 50 2 1 on 168.108 0.14
100000 text random 50 2 2 off 191.593
100000 text random 50 2 2 on 168.199 0.14
100000 text random 50 2 3 off 191.317
100000 text random 50 2 3 on 168.727 0.13
distinct:   2001 (ratio: 0.02001)
100000 text random 50 5 1 off 194.072
100000 text random 50 5 1 on 167.479 0.16
100000 text random 50 5 2 off 192.966
100000 text random 50 5 2 on 167.522 0.15
100000 text random 50 5 3 off 193.335
100000 text random 50 5 3 on 167.591 0.15
distinct:   2001 (ratio: 0.02001)
100000 text random 50 8 1 off 195.387
100000 text random 50 8 1 on 170.556 0.15
100000 text random 50 8 2 off 195.476
100000 text random 50 8 2 on 169.559 0.15
100000 text random 50 8 3 off 194.356
100000 text random 50 8 3 on 170.510 0.14
distinct:   2001 (ratio: 0.02001)
100000 text correlated 50 2 1 off 99.037
100000 text correlated 50 2 1 on 91.100 0.09
100000 text correlated 50 2 2 off 99.032
100000 text correlated 50 2 2 on 91.008 0.09
100000 text correlated 50 2 3 off 99.194
100000 text correlated 50 2 3 on 91.216 0.09
distinct:   2002 (ratio: 0.02002)
100000 text correlated 50 5 1 off 180.647
100000 text correlated 50 5 1 on 150.200 0.20
100000 text correlated 50 5 2 off 180.783
100000 text correlated 50 5 2 on 150.359 0.20
100000 text correlated 50 5 3 off 180.724
100000 text correlated 50 5 3 on 149.969 0.21
distinct:   2001 (ratio: 0.02001)
100000 text correlated 50 8 1 off 222.769
100000 text correlated 50 8 1 on 176.097 0.27
100000 text correlated 50 8 2 off 222.882
100000 text correlated 50 8 2 on 174.883 0.27
100000 text correlated 50 8 3 off 223.267
100000 text correlated 50 8 3 on 174.665 0.28
distinct:   2001 (ratio: 0.02001)
100000 text sequential 50 2 1 off 73.305
100000 text sequential 50 2 1 on 66.209 0.11
100000 text sequential 50 2 2 off 73.306
100000 text sequential 50 2 2 on 66.919 0.10
100000 text sequential 50 2 3 off 73.461
100000 text sequential 50 2 3 on 66.241 0.11
distinct:   2001 (ratio: 0.02001)
100000 text sequential 50 5 1 off 116.747
100000 text sequential 50 5 1 on 93.761 0.25
100000 text sequential 50 5 2 off 116.740
100000 text sequential 50 5 2 on 93.951 0.24
100000 text sequential 50 5 3 off 117.093
100000 text sequential 50 5 3 on 94.222 0.24
distinct:   2001 (ratio: 0.02001)
100000 text sequential 50 8 1 off 191.950
100000 text sequential 50 8 1 on 132.943 0.44
100000 text sequential 50 8 2 off 192.124
100000 text sequential 50 8 2 on 132.974 0.44
100000 text sequential 50 8 3 off 191.829
100000 text sequential 50 8 3 on 133.375 0.44
distinct:     11 (ratio: 0.00011)
100000 text random 10000 2 1 off 60.218
100000 text random 10000 2 1 on 50.359 0.20
100000 text random 10000 2 2 off 59.901
100000 text random 10000 2 2 on 50.127 0.19
100000 text random 10000 2 3 off 59.920
100000 text random 10000 2 3 on 50.335 0.19
distinct:     11 (ratio: 0.00011)
100000 text random 10000 5 1 off 283.095
100000 text random 10000 5 1 on 151.965 0.86
100000 text random 10000 5 2 off 283.481
100000 text random 10000 5 2 on 151.035 0.88
100000 text random 10000 5 3 off 282.849
100000 text random 10000 5 3 on 151.181 0.87
distinct:     11 (ratio: 0.00011)
100000 text random 10000 8 1 off 304.669
100000 text random 10000 8 1 on 157.524 0.93
100000 text random 10000 8 2 off 304.561
100000 text random 10000 8 2 on 157.867 0.93
100000 text random 10000 8 3 off 305.207
100000 text random 10000 8 3 on 158.259 0.93
distinct:     11 (ratio: 0.00011)
100000 text correlated 10000 2 1 off 36.482
100000 text correlated 10000 2 1 on 31.641 0.15
100000 text correlated 10000 2 2 off 37.040
100000 text correlated 10000 2 2 on 31.835 0.16
100000 text correlated 10000 2 3 off 36.538
100000 text correlated 10000 2 3 on 31.817 0.15
distinct:     11 (ratio: 0.00011)
100000 text correlated 10000 5 1 off 109.922
100000 text correlated 10000 5 1 on 67.383 0.63
100000 text correlated 10000 5 2 off 109.715
100000 text correlated 10000 5 2 on 67.369 0.63
100000 text correlated 10000 5 3 off 109.729
100000 text correlated 10000 5 3 on 67.483 0.63
distinct:     12 (ratio: 0.00012)
100000 text correlated 10000 8 1 off 267.642
100000 text correlated 10000 8 1 on 121.137 1.21
100000 text correlated 10000 8 2 off 267.737
100000 text correlated 10000 8 2 on 120.980 1.21
100000 text correlated 10000 8 3 off 267.692
100000 text correlated 10000 8 3 on 121.832 1.20
distinct:     11 (ratio: 0.00011)
100000 text sequential 10000 2 1 off 34.814
100000 text sequential 10000 2 1 on 21.838 0.59
100000 text sequential 10000 2 2 off 34.500
100000 text sequential 10000 2 2 on 21.789 0.58
100000 text sequential 10000 2 3 off 34.619
100000 text sequential 10000 2 3 on 21.981 0.57
distinct:     11 (ratio: 0.00011)
100000 text sequential 10000 5 1 off 89.689
100000 text sequential 10000 5 1 on 42.682 1.10
100000 text sequential 10000 5 2 off 90.288
100000 text sequential 10000 5 2 on 42.774 1.11
100000 text sequential 10000 5 3 off 89.744
100000 text sequential 10000 5 3 on 42.714 1.10
distinct:     11 (ratio: 0.00011)
100000 text sequential 10000 8 1 off 185.784
100000 text sequential 10000 8 1 on 71.730 1.59
100000 text sequential 10000 8 2 off 185.973
100000 text sequential 10000 8 2 on 71.527 1.60
100000 text sequential 10000 8 3 off 185.848
100000 text sequential 10000 8 3 on 71.793 1.59