Script started on Wed Feb  8 08:54:55 2012
csh> look_TB.pl jsoc_sums


Loading DB routines from perl5db.pl version 1.28
Editor support available.

Enter h or `h h' for help, or `man perldebug' for more help.

main::(./look_TB.pl:1):	eval 'exec /home/jsoc/bin/$JSOC_MACHINE/perl -d -S  $0 "$@"'
main::(./look_TB.pl:2):	    if 0;
  DB<1> c
Connected to Postgres OK
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM0/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM0/%'
Group 0: 8.2013290370478
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM0/%'
Group 1: 0.944334720890765
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM0/%'
Group 2: 0.612310714001978
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM0/%'
Group 3: 0.50265220618985
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM0/%'
Group 4: 0.229977325920117
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM0/%'
Group 5: 0.119054269583103
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM0/%'
Group 6: 3.76232681114288
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM0/%'
Group 7: 0.00319824182315642
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM0/%'
Group 8: 0.00428193701100099
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM0/%'
Group 9: 0.177595800270865
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM0/%'
Group 10: 7.84050477561595
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM0/%'
Group 11: 7.32253283786122e-07
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM0/%'
Group 12: 1.22049459605478e-06
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM0/%'
Group 100: 4.74360958666693
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM0/%'
Group 310: 0.204739135823729
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM0/%'
Group 311: 0.226300521844678
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM0/%'
Group 400: 0.0323416557976088
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM0/%'
Group 401: 0.0261899271881703
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM0/%'
Group 10000: 0.000469976255772053
total TB /SUM0 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM1/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM1/%'
Group 0: 8.21903721863418
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM1/%'
Group 1: 0.995926322384548
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM1/%'
Group 2: 0.582184211632921
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM1/%'
Group 3: 0.511636197124062
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM1/%'
Group 4: 0.257552095015853
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM1/%'
Group 5: 0.126823646258345
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM1/%'
Group 6: 3.76993844087519
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM1/%'
Group 7: 0.00318493860140734
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM1/%'
Group 8: 0.00404765821622277
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM1/%'
Group 9: 0.169542732229274
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM1/%'
Group 10: 7.88279961109492
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM1/%'
Group 11: 3.03677261399571e-05
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM1/%'
Group 12: 3.88756061511231e-05
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM1/%'
Group 100: 4.75191614122741
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM1/%'
Group 310: 0.204730472853953
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM1/%'
Group 311: 0.239979100316305
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM1/%'
Group 400: 0.0305120744960732
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM1/%'
Group 401: 0.0269586892882216
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM1/%'
Group 10000: 0.00044582850750885
total TB /SUM1 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM10/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM10/%'
Group 0: 8.37707932368721
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM10/%'
Group 1: 1.08018173796427
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM10/%'
Group 2: 0.461329497756196
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM10/%'
Group 3: 0.478308094769091
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM10/%'
Group 4: 0.216096149641089
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM10/%'
Group 5: 0.108771271250589
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM10/%'
Group 6: 3.78810275692649
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM10/%'
Group 7: 0.00321649553097814
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM10/%'
Group 8: 0.00436463594178349
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM10/%'
Group 9: 0.172659058017416
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM10/%'
Group 10: 7.84394229630925
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM10/%'
Group 11: 7.32254193280824e-07
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM10/%'
Group 100: 4.75216883951543
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM10/%'
Group 310: 0.176318562494998
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM10/%'
Group 311: 0.223157684575199
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM10/%'
Group 400: 0.0318600241762397
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM10/%'
Group 401: 0.0246261405745827
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM10/%'
Group 10000: 0.000459425634289801
total TB /SUM10 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM100/%' order by group_id
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM100/%'
Group 100: 3.56191418415074
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM100/%'
Group 10000: 48.6552327272275
total TB /SUM100 = 52
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM101/%' order by group_id
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM101/%'
Group 10000: 51.8111636552658
total TB /SUM101 = 51
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM102/%' order by group_id
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM102/%'
Group 100: 0.480201786569523
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM102/%'
Group 10000: 44.8752670877666
total TB /SUM102 = 45
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM103/%' order by group_id
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM103/%'
Group 100: 12.012143044074
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM103/%'
Group 10000: 64.6877531822065
total TB /SUM103 = 76
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM11/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM11/%'
Group 0: 8.56213205401127
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM11/%'
Group 1: 0.912022140491899
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM11/%'
Group 2: 0.419741926444658
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM11/%'
Group 3: 0.509387457859702
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM11/%'
Group 4: 0.244796419517115
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM11/%'
Group 5: 0.1270521573324
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM11/%'
Group 6: 3.82883130885693
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM11/%'
Group 7: 0.00337675890295941
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM11/%'
Group 8: 0.00456689811744582
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM11/%'
Group 9: 0.175300803713071
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM11/%'
Group 10: 7.80992493691883
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM11/%'
Group 11: 4.88169462187216e-07
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM11/%'
Group 12: 2.44098373514134e-07
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM11/%'
Group 100: 4.75178796196087
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM11/%'
Group 310: 0.211055998797747
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM11/%'
Group 311: 0.236152485275852
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM11/%'
Group 400: 0.0322330047783908
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM11/%'
Group 401: 0.0291448766802205
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM11/%'
Group 10000: 0.000469999956294487
total TB /SUM11 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM12/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM12/%'
Group 0: 8.24955268688791
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM12/%'
Group 1: 0.965532181111485
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM12/%'
Group 2: 0.571987774536865
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM12/%'
Group 3: 0.482528783309135
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM12/%'
Group 4: 0.217971984278847
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM12/%'
Group 5: 0.105572116213807
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM12/%'
Group 6: 3.80475499498971
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM12/%'
Group 7: 0.00308445482642128
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM12/%'
Group 8: 0.00461299128346582
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM12/%'
Group 9: 0.163302357049361
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM12/%'
Group 10: 7.88597136803219
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM12/%'
Group 11: 7.32254193280824e-07
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM12/%'
Group 12: 4.88198566017672e-07
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM12/%'
Group 100: 4.7580044659835
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM12/%'
Group 310: 0.179981415266411
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM12/%'
Group 311: 0.239399092658459
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM12/%'
Group 400: 0.0305745111563738
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM12/%'
Group 401: 0.0251609080596609
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM12/%'
Group 10000: 0.000457523885415867
total TB /SUM12 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM13/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM13/%'
Group 0: 8.21863149992259
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM13/%'
Group 1: 0.875358102705832
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM13/%'
Group 2: 0.584460718749142
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM13/%'
Group 3: 0.501487245122917
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM13/%'
Group 4: 0.308387213552123
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM13/%'
Group 5: 0.144647510192044
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM13/%'
Group 6: 3.80618163900454
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM13/%'
Group 7: 0.00327757176728483
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM13/%'
Group 8: 0.00432859264674335
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM13/%'
Group 9: 0.171392511009799
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM13/%'
Group 10: 7.90950133585102
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM13/%'
Group 100: 4.75252199972329
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM13/%'
Group 310: 0.222114314480677
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM13/%'
Group 311: 0.241623186926518
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM13/%'
Group 400: 0.0331906861938478
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM13/%'
Group 401: 0.024432330750642
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM13/%'
Group 10000: 0.000462338474790158
total TB /SUM13 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM14/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM14/%'
Group 0: 8.32374831938432
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM14/%'
Group 1: 0.887001170779513
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM14/%'
Group 2: 0.616656070720637
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM14/%'
Group 3: 0.513265210109239
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM14/%'
Group 4: 0.288878533378011
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM14/%'
Group 5: 0.132993445257853
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM14/%'
Group 6: 3.84871093722359
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM14/%'
Group 7: 0.00358074227551697
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM14/%'
Group 8: 0.00453974486117659
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM14/%'
Group 9: 0.193130780816318
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM14/%'
Group 10: 7.79803821091264
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM14/%'
Group 100: 4.75295167404693
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM14/%'
Group 310: 0.23149003598337
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM14/%'
Group 311: 0.241342328376959
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM14/%'
Group 400: 0.0275185804039211
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM14/%'
Group 401: 0.0244310951202351
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM14/%'
Group 10000: 0.000470686286462296
total TB /SUM14 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM15/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM15/%'
Group 0: 8.10095015256411
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM15/%'
Group 1: 1.10686542626718
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM15/%'
Group 2: 0.61034678685337
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM15/%'
Group 3: 0.507917130174064
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM15/%'
Group 4: 0.241795084104524
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM15/%'
Group 5: 0.135050045081698
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM15/%'
Group 6: 3.83755728035248
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM15/%'
Group 7: 0.00357934913790814
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM15/%'
Group 8: 0.0046077087354206
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM15/%'
Group 9: 0.180347927420371
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM15/%'
Group 10: 7.79102713353495
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM15/%'
Group 100: 4.75403490265671
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM15/%'
Group 310: 0.207847629646494
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM15/%'
Group 311: 0.229782312887437
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM15/%'
Group 400: 0.0335945550832548
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM15/%'
Group 401: 0.0271028702236435
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM15/%'
Group 10000: 0.000453288374956173
total TB /SUM15 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM16/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM16/%'
Group 0: 8.25167039278222
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM16/%'
Group 1: 0.817742739828645
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM16/%'
Group 2: 0.625899084585399
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM16/%'
Group 3: 0.524690100496628
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM16/%'
Group 4: 0.326582809489082
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM16/%'
Group 5: 0.138477710877851
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM16/%'
Group 6: 3.92681987908963
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM16/%'
Group 7: 0.00412247856456815
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM16/%'
Group 8: 0.00417670464412367
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM16/%'
Group 9: 0.17406817185838
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM16/%'
Group 10: 7.7980687767149
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM16/%'
Group 100: 4.75701810382816
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM16/%'
Group 310: 0.242767420250857
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM16/%'
Group 311: 0.246217376355162
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM16/%'
Group 400: 0.0350771751955108
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM16/%'
Group 401: 0.0275309260277936
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM16/%'
Group 10000: 0.000490577693199157
total TB /SUM16 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM17/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM17/%'
Group 0: 8.20775135162421
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM17/%'
Group 1: 0.937025815960624
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM17/%'
Group 2: 0.613306962939532
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM17/%'
Group 3: 0.503164449231008
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM17/%'
Group 4: 0.242357834496033
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM17/%'
Group 5: 0.124081513369674
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM17/%'
Group 6: 3.85838382192196
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM17/%'
Group 7: 0.00305897533507959
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM17/%'
Group 8: 0.00423571916326182
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM17/%'
Group 9: 0.185215384235562
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM17/%'
Group 10: 7.85446367977602
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM17/%'
Group 100: 4.75578317000145
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM17/%'
Group 310: 0.192071768652568
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM17/%'
Group 311: 0.232905280375235
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM17/%'
Group 400: 0.0327982716244151
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM17/%'
Group 401: 0.0230931687474367
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM17/%'
Group 10000: 0.000454773481578741
total TB /SUM17 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM18/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM18/%'
Group 0: 8.34009830210471
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM18/%'
Group 1: 0.808967055478206
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM18/%'
Group 2: 0.623888855681798
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM18/%'
Group 3: 0.516563192457397
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM18/%'
Group 4: 0.292067452250194
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM18/%'
Group 5: 0.144647509877359
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM18/%'
Group 6: 3.86303430834778
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM18/%'
Group 7: 0.00362309002957772
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM18/%'
Group 8: 0.00433580515527865
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM18/%'
Group 9: 0.187105408384014
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM18/%'
Group 10: 7.83489437008848
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM18/%'
Group 100: 4.750033307183
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM18/%'
Group 310: 0.226836812751571
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM18/%'
Group 311: 0.252537675897656
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM18/%'
Group 400: 0.0380790687268018
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM18/%'
Group 401: 0.0282232156423561
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM18/%'
Group 10000: 0.000477692907224991
total TB /SUM18 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM19/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM19/%'
Group 0: 8.25085843034958
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM19/%'
Group 1: 0.868352742204479
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM19/%'
Group 2: 0.633538941265215
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM19/%'
Group 3: 0.510585776708467
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM19/%'
Group 4: 0.297319789381618
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM19/%'
Group 5: 0.143733465581136
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM19/%'
Group 6: 3.83960818775813
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM19/%'
Group 7: 0.00377853845839127
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM19/%'
Group 8: 0.00442866284265619
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM19/%'
Group 9: 0.175267172129679
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM19/%'
Group 10: 7.85794865036041
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM19/%'
Group 100: 4.750967962701
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM19/%'
Group 310: 0.217811695036289
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM19/%'
Group 311: 0.246122828044463
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM19/%'
Group 400: 0.0379387363882415
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM19/%'
Group 401: 0.0302498131641187
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM19/%'
Group 10000: 0.000483843280562724
total TB /SUM19 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM2/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM2/%'
Group 0: 8.23985564025588
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM2/%'
Group 1: 1.04208491741247
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM2/%'
Group 2: 0.625492068425956
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM2/%'
Group 3: 0.512507386435573
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM2/%'
Group 4: 0.280437277532656
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM2/%'
Group 5: 0.13824920011848
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM2/%'
Group 6: 3.85284412358305
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM2/%'
Group 7: 0.0034515001498221
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM2/%'
Group 8: 0.00452326674803771
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM2/%'
Group 9: 0.159007456655672
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM2/%'
Group 10: 7.79795497250052
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM2/%'
Group 11: 3.07296968458104e-05
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM2/%'
Group 12: 3.70947927876841e-05
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM2/%'
Group 100: 4.75130756431554
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM2/%'
Group 310: 0.215930892291908
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM2/%'
Group 311: 0.252829818338796
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM2/%'
Group 400: 0.0358387800943092
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM2/%'
Group 401: 0.0316763624423402
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM2/%'
Group 10000: 0.00048953253099171
total TB /SUM2 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM20/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM20/%'
Group 0: 8.35031994178644
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM20/%'
Group 1: 0.846230438874045
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM20/%'
Group 2: 0.587393965112824
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM20/%'
Group 3: 0.510614773125781
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM20/%'
Group 4: 0.265055433545967
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM20/%'
Group 5: 0.123853002295618
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM20/%'
Group 6: 3.85609448430569
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM20/%'
Group 7: 0.00320460492821439
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM20/%'
Group 8: 0.00429833154430526
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM20/%'
Group 9: 0.179835573192577
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM20/%'
Group 10: 7.85228753458159
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM20/%'
Group 100: 4.75883433530271
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM20/%'
Group 310: 0.220071895845649
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM20/%'
Group 311: 0.269717354499335
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM20/%'
Group 400: 0.0336914613326371
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM20/%'
Group 401: 0.0285271019438369
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM20/%'
Group 10000: 0.000526410562088131
total TB /SUM20 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM21/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM21/%'
Group 0: 8.18517881814023
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM21/%'
Group 1: 0.938967161207074
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM21/%'
Group 2: 0.604906202546772
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM21/%'
Group 3: 0.493312084950958
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM21/%'
Group 4: 0.229977325921027
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM21/%'
Group 5: 0.11037084876898
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM21/%'
Group 6: 3.87132511540585
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM21/%'
Group 7: 0.00277749511406
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM21/%'
Group 8: 0.00455991774197173
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM21/%'
Group 9: 0.163926509502744
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM21/%'
Group 10: 7.8743135381701
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM21/%'
Group 100: 4.75596498852883
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM21/%'
Group 310: 0.195886999426875
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM21/%'
Group 311: 0.240754047131304
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM21/%'
Group 400: 0.0366187695844928
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM21/%'
Group 401: 0.0294151503667308
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM21/%'
Group 10000: 0.000451687816166668
total TB /SUM21 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM22/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM22/%'
Group 0: 7.88043898328488
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM22/%'
Group 1: 0.954525528615704
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM22/%'
Group 2: 0.623585165111763
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM22/%'
Group 3: 0.51000911679057
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM22/%'
Group 4: 0.354907912590534
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM22/%'
Group 5: 0.147846665071484
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM22/%'
Group 6: 4.03600839018964
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM22/%'
Group 7: 0.00348500810741825
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM22/%'
Group 8: 0.00448342301751836
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM22/%'
Group 9: 0.175732034964312
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM22/%'
Group 10: 7.84248703647154
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM22/%'
Group 100: 4.75281416028429
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM22/%'
Group 310: 0.226996506316937
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM22/%'
Group 311: 0.240663752039836
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM22/%'
Group 400: 0.075791076716996
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM22/%'
Group 401: 0.0558562952428474
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM22/%'
Group 10000: 0.00047365929458465
total TB /SUM22 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM3/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM3/%'
Group 0: 8.06914842276819
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM3/%'
Group 1: 1.08678921649516
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM3/%'
Group 2: 0.595652631897792
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM3/%'
Group 3: 0.493934758606883
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM3/%'
Group 4: 0.276122857874725
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM3/%'
Group 5: 0.128651734693449
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM3/%'
Group 6: 3.83896309919419
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM3/%'
Group 7: 0.00300898592013255
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM3/%'
Group 8: 0.00439373334756965
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM3/%'
Group 9: 0.178313598836212
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM3/%'
Group 10: 7.82672250736414
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM3/%'
Group 11: 1.8690298020374e-05
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM3/%'
Group 12: 5.94651410210645e-05
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM3/%'
Group 100: 4.75274145978437
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM3/%'
Group 310: 0.195325245261301
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM3/%'
Group 311: 0.239780216536019
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM3/%'
Group 400: 0.0309553619854341
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM3/%'
Group 401: 0.0182437568964815
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM3/%'
Group 10000: 0.000469138197331631
total TB /SUM3 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM30/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM30/%'
Group 0: 0.0240296475585637
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM30/%'
Group 2: 1.6195881409094
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM30/%'
Group 3: 1.3341951809407
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM30/%'
Group 6: 9.51150985734239
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM30/%'
Group 7: 4.68385867842335
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM30/%'
Group 30: 0.569536240487651
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM30/%'
Group 310: 1.75616382491171
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM30/%'
Group 311: 1.22793916218052
320
select sum(bytes) from sum_partn_alloc where group_id=320 and wd like '/SUM30/%'
Group 320: 0.00664894233523228
total TB /SUM30 = 20
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM31/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM31/%'
Group 0: 0.0293570396024734
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM31/%'
Group 2: 1.58629482005472
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM31/%'
Group 3: 1.33137067027019
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM31/%'
Group 6: 9.63114038148979
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM31/%'
Group 7: 4.56664050897507
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM31/%'
Group 30: 0.571300628906101
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM31/%'
Group 310: 1.77334534832335
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM31/%'
Group 311: 1.25067247863535
total TB /SUM31 = 20
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM32/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM32/%'
Group 0: 0.0485575674701977
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM32/%'
Group 2: 1.59917357812355
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM32/%'
Group 3: 1.32899984831329
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM32/%'
Group 6: 9.67228236928986
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM32/%'
Group 7: 4.51759337846943
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM32/%'
Group 30: 0.575212429749627
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM32/%'
Group 310: 1.77240160459314
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM32/%'
Group 311: 1.22633937616047
320
select sum(bytes) from sum_partn_alloc where group_id=320 and wd like '/SUM32/%'
Group 320: 0.0199436707353016
total TB /SUM32 = 20
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM33/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM33/%'
Group 0: 0.0731416264679865
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM33/%'
Group 2: 1.60608169270472
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM33/%'
Group 3: 1.34373694676742
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM33/%'
Group 6: 9.68646472053024
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM33/%'
Group 7: 4.55643201120711
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM33/%'
Group 30: 0.570190974876823
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM33/%'
Group 310: 1.74908634331587
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM33/%'
Group 311: 1.19931579095464
total TB /SUM33 = 20
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM4/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM4/%'
Group 0: 8.06219278384742
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM4/%'
Group 1: 1.02548966827999
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM4/%'
Group 2: 0.600550266518439
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM4/%'
Group 3: 0.508910743986235
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM4/%'
Group 4: 0.263929932766587
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM4/%'
Group 5: 0.136649622285404
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM4/%'
Group 6: 3.87287690994071
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM4/%'
Group 7: 0.0032174516500163
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM4/%'
Group 8: 0.00408537271414389
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM4/%'
Group 9: 0.186389214170958
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM4/%'
Group 10: 7.86015914616019
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM4/%'
Group 11: 7.32254193280824e-07
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM4/%'
Group 100: 4.75100208358162
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM4/%'
Group 310: 0.199875307466755
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM4/%'
Group 311: 0.251055719373653
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM4/%'
Group 400: 0.0358239538509224
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM4/%'
Group 401: 0.0223954509310715
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM4/%'
Group 10000: 0.000478987124552077
total TB /SUM4 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM40/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM40/%'
Group 0: 0.0260013016304583
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM40/%'
Group 2: 1.60034897554124
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM40/%'
Group 3: 1.31597200107717
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM40/%'
Group 6: 9.67841837835022
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM40/%'
Group 7: 4.55143772917927
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM40/%'
Group 30: 0.562133448571331
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM40/%'
Group 310: 1.73893297338691
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM40/%'
Group 311: 1.26285560602082
total TB /SUM40 = 20
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM41/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM41/%'
Group 0: 0.0316728298093949
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM41/%'
Group 2: 1.634966894836
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM41/%'
Group 3: 1.32325610996122
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM41/%'
Group 6: 9.66899775247384
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM41/%'
Group 7: 4.54585264621437
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM41/%'
Group 30: 0.571486101191113
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM41/%'
Group 310: 1.73869364363054
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM41/%'
Group 311: 1.22865150289908
total TB /SUM41 = 20
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM42/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM42/%'
Group 0: 0.0592506853572559
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM42/%'
Group 2: 1.60019068189013
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM42/%'
Group 3: 1.34460074035997
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM42/%'
Group 6: 9.67104636762633
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM42/%'
Group 7: 4.50138510534362
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM42/%'
Group 30: 0.572650213287488
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM42/%'
Group 310: 1.77512355179988
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM42/%'
Group 311: 1.2442974759133
total TB /SUM42 = 20
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM43/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM43/%'
Group 0: 0.0705335086822743
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM43/%'
Group 2: 1.59529980757088
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM43/%'
Group 3: 1.31858462434866
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM43/%'
Group 6: 9.71095264749147
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM43/%'
Group 7: 4.55310998384175
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM43/%'
Group 30: 0.571308582042548
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM43/%'
Group 310: 1.73377638343209
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM43/%'
Group 311: 1.22828520350959
total TB /SUM43 = 20
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM5/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM5/%'
Group 0: 8.01586052743642
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM5/%'
Group 1: 1.13225494255221
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM5/%'
Group 2: 0.601746903264029
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM5/%'
Group 3: 0.486933809945185
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM5/%'
Group 4: 0.220785736221842
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM5/%'
Group 5: 0.107171693733108
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM5/%'
Group 6: 3.76308807445821
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM5/%'
Group 7: 0.00281309416914155
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM5/%'
Group 8: 0.00455431636692083
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM5/%'
Group 9: 0.176205876547101
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM5/%'
Group 10: 7.92254553845669
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM5/%'
Group 11: 1.2527649232652e-05
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM5/%'
Group 12: 2.44098373514134e-07
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM5/%'
Group 100: 4.75073294759568
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM5/%'
Group 310: 0.162655795942555
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM5/%'
Group 311: 0.242942084532842
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM5/%'
Group 400: 0.0381974104648179
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM5/%'
Group 401: 0.0233248786125841
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM5/%'
Group 10000: 0.000494163527037017
total TB /SUM5 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM6/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM6/%'
Group 0: 8.05320934897372
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM6/%'
Group 1: 1.08222225314876
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM6/%'
Group 2: 0.626482288839725
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM6/%'
Group 3: 0.509915873660248
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM6/%'
Group 4: 0.275372524023624
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM6/%'
Group 5: 0.130251312369182
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM6/%'
Group 6: 3.84203059703032
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM6/%'
Group 7: 0.00331886511139601
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM6/%'
Group 8: 0.00445980864606099
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM6/%'
Group 9: 0.172571234795214
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM6/%'
Group 10: 7.84136846888578
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM6/%'
Group 11: 1.31587285068235e-05
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM6/%'
Group 12: 4.81579145343858e-05
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM6/%'
Group 100: 4.74938024358471
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM6/%'
Group 310: 0.199897547894579
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM6/%'
Group 311: 0.247049860952757
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM6/%'
Group 400: 0.0308745387883391
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM6/%'
Group 401: 0.0285739536357141
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM6/%'
Group 10000: 0.000479047260341758
total TB /SUM6 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM7/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM7/%'
Group 0: 8.18120303122942
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM7/%'
Group 1: 1.04258137279521
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM7/%'
Group 2: 0.649168738426852
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM7/%'
Group 3: 0.514791709096244
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM7/%'
Group 4: 0.316640885936067
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM7/%'
Group 5: 0.14761815415477
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM7/%'
Group 6: 3.78238412373412
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM7/%'
Group 7: 0.00391485782711243
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM7/%'
Group 8: 0.00448450710791803
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM7/%'
Group 9: 0.17064272310472
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM7/%'
Group 10: 7.78331170181445
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM7/%'
Group 11: 3.65053510904545e-05
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM7/%'
Group 12: 3.70947918781894e-05
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM7/%'
Group 100: 4.74803469725521
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM7/%'
Group 310: 0.225958763286144
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM7/%'
Group 311: 0.244087430723994
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM7/%'
Group 400: 0.0361651503271787
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM7/%'
Group 401: 0.0259493754729192
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM7/%'
Group 10000: 0.000517057094839402
total TB /SUM7 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM8/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM8/%'
Group 0: 8.22033867322898
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM8/%'
Group 1: 1.01495679005893
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM8/%'
Group 2: 0.647473491194432
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM8/%'
Group 3: 0.524284157353577
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM8/%'
Group 4: 0.308574797014444
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM8/%'
Group 5: 0.146475598469806
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM8/%'
Group 6: 3.72081655666443
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM8/%'
Group 7: 0.00377863629819331
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM8/%'
Group 8: 0.00435001736150298
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM8/%'
Group 9: 0.177068857988161
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM8/%'
Group 10: 7.81790881597135
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM8/%'
Group 11: 3.08558946926496e-05
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM8/%'
Group 12: 3.68506962331594e-05
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM8/%'
Group 100: 4.74952545548422
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM8/%'
Group 310: 0.243833246431677
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM8/%'
Group 311: 0.24769264317365
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM8/%'
Group 400: 0.0342815416206577
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM8/%'
Group 401: 0.0251987627625567
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM8/%'
Group 10000: 0.000471084580567549
total TB /SUM8 = 27
SQL: select distinct(group_id) from sum_partn_alloc where wd like '/SUM9/%' order by group_id
0
select sum(bytes) from sum_partn_alloc where group_id=0 and wd like '/SUM9/%'
Group 0: 8.39349992266671
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM9/%'
Group 1: 0.970485715493851
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM9/%'
Group 2: 0.566139332219791
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM9/%'
Group 3: 0.499428231555612
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM9/%'
Group 4: 0.225850489729964
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM9/%'
Group 5: 0.126823646101002
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM9/%'
Group 6: 3.77977224478673
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM9/%'
Group 7: 0.00287890588515438
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM9/%'
Group 8: 0.00408474662526714
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM9/%'
Group 9: 0.164425772702998
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM9/%'
Group 10: 7.72719025875995
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM9/%'
Group 11: 9.7633801487973e-07
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM9/%'
Group 12: 2.44098373514134e-07
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM9/%'
Group 100: 4.74813689092207
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM9/%'
Group 310: 0.210143770140348
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM9/%'
Group 311: 0.230196251266534
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM9/%'
Group 400: 0.0386958975477683
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM9/%'
Group 401: 0.029898576011874
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM9/%'
Group 10000: 0.000492052425215661
total TB /SUM9 = 27
Debugged program terminated.  Use q to quit or R to restart,
  use o inhibit_exit to avoid stopping after program termination,
  h q, h R or h o to get additional info.  
  DB<1> q
csh> ^Dexit

Script done on Wed Feb  8 10:09:57 2012