PDDL - Domain Statistics

branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001181.6314221.4360221.2570169157222212.88601.98363,482,375,1763.243269,646.1106
combinedfull50,001250.3038186.4720186.3150141159181812.04201.91441,151,203,8561.072123,023.6166
trunkelaborated50,001181.6314221.4360221.2570169157222211.04101.44902,858,786,9682.662557,174.5959
trunkfull50,001241.5285186.4720186.315010814314148.34301.2073815,436,2000.759416,308.3978


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_condition<>'none'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.08240.047421.9168
combinedfull0432.535640.288149,9963,560.2558
trunkelaborated00.12050.047111.0000
trunkfull0746.592043.407933,9172,160.6528


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_condition<>'none') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001199.720036.461036.4540322414142.12701.206345,818,8000.0427916.3577
combinedfull20,001342.700036.366036.3450292816142.90601.733518,478,0480.0172923.8562
trunkelaborated50,001199.720036.461036.4540322414141.66400.847637,665,5200.0351753.2953
trunkfull15,001344.333336.366036.3450262416131.85801.204411,287,6880.0105752.4624


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='travel2'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.05280.047221.8600
combinedfull093.222648.92435,8122,254.3000
trunkelaborated00.07580.042911.0000
trunkfull060.008651.14075,8122,541.9333


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='travel2') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001186.000028.995028.987099771.51100.936137,630,5040.0350752.5950
combinedfull20,001320.000028.995028.9860151410101.58301.216919,727,4720.0184986.3243
trunkelaborated50,001186.000028.995028.987099770.81900.505726,252,7680.0244525.0449
trunkfull15,001320.000028.995028.986099770.79300.601810,416,9920.0097694.4198


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='taxi_hard3'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.05960.043422.0000
combinedfull0123.990861.349220,0009,000.0000
trunkelaborated00.09790.073611.0000
trunkfull088.755255.287215,0006,750.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='taxi_hard3') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001142.000033.072033.072088551.18400.801828,246,7200.0263564.9231
combinedfull20,001257.000033.072033.07201212991.31801.083615,005,5200.0140750.2385
trunkelaborated50,001142.000033.072033.072088550.63200.433817,924,3600.0167358.4800
trunkfull15,001257.000033.016033.016088550.71500.51147,301,6960.0068486.7473


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='mine_eater2b'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.05790.043622.0000
combinedfull0100.654550.294814,5826,531.5200
trunkelaborated00.03600.034911.0000
trunkfull068.139141.750810,9134,879.6000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='mine_eater2b') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001142.000033.072033.072088551.10800.803328,246,7200.0263564.9231
combinedfull20,001257.000033.072033.07201212991.52401.079415,002,4960.0140750.0873
trunkelaborated50,001142.000033.072033.072088550.62400.441117,941,2400.0167358.8176
trunkfull15,001257.000033.016033.016088550.70600.52367,318,7760.0068487.8859


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='mine_eater2a'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.05780.043522.0000
combinedfull0101.968351.464814,5826,531.5200
trunkelaborated00.03800.035011.0000
trunkfull067.154241.147510,9134,879.6000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='mine_eater2a') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001142.000033.072033.072088551.22400.798028,406,5760.0265568.1202
combinedfull20,001269.000033.072033.07201212991.60001.134615,263,4400.0142763.1338
trunkelaborated50,001142.000033.072033.072088550.76800.445918,006,8880.0168360.1306
trunkfull15,001269.000033.016033.016088550.83100.52647,381,4080.0069492.0611


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='mine_eater2'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06270.043122.0000
combinedfull0127.149263.866314,5856,534.5200
trunkelaborated00.11020.074611.0000
trunkfull084.192351.836310,9164,882.6000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='mine_eater2') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001118.000032.796032.796088551.54200.789228,026,7760.0261560.5243
combinedfull20,001213.000032.772032.77201111881.25200.939414,608,3680.0136730.3819
trunkelaborated50,001118.000032.796032.796088550.67300.438117,821,2080.0166356.4170
trunkfull15,001213.000032.732032.732088550.67400.46137,214,6400.0067480.9439


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='mine_eater1'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06280.043022.0000
combinedfull092.827645.344413,2565,948.4400
trunkelaborated00.09780.075811.0000
trunkfull058.728234.42579,9304,448.9000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='mine_eater1') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001163.020041.641041.6410192114141.71901.259550,292,0080.04681,005.8200
combinedfull50,001246.780041.472041.4720232318182.36601.644550,567,5040.04711,011.3299
trunkelaborated50,001163.020041.641041.6410192114141.19500.845139,252,2560.0366785.0294
trunkfull50,001246.780041.472041.4720192014141.56501.070639,013,6800.0363780.2580


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='miconic01'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06940.048921.7600
combinedfull04.96064.7931224.3800
trunkelaborated00.07830.047711.0000
trunkfull011.888811.7394224.3800


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='miconic01') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001147.020033.517033.517088661.70200.888628,416,5200.0265568.3190
combinedfull50,001239.000033.508033.5080121210101.66401.151229,017,8720.0270580.3458
trunkelaborated50,001147.020033.517033.517088666.00000.593118,254,5280.0170365.0833
trunkfull50,001239.000033.508033.508088661.03600.600818,484,9200.0172369.6910


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='maze6x6e'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06920.047021.9800
combinedfull09.10227.0823835142.6400
trunkelaborated00.07200.039211.0000
trunkfull018.104616.5436835142.6400


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='maze6x6e') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001171.000032.885032.885088551.25700.806327,969,2000.0260559.3728
combinedfull50,001287.000032.852032.8520121210101.72501.215028,811,2720.0268576.2139
trunkelaborated50,001171.000032.885032.885088550.68500.473317,604,6480.0164352.0859
trunkfull50,001287.000032.852032.852088550.96900.610917,842,9680.0166356.8522


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='maze6x6'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06980.047222.0000
combinedfull012.09209.33041,215228.0800
trunkelaborated00.06070.038811.0000
trunkfull023.050020.98151,215228.0800


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='maze6x6') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001124.060032.628032.628088551.40200.855727,724,4400.0258554.4777
combinedfull50,001193.000032.556032.55601212991.34500.999128,099,2480.0262561.9737
trunkelaborated50,001124.060032.628032.628088550.91700.478317,596,2080.0164351.9171
trunkfull50,001193.000032.556032.556088550.83000.524517,660,2160.0164353.1973


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='maze4'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06750.049421.9400
combinedfull04.40383.980116235.0200
trunkelaborated00.07160.041511.0000
trunkfull09.34049.049816235.0200


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='maze4') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001118.060033.007033.007088551.32600.843128,019,8400.0261560.3856
combinedfull50,001181.000033.000033.00001212991.39401.001428,501,8880.0265570.0264
trunkelaborated50,001118.060033.007033.007088550.82400.473917,984,4480.0167359.6818
trunkfull50,001181.000033.000033.000088550.79700.511118,094,3600.0169361.8800


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='maze3'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06350.047321.9400
combinedfull04.53613.820730868.1600
trunkelaborated00.07170.041011.0000
trunkfull08.80658.242130868.1600


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='maze3') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001121.060032.810032.810088551.29900.813527,808,8400.0259556.1657
combinedfull50,001187.000032.768032.76801212991.49101.040328,251,2880.0263565.0145
trunkelaborated50,001121.060032.810032.810088550.75800.453917,815,6480.0166356.3058
trunkfull50,001187.000032.768032.768088550.81300.513017,889,9680.0167357.7922


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='maze2'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06730.046721.9400
combinedfull04.19893.858214536.5400
trunkelaborated00.08260.041711.0000
trunkfull08.86418.621514536.5400


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='maze2') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001118.040032.948032.948088551.22500.809228,045,1600.0261560.8920
combinedfull50,001181.000032.916032.91601212991.44800.974928,487,7280.0265569.7432
trunkelaborated50,001118.040032.948032.948088550.71300.467817,950,6880.0167359.0066
trunkfull50,001181.000032.916032.916088550.86500.528318,001,5680.0168360.0242


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='maze1'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.07280.047021.9600
combinedfull04.11323.740313838.9200
trunkelaborated00.07100.039711.0000
trunkfull08.44778.181413838.9200


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='maze1') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001115.040033.168033.168088551.08200.798428,104,2400.0262562.0736
combinedfull50,001175.000033.140033.14001212991.32901.001628,538,2880.0266570.7543
trunkelaborated50,001115.040033.168033.168088550.83200.453918,144,8080.0169362.8889
trunkfull50,001175.000033.140033.140088550.82200.516918,187,9440.0169363.7516


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='maze0'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06690.046621.9600
combinedfull03.95153.622212736.8000
trunkelaborated00.09430.039711.0000
trunkfull08.15957.929712736.8000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='maze0') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001241.500081.266081.2740525932333.80202.6709111,285,9040.10362,225.6736
combinedfull50,001382.436481.193081.2010535940406.14704.4759123,553,3520.11512,471.0176
trunkelaborated50,001241.500081.266081.2740525932333.32102.127293,021,5120.08661,860.3930
trunkfull50,001382.436481.193081.2010525833335.80903.4565102,166,2640.09512,043.2844


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='log__4__2'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.08080.049921.9600
combinedfull0269.2731106.437321,0157,709.2182
trunkelaborated00.07440.041811.0000
trunkfull0256.1545110.878521,0157,709.2182


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='log__4__2') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001211.040072.624072.6250455227283.39402.4163103,200,3840.09612,063.9664
combinedfull50,001329.945572.495072.4960485336375.94404.1110114,517,9840.10672,290.3139
trunkelaborated50,001211.040072.624072.6250455227283.49301.812184,311,4320.07851,686.1949
trunkfull50,001329.945572.495072.4960455127285.05302.784692,712,9600.08631,854.2221


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='log__3__3'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06650.048821.8800
combinedfull0432.5356164.336333,91712,457.9091
trunkelaborated00.07460.044411.0000
trunkfull0434.7189166.351633,91712,457.9091


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='log__3__3') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001145.760037.952037.9520171812121.90901.113540,991,1200.0382819.8060
combinedfull50,001233.618237.944037.9440172114142.23501.647346,402,2560.0432928.0266
trunkelaborated50,001145.760037.952037.9520171812121.04300.725535,150,4000.0327702.9939
trunkfull50,001233.618237.944037.9440171812121.43201.096239,144,1520.0365782.8674


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='hanoi__4'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06770.046921.9600
combinedfull047.269821.16513,505783.0545
trunkelaborated00.07300.039311.0000
trunkfull040.872523.15593,505783.0545


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='hanoi__4') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001122.760037.700037.7000181612121.51401.039141,337,1600.0385826.7267
combinedfull50,001187.745537.650037.6500182013131.83501.417646,307,7760.0431926.1370
trunkelaborated50,001122.760037.700037.7000181612121.31400.765235,488,0000.0331709.7458
trunkfull50,001187.745537.650037.6500181612121.29900.948039,216,9440.0365784.3232


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='hanoi__3'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06240.046721.9600
combinedfull09.59995.7450574115.3818
trunkelaborated00.07130.039811.0000
trunkfull013.359910.4791574115.3818


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='hanoi__3') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001111.120042.611042.6100425218193.45501.748070,943,2000.06611,418.8356
combinedfull50,001162.054542.362042.3610435421234.42802.522977,751,3920.07241,554.9967
trunkelaborated50,001111.120042.611042.6100425218192.15601.190558,072,5680.05411,161.4281
trunkfull50,001162.054542.362042.3610425217193.29701.484463,269,7120.05891,265.3689


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='gripper__4'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06460.048821.4600
combinedfull014.57755.8066760169.0545
trunkelaborated00.09560.058411.0000
trunkfull014.30598.0724760169.0545


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='gripper__4') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,00194.140035.704035.7060393617162.04801.413459,567,5680.05551,191.3275
combinedfull50,001131.727335.381035.3820403520193.25901.832964,709,4080.06031,294.1623
trunkelaborated50,00194.140035.704035.7060393617161.75900.944649,515,2960.0461990.2861
trunkfull50,001131.727335.381035.3820383517161.78401.081953,373,6240.04971,067.4511


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='gripper__2'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06820.048221.4000
combinedfull03.26912.180612227.2727
trunkelaborated00.09370.059411.0000
trunkfull04.45623.792312227.2727


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='gripper__2') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001146.840044.694044.7870252917182.29201.705670,730,2000.06591,414.5757
combinedfull5,001236.400044.687044.7860283022232.70902.25527,080,0800.00661,415.7329
trunkelaborated50,001146.840044.694044.7870252917181.77001.060355,732,6960.05191,114.6316
trunkfull5,001236.400044.687044.7860202717181.53801.16505,269,2800.00491,053.6453


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='rockets__4'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.05830.043822.0000
combinedfull070.594244.95375,0003,000.0000
trunkelaborated00.11010.074511.0000
trunkfull086.568757.91065,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='rockets__4') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001206.000029.242029.270088881.60301.254237,056,5840.0345741.1169
combinedfull5,001364.000029.242029.2690151515151.97001.84564,582,2480.0043916.2663
trunkelaborated50,001206.000029.242029.270088880.74300.529321,534,8080.0201430.6875
trunkfull5,001364.000029.242029.269088880.79900.70302,376,8560.0022475.2761


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='myst25'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06070.043222.0000
combinedfull061.969641.22795,0003,000.0000
trunkelaborated00.09600.076311.0000
trunkfull066.493851.45095,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='myst25') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001306.000029.458029.459088881.82701.336037,056,5840.0345741.1169
combinedfull5,001564.000029.458029.4580151515152.50402.41345,196,7200.00481,039.1362
trunkelaborated50,001306.000029.458029.459088880.88300.574221,712,0480.0202434.2323
trunkfull5,001564.000029.458029.458088881.02000.90262,619,6320.0024523.8216


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='myst04'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06010.043222.0000
combinedfull0116.022585.98085,0003,000.0000
trunkelaborated00.08730.076611.0000
trunkfull0151.4858131.64985,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='myst04') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001185.240065.247065.3060726124224.19602.205284,303,2240.07851,686.0308
combinedfull5,001292.800063.365063.3400502733238.93505.63689,772,2000.00911,954.0492
trunkelaborated50,001185.240065.247065.3060726124223.26301.541466,445,9360.06191,328.8921
trunkfull5,001292.800063.365063.3400462624146.16603.37387,358,2160.00691,471.3489


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='maze_bw_hard_01'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.07320.049021.9800
combinedfull063.154434.48702,7221,268.6000
trunkelaborated00.07280.040311.0000
trunkfull086.058549.69272,7221,268.6000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='maze_bw_hard_01') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001266.980092.099092.1000615834344.46403.0641127,524,4640.11882,550.4383
combinedfull5,001424.200091.754091.7470595651484.80804.398613,199,9200.01232,639.4561
trunkelaborated50,001266.980092.099092.1000615834343.54502.2751104,077,9120.09692,081.5166
trunkfull5,001424.200091.754091.7470605234314.28802.59029,963,5360.00931,992.3087


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='log__4__4'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.07210.049721.8000
combinedfull094.769661.42905,0003,000.0000
trunkelaborated00.12050.048411.0000
trunkfull0111.169583.97125,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='log__4__4') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001255.520086.605086.6040564835353.80202.7830119,717,4640.11152,394.3014
combinedfull5,001406.200086.515086.5140464542403.95603.593412,320,5680.01152,463.6209
trunkelaborated50,001255.520086.605086.6040564835353.43702.242798,769,1520.09201,975.3435
trunkfull5,001406.200086.515086.5140494742403.48903.10969,467,8960.00881,893.2006


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='log__4__3'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.05410.048521.8400
combinedfull061.598441.89145,0003,000.0000
trunkelaborated00.07590.046011.0000
trunkfull090.934968.68055,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='log__4__3') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001225.680079.068079.0610505131303.99002.6769110,991,0000.10342,219.7756
combinedfull5,001354.000078.109078.1090494443403.77703.510411,515,2240.01072,302.5843
trunkelaborated50,001225.680079.068079.0610505131302.93201.997389,838,7440.08371,796.7389
trunkfull5,001354.000078.109078.1090473935332.88902.44128,493,4720.00791,698.3547


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='log__3__4'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06740.050521.7800
combinedfull093.415360.20294,9982,998.0000
trunkelaborated00.07620.048311.0000
trunkfull098.089272.18064,9982,998.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='log__3__4') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001197.800066.330066.3360404527283.11102.171594,144,2640.08771,882.8476
combinedfull5,001310.600065.679065.6720393833333.12702.61509,584,6240.00891,916.5415
trunkelaborated50,001197.800066.330066.3360404527283.48801.765477,652,2720.07231,553.0144
trunkfull5,001310.600065.679065.6720283120202.44201.55807,350,2240.00681,469.7508


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='log__3__2'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.07660.048621.9400
combinedfull078.613450.97064,9982,998.0000
trunkelaborated00.07490.042511.0000
trunkfull065.980547.97304,9982,998.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='log__3__2') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001201.000038.000038.0000181412122.28701.198741,548,1600.0387830.9466
combinedfull5,001344.000038.000038.0000161612121.96901.55045,114,0720.00481,022.6099
trunkelaborated50,001201.000038.000038.0000181412121.25500.827635,572,4000.0331711.4338
trunkfull5,001344.000038.000038.0000131311111.33501.17523,846,0320.0036769.0526


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='hanoi__6'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06770.047522.0000
combinedfull0154.8410133.92233,0491,397.6000
trunkelaborated00.04030.038111.0000
trunkfull078.991865.09163,0491,397.6000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='hanoi__6') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001172.000038.000038.0000151512121.55701.107041,303,4000.0385826.0515
combinedfull5,001286.000037.979037.9790161614142.19601.69224,846,9680.0045969.1998
trunkelaborated50,001172.000038.000038.0000151512121.10500.779235,471,1200.0330709.4082
trunkfull5,001286.000037.979037.9790121211111.23101.03643,767,2000.0035753.2893


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='hanoi__5'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.07510.047122.0000
combinedfull059.342241.08903,0491,397.6000
trunkelaborated00.06710.038511.0000
trunkfull053.671242.03493,0491,397.6000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='hanoi__5') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001239.120035.357035.3670252812142.21001.208246,823,1600.0436936.4445
combinedfull50,001422.120035.357035.3670303215162.74701.875048,396,3120.0451967.9069
trunkelaborated50,001239.120035.357035.3670252812141.38400.852638,923,0800.0362778.4460
trunkfull5,001426.800034.703034.6980141710111.12000.92943,926,1440.0037785.0718


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='grid0'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06780.047222.0000
combinedfull0211.1443117.040049,99625,496.0000
trunkelaborated00.06210.039811.0000
trunkfull077.716569.31434,9962,996.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='grid0') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001179.000043.239043.2390252820172.40701.586965,534,6400.06101,310.6666
combinedfull5,001296.000042.752042.7520292924192.39302.06087,133,3680.00661,426.3883
trunkelaborated50,001179.000043.239043.2390252820171.44601.077053,963,1600.05031,079.2416
trunkfull5,001296.000042.752042.7520252120151.22801.06225,192,2560.00481,038.2436


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='eight04x'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06670.047522.0000
combinedfull0167.7293102.49185,0003,000.0000
trunkelaborated00.04720.039211.0000
trunkfull085.713862.26615,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='eight04x') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001179.000043.239043.2390252820173.42601.626865,416,4800.06091,308.3034
combinedfull5,001296.000042.752042.7520272523192.31301.89327,119,2080.00661,423.5569
trunkelaborated50,001179.000043.239043.2390252820171.41401.069953,963,1600.05031,079.2416
trunkfull5,001296.000042.752042.7520252120151.24901.07265,192,2560.00481,038.2436


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='eight03x'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.08240.047522.0000
combinedfull0167.5792102.82945,0003,000.0000
trunkelaborated00.04960.039411.0000
trunkfull085.800762.52055,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='eight03x') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001179.000043.239043.2390252820172.32101.608365,416,4800.06091,308.3034
combinedfull5,001296.000042.752042.7520272523192.53401.97147,085,4480.00661,416.8062
trunkelaborated50,001179.000043.239043.2390252820171.46201.072053,963,1600.05031,079.2416
trunkfull5,001296.000042.752042.7520252120151.24801.07205,192,2560.00481,038.2436


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='eight02x'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.08080.047322.0000
combinedfull0169.5635103.12275,0003,000.0000
trunkelaborated00.05420.039511.0000
trunkfull085.247761.95585,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='eight02x') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001179.000043.239043.2390252820172.13401.557865,534,6400.06101,310.6666
combinedfull5,001296.000042.752042.7520292924192.74202.09947,167,1280.00671,433.1390
trunkelaborated50,001179.000043.239043.2390252820171.45401.102853,963,1600.05031,079.2416
trunkfull5,001296.000042.752042.7520252120151.24201.06625,192,2560.00481,038.2436


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='eight01x'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.05230.047022.0000
combinedfull0169.8182103.66695,0003,000.0000
trunkelaborated00.07530.040911.0000
trunkfull081.057858.95255,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='eight01x') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001216.2400141.3780141.3990138153565711.05704.2804169,991,0880.15833,399.7538
combinedfull5,001279.8000126.4430126.4370999960526.39204.014419,682,5920.01833,935.7313
trunkelaborated50,001216.2400141.3780141.399013815356579.12603.5778150,249,6960.13993,004.9338
trunkfull5,001279.8000126.4430126.4370998955475.20003.055814,257,7600.01332,850.9818


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='bw08'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.07310.049521.9600
combinedfull0155.6253104.19315,0003,000.0000
trunkelaborated00.07590.041711.0000
trunkfull0340.1624231.15224,9572,982.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='bw08') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001182.9800117.3700117.381013611646479.96703.7855151,979,6080.14153,039.5314
combinedfull5,001206.8000115.6990115.6990524442283.88802.937016,939,4720.01583,387.2170
trunkelaborated50,001182.9800117.3700117.381013611646476.36302.9224134,681,3360.12542,693.5728
trunkfull5,001206.8000115.6990115.6990443237242.78302.031412,604,7440.01172,520.4447


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='bw07'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06740.048221.9600
combinedfull0126.754182.92784,9862,986.0000
trunkelaborated00.07240.042011.0000
trunkfull0243.7408164.82314,8462,894.8000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='bw07') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001157.420093.009092.987012512342437.65603.3075130,123,9760.12122,602.4275
combinedfull5,001201.600092.346092.3550725248403.75503.074814,211,8160.01322,841.7948
trunkelaborated50,001157.420093.009092.987012512342436.34002.5765115,168,0560.10732,303.3151
trunkfull5,001201.600092.346092.3550704041342.35102.033010,537,6480.00982,107.1082


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='bw06'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.07470.048621.9600
combinedfull099.244265.38095,0003,000.0000
trunkelaborated00.07480.040111.0000
trunkfull0172.0419118.85164,7402,833.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='bw06') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001305.4000221.4360221.2570156157737612.88605.9435236,101,6080.21994,721.9377
combinedfull5,001397.6000186.4720186.3150141151779212.04207.126027,271,4480.02545,453.1990
trunkelaborated50,001305.4000221.4360221.2570156157737611.04104.9572207,667,0160.19344,153.2573
trunkfull5,001397.6000186.4720186.315010814360758.34304.994019,318,6480.01803,862.9570


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='bw05'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.07840.050121.9000
combinedfull0276.9255189.53475,0003,000.0000
trunkelaborated00.07540.045111.0000
trunkfull0746.5920499.96325,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='bw05') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001232.3200174.8190174.872014114152599.06204.3898203,337,5280.18944,066.6692
combinedfull5,001313.8000156.3530156.40607910157697.22005.462823,364,1280.02184,671.8912
trunkelaborated50,001232.3200174.8190174.872014114152598.62403.6238179,595,5760.16733,591.8397
trunkfull5,001313.8000156.3530156.4060709545585.00503.605616,890,6320.01573,377.4509


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='bw04'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.07530.049122.0000
combinedfull0203.8040137.94934,9982,998.0000
trunkelaborated00.04180.040411.0000
trunkfull0494.2343329.59194,9942,995.6000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='bw04') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001189.2400125.5280125.536016911749497.99003.8300159,770,2320.14883,195.3407
combinedfull5,001221.2000119.7720119.7730955253335.16403.375817,720,2480.01653,543.3409
trunkelaborated50,001189.2400125.5280125.536016911749497.14303.0997142,196,5360.13242,843.8738
trunkfull5,001221.2000119.7720119.7730924947283.98502.102812,959,3280.01212,591.3473


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='bw03'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.05190.048621.8600
combinedfull0138.204991.75464,9982,998.0000
trunkelaborated00.07670.045711.0000
trunkfull0292.9418196.28984,9272,952.4000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='bw03') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001183.3400101.8720101.883013212454478.96303.7240140,644,6960.13102,812.8377
combinedfull5,001219.400097.512097.357095159466610.53504.773215,164,5840.01413,032.3103
trunkelaborated50,001183.3400101.8720101.883013212454477.51903.0179124,350,7920.11582,486.9661
trunkfull5,001219.400097.512097.35705111536556.37403.074411,147,2400.01042,229.0022


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='bw02'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06990.049421.9600
combinedfull0113.321774.50324,9982,998.0000
trunkelaborated00.07300.042011.0000
trunkfull0210.7594145.67474,6602,796.8000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='bw02') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001127.920083.023082.9970897131334.78702.6286120,342,0240.11212,406.7923
combinedfull5,001175.400074.027074.0840755044343.60002.955212,501,2880.01162,499.7576
trunkelaborated50,001127.920083.023082.9970897131333.91301.9377105,082,2720.09792,101.6034
trunkfull5,001175.400074.027074.0840714439292.18301.62169,335,4640.00871,866.7195


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='bw01'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06880.049621.8800
combinedfull091.314458.16375,0003,000.0000
trunkelaborated00.07350.044011.0000
trunkfull0137.180194.95504,5162,720.8000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='bw01') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC
branchcondmaxepsavg_wmmax_wmaddsmax_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
combinedelaborated50,001345.4000166.8610166.8690949465657.73705.4875226,901,9920.21134,537.9491
combinedfull5,001508.8000163.9660163.97201029592888.01707.629022,631,5920.02114,525.4133
trunkelaborated50,001345.4000166.8610166.8690949465657.53304.3598182,438,4560.16993,648.6961
trunkfull5,001508.8000163.9660163.9720878767636.10905.001217,196,7440.01603,438.6611


