
[MonetDB] create table: time = 0.013437509536743164 s 

[MonetDB] load data : time = 5.061709642410278 s 

[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "AIRLINE" = 'AA';
	time = 0.09611177444458008 s
	size=725984
	min time = 0.09018683433532715
	max time = 0.1128385066986084
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights;
	time = 0.3950206279754639 s
	size=5819079
	min time = 0.3915581703186035
	max time = 0.39906835556030273
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "YEAR" = 2015 AND "MONTH" = 12 AND "DAY" = 32 AND "DAY_OF_WEEK" = 4 AND "AIRLINE" = 'B6' AND "FLIGHT_NUMBER" = 839;
	time = 0.0018009662628173829 s
	size=0
	min time = 0.0015015602111816406
	max time = 0.0020003318786621094
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 5;
	time = 0.7486865520477295 s
	size=4862950
	min time = 0.6575868129730225
	max time = 0.8736352920532227
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 10;
	time = 0.6200555801391602 s
	size=3906644
	min time = 0.6124484539031982
	max time = 0.6453561782836914
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 15;
	time = 0.5115572929382324 s
	size=2948366
	min time = 0.48148274421691895
	max time = 0.5971188545227051
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 20;
	time = 0.32068700790405275 s
	size=1980764
	min time = 0.3067779541015625
	max time = 0.33039093017578125
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 25;
	time = 0.1696920394897461 s
	size=1032732
	min time = 0.1680755615234375
	max time = 0.1719212532043457
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 30;
	time = 0.043115663528442386 s
	size=103812
	min time = 0.042037248611450195
	max time = 0.04381895065307617
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 5 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 0.32133007049560547 s
	size=2083139
	min time = 0.31232738494873047
	max time = 0.33957886695861816
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 10 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 0.31490345001220704 s
	size=1661508
	min time = 0.30498504638671875
	max time = 0.33844852447509766
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 15 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 0.2369683265686035 s
	size=1267222
	min time = 0.22754311561584473
	max time = 0.24773311614990234
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 20 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 0.1570042133331299 s
	size=841926
	min time = 0.15090274810791016
	max time = 0.16793394088745117
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 25 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 0.08881125450134278 s
	size=432137
	min time = 0.08420419692993164
	max time = 0.09344696998596191
[MonetDB] requete (moyenne de 5) : SELECT * FROM flights WHERE "DAY" > 30 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 0.03609786033630371 s
	size=36537
	min time = 0.03387570381164551
	max time = 0.03899407386779785
[MonetDB] requete (moyenne de 10) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 5;
	time = 0.018897581100463866 s
	size=4862950
	min time = 0.017533302307128906
	max time = 0.019657611846923828
[MonetDB] requete (moyenne de 10) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 10;
	time = 0.02254457473754883 s
	size=3906644
	min time = 0.020551443099975586
	max time = 0.029211997985839844
[MonetDB] requete (moyenne de 10) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 15;
	time = 0.018437623977661133 s
	size=2948366
	min time = 0.0175933837890625
	max time = 0.019659042358398438
[MonetDB] requete (moyenne de 10) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 20;
	time = 0.012112188339233398 s
	size=1980764
	min time = 0.011019706726074219
	max time = 0.013511419296264648
[MonetDB] requete (moyenne de 10) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 25;
	time = 0.00843343734741211 s
	size=1032732
	min time = 0.007010221481323242
	max time = 0.009510278701782227
[MonetDB] requete (moyenne de 10) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 30;
	time = 0.0030538320541381838 s
	size=103812
	min time = 0.002510547637939453
	max time = 0.00400233268737793
[MonetDB] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 5;
	time = 2.1681085228919983 s
	size=-1
	min time = 0.9775278568267822
	max time = 4.6932268142700195
[MonetDB] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 5;
	time = 0.035223543643951416 s
	size=4862950
	min time = 0.03398919105529785
	max time = 0.038820505142211914
[MonetDB] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 2.5690563321113586 s
	size=4862950
	min time = 0.6531071662902832
	max time = 6.213240385055542
[MonetDB] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.02023303508758545 s
	size=-1
	min time = 0.003056049346923828
	max time = 0.06922650337219238
[MonetDB] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 10;
	time = 2.14550119638443 s
	size=-1
	min time = 1.6034998893737793
	max time = 2.7254722118377686
[MonetDB] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 10;
	time = 0.0680842399597168 s
	size=3906644
	min time = 0.05250358581542969
	max time = 0.09731912612915039
[MonetDB] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 4.1603575348854065 s
	size=3906644
	min time = 1.8543801307678223
	max time = 5.285855770111084
[MonetDB] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.04894465208053589 s
	size=-1
	min time = 0.003950834274291992
	max time = 0.12860536575317383
[MonetDB] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 15;
	time = 1.6534664034843445 s
	size=-1
	min time = 1.2284057140350342
	max time = 2.6042981147766113
[MonetDB] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 15;
	time = 0.10924053192138672 s
	size=2948366
	min time = 0.07727575302124023
	max time = 0.18244624137878418
[MonetDB] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 2.0993691086769104 s
	size=2948366
	min time = 1.41676664352417
	max time = 2.9635400772094727
[MonetDB] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.025338947772979736 s
	size=-1
	min time = 0.0040171146392822266
	max time = 0.04751873016357422
[MonetDB] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 20;
	time = 1.0088236927986145 s
	size=-1
	min time = 0.7524993419647217
	max time = 1.6036467552185059
[MonetDB] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 20;
	time = 0.04749953746795654 s
	size=1980764
	min time = 0.04703640937805176
	max time = 0.04798603057861328
[MonetDB] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 1.9249326586723328 s
	size=1980764
	min time = 0.9875540733337402
	max time = 4.652863502502441
[MonetDB] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.005171000957489014 s
	size=-1
	min time = 0.003998279571533203
	max time = 0.008174896240234375
[MonetDB] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 25;
	time = 0.8180756568908691 s
	size=-1
	min time = 0.3995649814605713
	max time = 1.980825662612915
[MonetDB] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 25;
	time = 0.04631072282791138 s
	size=1032732
	min time = 0.03054666519165039
	max time = 0.08844280242919922
[MonetDB] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 1.1345446109771729 s
	size=1032732
	min time = 0.6422145366668701
	max time = 1.942455768585205
[MonetDB] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.004741370677947998 s
	size=-1
	min time = 0.0039975643157958984
	max time = 0.0050389766693115234
[MonetDB] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 30;
	time = 0.20245015621185303 s
	size=-1
	min time = 0.10006976127624512
	max time = 0.341747522354126
[MonetDB] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 30;
	time = 0.013678133487701416 s
	size=103812
	min time = 0.010573625564575195
	max time = 0.01593160629272461
[MonetDB] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 0.05002093315124512 s
	size=103812
	min time = 0.041054725646972656
	max time = 0.05909991264343262
[MonetDB] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.004317820072174072 s
	size=-1
	min time = 0.0035097599029541016
	max time = 0.005509614944458008
[MonetDB] requete (moyenne de 1000) : INSERT INTO flights random value 
	time = 0.004249191761016845 s
	min time = 0.06317710876464844
	max time = 4.249191761016846

[PostgreSQL] create table: time = 0.0035054683685302734 s

[PostgreSQL] load data : time = 10.563302993774414 s

[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "AIRLINE" = 'AA';
	time = 0.9263111352920532 s
	size=725984
	min time = 0.8515989780426025
	max time = 1.001023292541504
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights;
	time = 7.0538564920425415 s
	size=5819079
	min time = 6.979717016220093
	max time = 7.12799596786499
[PostgreSQL] requete (moyenne de 5) : SELECT * FROM flights WHERE "YEAR" = 2015 AND "MONTH" = 12 AND "DAY" = 32 AND "DAY_OF_WEEK" = 4 AND "AIRLINE" = 'B6' AND "FLIGHT_NUMBER" = 839;
	time = 0.2627377510070801 s
	size=0
	min time = 0.25696229934692383
	max time = 0.2668905258178711
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 5;
	time = 5.757522225379944 s
	size=4862950
	min time = 5.752385854721069
	max time = 5.762658596038818
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 10;
	time = 4.720747470855713 s
	size=3906644
	min time = 4.713533878326416
	max time = 4.72796106338501
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 15;
	time = 3.6888608932495117 s
	size=2948366
	min time = 3.6670005321502686
	max time = 3.710721254348755
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 20;
	time = 2.548612117767334 s
	size=1980764
	min time = 2.5441837310791016
	max time = 2.5530405044555664
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 25;
	time = 1.5362998247146606 s
	size=1032732
	min time = 1.5161194801330566
	max time = 1.5564801692962646
[PostgreSQL] requete (moyenne de 3) : SELECT * FROM flights WHERE "DAY" > 30;
	time = 0.4836752414703369 s
	size=103812
	min time = 0.4809744358062744
	max time = 0.4876585006713867
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 5 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 2.350592255592346 s
	size=2083139
	min time = 2.349928140640259
	max time = 2.3512563705444336
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 10 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 1.876911997795105 s
	size=1661508
	min time = 1.8553428649902344
	max time = 1.8984811305999756
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 15 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 1.457571268081665 s
	size=1267222
	min time = 1.443115234375
	max time = 1.47202730178833
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 20 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 1.0203461647033691 s
	size=841926
	min time = 1.0107111930847168
	max time = 1.0299811363220215
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 25 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 0.6227924823760986 s
	size=432137
	min time = 0.6175041198730469
	max time = 0.6280808448791504
[PostgreSQL] requete (moyenne de 2) : SELECT * FROM flights WHERE "DAY" > 30 AND "DAY_OF_WEEK"<=5 AND "SCHEDULED_DEPARTURE">1200; 
	time = 0.23160886764526367 s
	size=36537
	min time = 0.2270350456237793
	max time = 0.23618268966674805
[PostgreSQL] requete (moyenne de 5) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 5;
	time = 0.9245550632476807 s
	size=4862950
	min time = 0.9157025814056396
	max time = 0.9414396286010742
[PostgreSQL] requete (moyenne de 5) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 10;
	time = 0.8281366348266601 s
	size=3906644
	min time = 0.8194997310638428
	max time = 0.8445649147033691
[PostgreSQL] requete (moyenne de 5) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 15;
	time = 0.712258243560791 s
	size=2948366
	min time = 0.7079896926879883
	max time = 0.7160210609436035
[PostgreSQL] requete (moyenne de 5) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 20;
	time = 0.6108540058135986 s
	size=1980764
	min time = 0.5978806018829346
	max time = 0.6257102489471436
[PostgreSQL] requete (moyenne de 5) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 25;
	time = 0.4956554889678955 s
	size=1032732
	min time = 0.48750758171081543
	max time = 0.5145018100738525
[PostgreSQL] requete (moyenne de 5) : SELECT "FLIGHT_NUMBER" FROM flights WHERE "DAY" > 30;
	time = 0.38142571449279783 s
	size=103812
	min time = 0.3763771057128906
	max time = 0.38446688652038574
[PostgreSQL] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 5;
	time = 8.830784857273102 s
	size=4862950
	min time = 6.797481060028076
	max time = 9.721642017364502
[PostgreSQL] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 5;
	time = 8.33528858423233 s
	size=4862950
	min time = 7.333136320114136
	max time = 9.00413990020752
[PostgreSQL] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 10.041725873947144 s
	size=4862950
	min time = 9.694392681121826
	max time = 10.52175521850586
[PostgreSQL] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.5854640603065491 s
	size=-1
	min time = 0.04937410354614258
	max time = 1.1649937629699707
[PostgreSQL] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 10;
	time = 9.022758722305298 s
	size=3906644
	min time = 8.308303117752075
	max time = 10.097565650939941
[PostgreSQL] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 10;
	time = 8.081559598445892 s
	size=3906644
	min time = 7.386091470718384
	max time = 8.700637102127075
[PostgreSQL] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 8.076122343540192 s
	size=3906644
	min time = 7.705643177032471
	max time = 8.259487390518188
[PostgreSQL] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.07293069362640381 s
	size=-1
	min time = 0.041390419006347656
	max time = 0.11310005187988281
[PostgreSQL] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 15;
	time = 7.636982500553131 s
	size=2948366
	min time = 7.487509489059448
	max time = 7.799198389053345
[PostgreSQL] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 15;
	time = 6.771987795829773 s
	size=2948366
	min time = 6.540830135345459
	max time = 7.069345712661743
[PostgreSQL] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 6.054782927036285 s
	size=2948366
	min time = 5.932224273681641
	max time = 6.191379547119141
[PostgreSQL] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.5385042428970337 s
	size=-1
	min time = 0.03220796585083008
	max time = 1.0505595207214355
[PostgreSQL] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 20;
	time = 5.521447420120239 s
	size=1980764
	min time = 5.02092981338501
	max time = 6.137861490249634
[PostgreSQL] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 20;
	time = 6.2529895305633545 s
	size=1980764
	min time = 6.0765862464904785
	max time = 6.496557235717773
[PostgreSQL] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 4.418011963367462 s
	size=1980764
	min time = 4.269284009933472
	max time = 4.557854175567627
[PostgreSQL] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.275598406791687 s
	size=-1
	min time = 0.02399921417236328
	max time = 1.029395341873169
[PostgreSQL] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 25;
	time = 4.464631259441376 s
	size=1032732
	min time = 4.193484306335449
	max time = 4.8250977993011475
[PostgreSQL] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 25;
	time = 4.121010005474091 s
	size=1032732
	min time = 4.040700912475586
	max time = 4.155271768569946
[PostgreSQL] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 2.7322950959205627 s
	size=1032732
	min time = 2.6562299728393555
	max time = 2.83027720451355
[PostgreSQL] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.2703375220298767 s
	size=-1
	min time = 0.014999151229858398
	max time = 1.0343520641326904
[PostgreSQL] requete (moyenne de 4) : CREATE TABLE flights2 AS SELECT * FROM FLIGHTS WHERE "DAY" > 30;
	time = 1.6179686188697815 s
	size=103812
	min time = 1.559305191040039
	max time = 1.6704299449920654
[PostgreSQL] requete (moyenne de 4) : DELETE FROM flights WHERE "DAY" > 30;
	time = 2.127740204334259 s
	size=103812
	min time = 1.7950465679168701
	max time = 3.0513410568237305
[PostgreSQL] requete (moyenne de 4) : INSERT INTO flights SELECT * FROM flights2;
	time = 0.15342062711715698 s
	size=103812
	min time = 0.14217686653137207
	max time = 0.17178654670715332
[PostgreSQL] requete (moyenne de 4) : DROP TABLE flights2;
	time = 0.005974888801574707 s
	size=-1
	min time = 0.005001068115234375
	max time = 0.00700068473815918
[PostgreSQL] requete (moyenne de 1000) : INSERT INTO flights random value 
	time = 0.002771217346191406 s
	min time = 0.0044405460357666016
	max time = 2.7712173461914062