EpMem Domain Analysis

    branchmaxepsavg_wmmax_wmaddsmax_wmremovesavg_wmaddsavg_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
    combined3,500,001229.828636.590436.590636.443836.44381816981.39200.78002,842,688,2482.6475812.1964
    trunk3,500,001229.828636.590436.590636.443836.44381716981.25100.78522,616,507,1192.4368747.5732
    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, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, MAX(d_wmadds/50000) AS max_wmadds, MAX(d_wmremoves/50000) AS max_wmremoves, AVG(d_wmadds/50000) AS avg_wmadds, AVG(d_wmremoves/50000) AS avg_wmremoves, 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='eaters'
    GROUP BY d_branch) a
    branchcommandmax_msecsavg_msecsstdev_msecsratiomax_numsearchedavg_numsearched
    combined50.70700.49580.047410.467421.7857
    combined20.55930.39500.037110.637511.0000
    combined60.54020.38170.03959.65227070.0000
    combined70.49470.26970.05994.505319932.9000
    combined40.37790.26550.025110.596422.0000
    combined30.08110.05640.005210.791921.7857
    combined10.07180.05060.004710.842811.0000
    trunk51.23920.80950.072711.138921.7857
    trunk61.23820.86370.064713.34683535.0000
    trunk20.83170.66100.042715.482211.0000
    trunk40.62950.43530.036212.027611.0000
    trunk70.57690.36460.04378.336610017.0286
    trunk30.12240.05650.01723.295011.0000
    trunk10.10160.08120.005115.966911.0000
    download as csv
    SELECT a.branch, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, STDDEV_SAMP(a.msecs) AS stdev_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched, (AVG(a.msecs)/STDDEV_SAMP(a.msecs)) AS ratio
    FROM (SELECT d_branch AS branch, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
    FROM exp_data_79
    WHERE d_domain='eaters' AND d_episodes>1 AND d_command<>'storage') a
    GROUP BY a.branch, a.command
    ORDER BY a.branch ASC, max_msecs DESC
      branchmaxepsavg_wmmax_wmaddsmax_wmremovesavg_wmaddsavg_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
      combined3,500,0012,733.128639.083739.083737.097137.09712276414718.65702.22033,621,358,1363.37271,034.6735
      trunk3,500,0012,733.128639.083739.083737.097137.09712276414717.51702.66853,413,247,2793.1788975.2132
      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, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, MAX(d_wmadds/50000) AS max_wmadds, MAX(d_wmremoves/50000) AS max_wmremoves, AVG(d_wmadds/50000) AS avg_wmadds, AVG(d_wmremoves/50000) AS avg_wmremoves, 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='tanksoar'
      GROUP BY d_branch) a
      branchcommandmax_msecsavg_msecsstdev_msecsratiomax_numsearchedavg_numsearched
      combined1318.307516.88620.402341.971311.0000
      combined129.91168.90000.240337.043611.0000
      combined104.77352.13191.14191.867030551.5000
      combined142.26100.75450.39711.90011,373300.0714
      combined81.27050.63290.26742.367031.9429
      combined170.77670.57830.039814.5311285.4286
      combined70.67380.37220.12522.971921.9143
      combined150.24020.19540.010219.1735435.6286
      combined50.20710.18890.006529.0621175.8000
      combined60.16180.14030.003836.632321.9143
      combined30.15810.13960.003738.233221.8714
      combined40.15080.13930.003243.470421.7857
      combined20.14560.13700.002848.647011.0000
      combined10.06690.04950.002420.841911.0000
      combined90.06280.05650.001636.256211.0000
      trunk1326.124524.02120.582841.217811.0000
      trunk1220.767418.67420.524335.615311.0000
      trunk108.63947.31630.409217.88122911.2714
      trunk95.47604.09260.265515.412611.0000
      trunk82.58331.74500.156011.183211.0000
      trunk141.84000.77600.27682.80321,354296.0000
      trunk71.51260.97300.11018.840611.0000
      trunk171.21640.79360.13635.8235153.3429
      trunk50.42630.27330.03637.533893.5429
      trunk150.36640.30130.016318.528111.0000
      trunk40.31400.21360.018311.675411.0000
      trunk20.31190.23550.011220.958411.0000
      trunk60.27900.21280.015313.941811.0000
      trunk30.27670.21170.015114.056811.0000
      trunk10.10610.08040.004816.770311.0000
      download as csv
      SELECT a.branch, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, STDDEV_SAMP(a.msecs) AS stdev_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched, (AVG(a.msecs)/STDDEV_SAMP(a.msecs)) AS ratio
      FROM (SELECT d_branch AS branch, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
      FROM exp_data_79
      WHERE d_domain='tanksoar' AND d_episodes>1 AND d_command<>'storage') a
      GROUP BY a.branch, a.command
      ORDER BY a.branch ASC, max_msecs DESC
      • random seed: 121
      • level width: 250
      • runs: 15,000
      branchmaxepsavg_wmmax_wmaddsmax_wmremovesavg_wmaddsavg_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
      combined3,500,0011,978.3286268.8692268.8685260.2293260.2293642628353655.014013.59009,259,377,3768.62352,645.5356
      trunk3,500,0011,993.2857270.0018270.0009257.6012257.60126426283536148.35407.78938,685,961,7588.08942,481.7027
      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, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, MAX(d_wmadds/50000) AS max_wmadds, MAX(d_wmremoves/50000) AS max_wmremoves, AVG(d_wmadds/50000) AS avg_wmadds, AVG(d_wmremoves/50000) AS avg_wmremoves, 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='mario'
      GROUP BY d_branch) a
      branchcommandmax_msecsavg_msecsstdev_msecsratiomax_numsearchedavg_numsearched
      combined1540.431831.12532.045815.214221.4286
      combined161.65930.70270.22183.168226753.1000
      combined141.23850.80370.17474.60017633.6286
      combined101.11260.87160.14855.87154510.0857
      combined50.59770.40190.09124.406782.5571
      combined80.40090.28660.05974.7970235.0857
      combined90.39810.23560.06583.581294.1000
      combined110.25850.18540.013313.896711.0000
      combined70.22050.07850.03752.091621.3857
      combined120.19240.13820.009814.138311.0000
      combined130.19210.13800.009614.427011.0000
      combined30.14720.09310.02593.599521.2571
      combined10.08300.05770.004412.973821.8429
      combined20.08100.05660.004113.798021.5429
      trunk1529.989227.27960.933329.228311.0000
      trunk141.99311.51810.18088.39676538.0000
      trunk101.82721.18750.18266.501973.9143
      trunk161.39640.87300.16245.377412929.0857
      trunk51.34800.99700.14446.9044275.2857
      trunk80.80120.46190.08615.366711.0000
      trunk110.42980.31780.03798.388711.0000
      trunk90.40150.25660.03637.066931.6571
      trunk70.39500.29230.04266.855611.0000
      trunk30.36090.24600.04155.928111.0000
      trunk120.17250.12390.01757.065200.0000
      trunk130.17110.12270.01757.002300.0000
      trunk20.11790.07530.01844.081211.0000
      trunk10.11500.05540.01643.369211.0000
      download as csv
      SELECT a.branch, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, STDDEV_SAMP(a.msecs) AS stdev_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched, (AVG(a.msecs)/STDDEV_SAMP(a.msecs)) AS ratio
      FROM (SELECT d_branch AS branch, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
      FROM exp_data_79
      WHERE d_domain='mario' AND d_episodes>1 AND d_command<>'storage') a
      GROUP BY a.branch, a.command
      ORDER BY a.branch ASC, max_msecs DESC
        branchmaxepsavg_wmmax_wmaddsmax_wmremovesavg_wmaddsavg_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
        combined108,600,0011,286.964111.019911.019310.512410.51231616003.17300.161885,961,3840.08010.7915
        trunk58,200,0011,234.505211.449111.448211.106911.10691717003.20500.352685,872,3200.08001.4755
        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, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, MAX(d_wmadds/300000) AS max_wmadds, MAX(d_wmremoves/300000) AS max_wmremoves, AVG(d_wmadds/300000) AS avg_wmadds, AVG(d_wmremoves/300000) AS avg_wmremoves, 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='robots'
        GROUP BY d_branch) a
        branchcommandmax_msecsavg_msecsstdev_msecsratiomax_numsearchedavg_numsearched
        combined660.260317.58424.49373.91301,7391,016.0635
        combined30.74680.54950.029718.532121.0939
        combined20.46800.34280.018418.592421.0939
        combined50.39030.28880.013820.98061110.9365
        combined40.31880.19500.011516.987611.0000
        combined10.10770.08050.004816.897211.0000
        trunk657.320241.50479.70284.2776185171.8041
        trunk31.36101.02430.067715.140921.1340
        trunk50.77540.59660.045613.077454.9588
        trunk20.71070.53280.034215.588721.1340
        trunk40.41920.31520.016818.802211.0000
        trunk10.14820.11660.006617.785111.0000
        download as csv
        SELECT a.branch, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, STDDEV_SAMP(a.msecs) AS stdev_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched, (AVG(a.msecs)/STDDEV_SAMP(a.msecs)) AS ratio
        FROM (SELECT d_branch AS branch, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
        FROM exp_data_79
        WHERE d_domain='robots' AND d_episodes>1 AND d_command<>'storage') a
        GROUP BY a.branch, a.command
        ORDER BY a.branch ASC, max_msecs DESC
          branchmaxepsavg_wmmax_wmaddsmax_wmremovesavg_wmaddsavg_wmremovesmax_dcaddsmax_dcremovesavg_dcaddsavg_dcremovesmax_storage_msecsavg_storage_msecsbytesgbsbytes_per_ep
          combined4,600,00178.77177.19637.19637.19297.192956330.52100.22481,078,888,0721.0048234.5408
          trunk4,600,00178.77177.19637.19637.19297.192956330.55400.20981,043,909,7440.9722226.9369
          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, SUM(d_sqlitememadd) AS bytes, MAX(d_episodes) AS maxeps, AVG(d_wmcurrent) AS avg_wm, MAX(d_dcadds) AS max_dcadds, MAX(d_dcremoves) AS max_dcremoves, AVG(d_dcadds) AS avg_dcadds, AVG(d_dcremoves) AS avg_dcremoves, MAX(d_wmadds/50000) AS max_wmadds, MAX(d_wmremoves/50000) AS max_wmremoves, AVG(d_wmadds/50000) AS avg_wmadds, AVG(d_wmremoves/50000) AS avg_wmremoves, 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='wsd'
          GROUP BY d_branch) a
          branchcommandmax_msecsavg_msecsstdev_msecsratiomax_numsearchedavg_numsearched
          combined1122.052611.08846.33441.750518,4859,250.8043
          combined85.22482.96201.26772.33664,3632,421.1957
          combined72.39101.13480.63881.77661,980897.2065
          combined102.30000.66360.51701.28361,886490.0543
          combined91.97770.57260.47621.20221,600410.5652
          combined61.82590.64640.43241.49501,489476.4674
          combined50.05220.04970.000768.491621.9565
          combined30.05190.04940.000864.739021.9891
          combined10.05110.04970.000774.071521.9891
          combined40.05070.04970.000768.175322.0000
          combined20.05050.04960.000771.487022.0000
          trunk1115.07797.64754.33261.76519,2794,643.9130
          trunk83.65432.10570.88312.38432,1841,212.8913
          trunk71.65810.81740.44211.8490990448.6087
          trunk101.58430.47670.35191.3547943245.0870
          trunk61.43990.47140.30591.5409745238.4130
          trunk91.34880.41510.32661.2711802205.7935
          trunk50.08230.04770.00835.748611.0000
          trunk10.08090.04610.004310.657511.0000
          trunk30.08070.04630.00538.679011.0000
          trunk40.07310.04630.00489.725211.0000
          trunk20.07190.04600.003413.407311.0000
          download as csv
          SELECT a.branch, a.command, MAX(a.msecs) AS max_msecs, AVG(a.msecs) AS avg_msecs, STDDEV_SAMP(a.msecs) AS stdev_msecs, MAX(a.numsearched) AS max_numsearched, AVG(a.numsearched) AS avg_numsearched, (AVG(a.msecs)/STDDEV_SAMP(a.msecs)) AS ratio
          FROM (SELECT d_branch AS branch, d_command AS command, 1000*(d_totalsec/d_reps) AS msecs, d_numsearched AS numsearched
          FROM exp_data_79
          WHERE d_domain='wsd' AND d_episodes>1 AND d_command<>'storage') a
          GROUP BY a.branch, a.command
          ORDER BY a.branch ASC, max_msecs DESC