download as csv
SELECT a.*, (a.bytes/(1024*1024*1024)) AS gbs, (a.bytes/a.maxeps) AS bytes_per_ep
FROM (SELECT d_branch AS branch, d_condition AS cond, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_wmadds/1000) AS max_wmadds, MAX(d_wmremoves/1000) AS max_wmremoves, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, 1000*MAX(d_totalsec/d_reps) AS max_storage_msecs, 1000*AVG(d_totalsec/d_reps) AS avg_storage_msecs
FROM exp_data_79
WHERE d_command='storage' AND d_episodes>1 AND d_domain='aipslog05'
GROUP BY d_branch, d_condition) a
branchcondcommandmax_msecsavg_msecsmax_numsearchedavg_numsearched
combinedelaborated00.06850.049621.5600
combinedfull0105.480574.90155,0003,000.0000
trunkelaborated00.07730.056011.0000
trunkfull0131.522596.64875,0003,000.0000


download as csv
SELECT a.branch, a.cond, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched
FROM (SELECT d_branch AS branch, d_condition AS cond, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
FROM exp_data_79
WHERE d_episodes>1 AND d_command<>'storage' AND d_domain='aipslog05') a
GROUP BY a.branch, a.cond, a.command
ORDER BY a.branch ASC, a.cond ASC, max_msecs DESC