JOB
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXY
1
median (ms)sqlite
2
query_nameimppg (default)
pg (geqo=off, shared_buffers=8gb)
sqlite
sqlite gives same results as pg/imp
imppg (default)
pg (geqo=off, shared_buffers=8gb)
sqlite
3
1a1.284686.95958.384714.7553141.28468TRUE1.005.426.53556.37
4
1b0.0159850.2660.4881253.446420.015985FALSE1.0016.6430.530.00
5
1c0.3103515.28556.06596.9119870.310351TRUE1.0017.0319.531923.34
6
1d0.01721650.29150.49951549.8064060.0172165FALSE1.0016.9329.010.00
7
2a49.3835528.513579.993226.97964849.3835TRUE1.0010.7011.744.60
8
2b48.5849514.4715574.173226.99205548.5849TRUE1.0010.5911.824.67
9
2c37.4952492.427562.608224.7444537.4952TRUE1.0013.1315.005.99
10
2d70.1156683.819717.823231.868584570.1156TRUE1.009.7510.243.31
11
3a97.2547176.975148.766362.17209397.2547FALSE1.001.821.530.00
12
3b53.558115.32108.6115.39626753.558FALSE1.002.152.030.00
13
3c127.755323.4915262.4962926.069721127.755FALSE1.002.532.050.00
14
4a53.8189114.16121.6081032.95887353.8189TRUE1.002.122.2619.19
15
4b52.736414.26817.775174.580549514.268TRUE3.701.001.2512.24
16
4c60.5068125.87126.952312.75079260.5068TRUE1.002.082.1038.22
17
5a17.799201.503205.613509.938073517.799TRUE1.0011.3211.5528.65
18
5b17.8056202.708204.72510.596629517.8056TRUE1.0011.3811.5028.68
19
5c32.7498251.058233.988594.54460332.7498FALSE1.007.677.140.00
20
6a2.072335.0617.26752.62879952.07233TRUE1.002.448.331.27
21
6b1126.02217.701179.11964.005839179.119TRUE6.291.221.000.36
22
6c0.03143950.5051.4430.2778170.0314395TRUE1.0016.0645.908.84
23
6d1175.376468.0334020.292320.372521175.37TRUE1.005.503.421.97
24
6e2.018967.08117.2793.0634852.01896TRUE1.003.518.561.52
25
6f2877.86784.5434420.672358.7750372877.8FALSE1.002.361.540.00
26
7a3.123666.52259.8884.7824313.12366TRUE1.002.093.171.53
27
7b2.021972.053.57150.8002642.02197TRUE1.001.011.770.40
28
7c539.6573381.37053290.452528.597343539.657FALSE1.006.276.100.00
29
8a22.23522988.8052001.7858.629902522.2352FALSE1.00134.4290.030.00
30
8b22.1367190.562161.02197.503470522.1367TRUE1.008.617.274.40
31
8c3441.318322.7269185.5815994.579423441.31FALSE1.002.422.670.00
32
8d363.9574598.3785408.182152.827988363.957TRUE1.0012.6314.865.92
33
9a247.809296.693303.3813814.648542247.809FALSE1.001.201.220.00
34
9b76.8055287.195294.729586.13801276.8055FALSE1.003.743.840.00
35
9c2461842.021779.264187.451232246FALSE1.007.497.230.00
36
9d823.3084976.9985369.515004.847525823.308TRUE1.006.056.526.08
37
10a384.634536.877388.7975716.062919384.634TRUE1.001.401.0114.86
38
10b95.6482183.611175.6785484.82495895.6482TRUE1.001.921.8457.34
39
10c163016897.3317214.2828601.11236897.331FALSE2.361.001.050.00
40
11a6.7784338.29556.2895450.25590456.77843FALSE1.005.658.300.00
41
11b6.5238220.1134.1675452.96344256.52382FALSE1.003.085.240.00
42
11c36.1806172.794186.621817.94309636.1806TRUE1.004.785.1650.25
43
11d37.4513160.855178.33121247.5305637.4513FALSE1.004.304.760.00
44
12a189.894300.378275.391567.782456189.894TRUE1.001.581.458.26
45
12b0.1057060.681.1381672.5417990.105706TRUE1.006.4310.7715822.58
46
12c284.6841383.031324.612382.885773284.684TRUE1.004.864.658.37
47
13a716.8642933.4443560.861779.096776716.864TRUE1.004.094.972.48
48
13b1162.991114.00351227.571079.1162441114.0035FALSE1.041.001.100.00
49
13c1143.241072.3661125.06953.95106051072.366TRUE1.071.001.050.89
50
13d3126.234858.84555442.634603.9182093126.23TRUE1.001.551.741.47
51
14a82.6094343.55261.023508.161617582.6094TRUE1.004.163.166.15
52
14b25.3515136.6515112.609273.50676625.3515TRUE1.005.394.4410.79
53
14c177.014746.622593.0891609.584826177.014TRUE1.004.223.359.09
54
15a626.037701.432679.6257930.997191626.037TRUE1.001.121.0912.67
55
15b1.594963.5638.1491168.4575071.59496TRUE1.002.235.11732.59
56
15c3664.9667.6546.47E+021.17E+06646.972FALSE5.661.031.000.00
57
15d2885.7787.2148.44E+021.20E+06787.214FALSE3.671.001.070.00
58
16a22.8953209.297174.93547.1028722.8953TRUE1.009.147.642.06
59
16b7830.3719933.5821178.310504.133577830.37FALSE1.002.552.700.00
60
16c500.2851629.881719.74806.040774500.285TRUE1.003.263.441.61
61
16d422.8211305.2671381.67620.568618422.821TRUE1.003.093.271.47
62
17a2211.4512908.54511364.65364.1760372211.45FALSE1.005.845.140.00
63
17b2090.588691.8784670.8311440.36552090.58FALSE1.004.162.230.00
64
17c2094.398355.9294392.3611418.454142094.39TRUE1.003.992.105.45
65
17d2119.218461.6894418.5111650.675032119.21FALSE1.003.992.080.00
66
17e5115.4413241.499103295375.408185115.44TRUE1.002.592.021.05
67
17f2335.8211355.1198133.3311748.351442335.82FALSE1.004.863.480.00
68
18a467.13510105.0767233.861574.11824467.135FALSE1.0021.6315.490.00
69
18b112.665259.153235.0510.2503385112.665FALSE1.002.302.090.00
70
19a436.075298.06301.2553881.014146298.06FALSE1.461.001.010.00
71
19b330.42210.752184.303746.163688184.303TRUE1.791.141.004.05
72
19c462.6111675.0161619.214969.113078462.611FALSE1.003.623.500.00
73
19d813.18715530.92416241.810587.21685813.187FALSE1.0019.1019.970.00
74
20a914.8553183.55552174.883589.691461914.855FALSE1.003.482.380.00
75
20b344.2262228.3251526.24900.5101145344.226TRUE1.006.474.432.62
76
20c284.2671211.642890.8892063.360925284.267TRUE1.004.263.137.26
77
21a13.79447.72572.671485.07335513.794FALSE1.003.465.270.00
78
21b12.552143.06957.3285481.06569212.5521FALSE1.003.434.570.00
79
21c13.8348.59663.346483.42616713.83FALSE1.003.514.580.00
80
22a171.597468.607411.7811059.349457171.597FALSE1.002.732.400.00
81
22b103.487300.765233.087715.962638103.487FALSE1.002.912.250.00
82
22c504.7692144.7791987.76873.302364504.769FALSE1.004.253.940.00
83
22d772.9981038.7235925.01414583.58136772.998FALSE1.001.341.200.00
84
23a112.413381.3295391.47496696.35452112.413TRUE1.003.393.48860.19
85
23b8.4452327.25743.981765.8680648.44523TRUE1.003.235.2190.69
86
23c250.884451.844378.682227790.9705250.884TRUE1.001.801.51907.95
87
24a222.797309.669541.2833996.475217222.797FALSE1.001.392.430.00
88
24b0.8116443.75483.2233952.9654890.811644FALSE1.004.62595.360.00
89
25a1073.983597.5382302.061486.3412071073.98TRUE1.003.352.141.38
90
25b41.2026378.8765286.85841.481120541.2026TRUE1.009.206.961.01
91
25c8180.0810246.6686186.315307.9318616186.31TRUE1.321.661.000.86
92
26a121.8341906.1071573.11304.715799121.834TRUE1.0015.6512.9110.71
93
26b24.01748.375119.445523.015134524.017TRUE1.002.014.9721.78
94
26c296.1171733.7231321.332118.861378296.117TRUE1.005.854.467.16
95
27a9.7103345.8956.237478.3536229.71033FALSE1.004.735.790.00
96
27b7.6542744.279560.613477.5920847.65427FALSE1.005.787.920.00
97
27c9.5234382.84633.318481.7289759.52343FALSE1.008.703.500.00
98
28a229.941017.9931079.371386.401539229.94FALSE1.004.434.690.00
99
28b120.712903.4725719.925521.4545765120.712TRUE1.007.485.964.32
100
28c156.569355.126879.482206.824854156.569FALSE1.002.275.620.00
Loading...
 
 
 
Sheet1
Chart2
Sheet3