Script started on Tue Feb  7 16:00:22 2012
csh> look.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.pl:1):	eval 'exec /home/jsoc/bin/$JSOC_MACHINE/perl -d -S  $0 "$@"'
main::(./look.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: 9011790694032
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM0/%'
Group 1: 1038968331208
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM0/%'
Group 2: 689574597277
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM0/%'
Group 3: 567449339123
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM0/%'
Group 4: 250387741586
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM0/%'
Group 5: 132157806658
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM0/%'
Group 6: 4136722076345
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM0/%'
Group 7: 3292912393
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM0/%'
Group 8: 4708039533
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM0/%'
Group 9: 197651493910
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM0/%'
Group 10: 8581155617622
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM0/%'
Group 11: 805121
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM0/%'
Group 12: 1341948
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM0/%'
Group 100: 5189728304931
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM0/%'
Group 310: 242932187609
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM0/%'
Group 311: 263380503631
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM0/%'
Group 400: 35560026611
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM0/%'
Group 401: 28796129474
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM0/%'
Group 10000: 516744358
total bytes /SUM0 = 30,374,774,693,370
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: 9014497159547
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM1/%'
Group 1: 1100222010552
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM1/%'
Group 2: 654897682914
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM1/%'
Group 3: 574457286655
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM1/%'
Group 4: 280087770243
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM1/%'
Group 5: 130901553916
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM1/%'
Group 6: 4145091151742
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM1/%'
Group 7: 3349068580
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM1/%'
Group 8: 4450447274
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM1/%'
Group 9: 186414205491
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM1/%'
Group 10: 8627118777184
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM1/%'
Group 11: 33389668
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM1/%'
Group 12: 42744181
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM1/%'
Group 100: 5199275790000
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM1/%'
Group 310: 244123271494
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM1/%'
Group 311: 280925940681
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM1/%'
Group 400: 33548380696
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM1/%'
Group 401: 29641392342
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM1/%'
Group 10000: 490193628
total bytes /SUM1 = 30,509,568,216,788
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: 9214595410221
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM10/%'
Group 1: 1191373030987
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM10/%'
Group 2: 532738944174
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM10/%'
Group 3: 544417558410
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM10/%'
Group 4: 241106482631
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM10/%'
Group 5: 120349029257
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM10/%'
Group 6: 4165063028451
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM10/%'
Group 7: 3441441944
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM10/%'
Group 8: 4798967969
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM10/%'
Group 9: 189840641931
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM10/%'
Group 10: 8581204679660
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM10/%'
Group 11: 805122
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM10/%'
Group 100: 5199542707464
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM10/%'
Group 310: 217798008935
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM10/%'
Group 311: 255963381137
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM10/%'
Group 400: 35030467043
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM10/%'
Group 401: 27076727909
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM10/%'
Group 10000: 505143827
total bytes /SUM10 = 30,524,846,457,072
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: 3916366062614
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM100/%'
Group 10000: 53496994135734
total bytes /SUM100 = 57,413,360,198,348
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: 56966976887570
total bytes /SUM101 = 56,966,976,887,570
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: 527987448012
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM102/%'
Group 10000: 49340877962553
total bytes /SUM102 = 49,868,865,410,565
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: 13207490951468
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM103/%'
Group 10000: 71124936798540
total bytes /SUM103 = 84,332,427,750,008
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: 9360804421083
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM11/%'
Group 1: 1010395870283
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM11/%'
Group 2: 476046247285
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM11/%'
Group 3: 568654625822
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM11/%'
Group 4: 263175253926
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM11/%'
Group 5: 134921563244
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM11/%'
Group 6: 4209844544881
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM11/%'
Group 7: 3535550596
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM11/%'
Group 8: 5021357583
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM11/%'
Group 9: 192745272041
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM11/%'
Group 10: 8544298311866
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM11/%'
Group 11: 536748
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM11/%'
Group 12: 268389
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM11/%'
Group 100: 5199046150716
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM11/%'
Group 310: 254902022618
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM11/%'
Group 311: 268437249681
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM11/%'
Group 400: 35440563552
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM11/%'
Group 401: 32045130800
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM11/%'
Group 10000: 516770417
total bytes /SUM11 = 30,559,831,711,531
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: 9073243973446
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM12/%'
Group 1: 1064853139629
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM12/%'
Group 2: 654568469415
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM12/%'
Group 3: 548355440989
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM12/%'
Group 4: 237393979055
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM12/%'
Group 5: 112057760018
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM12/%'
Group 6: 4183372357830
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM12/%'
Group 7: 3345759798
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM12/%'
Group 8: 5072037555
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM12/%'
Group 9: 179552840419
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM12/%'
Group 10: 8632109292823
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM12/%'
Group 11: 805122
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM12/%'
Group 12: 536780
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM12/%'
Group 100: 5205898489623
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM12/%'
Group 310: 224498240064
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM12/%'
Group 311: 272926220464
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM12/%'
Group 400: 33617030530
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM12/%'
Group 401: 27664710977
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM12/%'
Group 10000: 503052832
total bytes /SUM12 = 30,459,034,137,369
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: 8978795312064
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM13/%'
Group 1: 970664479015
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM13/%'
Group 2: 654384961926
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM13/%'
Group 3: 562521235937
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM13/%'
Group 4: 332887821188
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM13/%'
Group 5: 151252851312
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM13/%'
Group 6: 4184940969513
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM13/%'
Group 7: 3457068993
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM13/%'
Group 8: 4759337947
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM13/%'
Group 9: 188448058769
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM13/%'
Group 10: 8654281605946
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM13/%'
Group 100: 5199921367062
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM13/%'
Group 310: 262727953422
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM13/%'
Group 311: 278329103216
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM13/%'
Group 400: 36493545404
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM13/%'
Group 401: 26863631754
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM13/%'
Group 10000: 508346529
total bytes /SUM13 = 30,491,237,649,997
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: 9066893192354
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM14/%'
Group 1: 974891864723
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM14/%'
Group 2: 690584196230
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM14/%'
Group 3: 573260317200
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM14/%'
Group 4: 310819049897
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM14/%'
Group 5: 136429066742
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM14/%'
Group 6: 4231702427426
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM14/%'
Group 7: 3802831720
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM14/%'
Group 8: 4991502262
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM14/%'
Group 9: 212349549485
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM14/%'
Group 10: 8534669775860
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM14/%'
Group 100: 5200475062224
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM14/%'
Group 310: 270418917320
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM14/%'
Group 311: 278699768387
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM14/%'
Group 400: 30256999134
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM14/%'
Group 401: 26862273164
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM14/%'
Group 10000: 517525045
total bytes /SUM14 = 30,547,624,319,173
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: 8874188047159
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM15/%'
Group 1: 1278994207926
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM15/%'
Group 2: 684085840804
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM15/%'
Group 3: 569150964022
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM15/%'
Group 4: 257193998154
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM15/%'
Group 5: 142710331490
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM15/%'
Group 6: 4219438852004
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM15/%'
Group 7: 3731588856
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM15/%'
Group 8: 5066229332
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM15/%'
Group 9: 198294643244
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM15/%'
Group 10: 8526961325800
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM15/%'
Group 100: 5201628305997
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM15/%'
Group 310: 249639691798
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM15/%'
Group 311: 269726573023
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM15/%'
Group 400: 36937603944
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM15/%'
Group 401: 29799920957
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM15/%'
Group 10000: 498395839
total bytes /SUM15 = 30,548,046,520,349
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: 9033610758955
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM16/%'
Group 1: 898521766642
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM16/%'
Group 2: 688183321316
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM16/%'
Group 3: 576913974107
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM16/%'
Group 4: 340931578953
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM16/%'
Group 5: 135424064237
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM16/%'
Group 6: 4317584117241
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM16/%'
Group 7: 4186997822
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM16/%'
Group 8: 4592335322
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM16/%'
Group 9: 191389978984
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM16/%'
Group 10: 8539145329733
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM16/%'
Group 100: 5204849816310
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM16/%'
Group 310: 266925601411
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM16/%'
Group 311: 270718868263
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM16/%'
Group 400: 38567761997
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM16/%'
Group 401: 30270573291
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM16/%'
Group 10000: 539395878
total bytes /SUM16 = 30,542,356,240,462
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: 8950231491860
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM17/%'
Group 1: 1112324528811
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM17/%'
Group 2: 680383436270
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM17/%'
Group 3: 558836047424
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM17/%'
Group 4: 257812748753
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM17/%'
Group 5: 126630294005
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM17/%'
Group 6: 4242337876626
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM17/%'
Group 7: 3222841793
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM17/%'
Group 8: 4657222472
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM17/%'
Group 9: 203646468610
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM17/%'
Group 10: 8593027148163
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM17/%'
Group 100: 5203501933998
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM17/%'
Group 310: 221107652536
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM17/%'
Group 311: 263432243371
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM17/%'
Group 400: 36062081022
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM17/%'
Group 401: 25391207560
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM17/%'
Group 10000: 500028731
total bytes /SUM17 = 30,483,105,252,005
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: 9119668576538
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM18/%'
Group 1: 888840896176
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM18/%'
Group 2: 688255091106
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM18/%'
Group 3: 571183288588
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM18/%'
Group 4: 306900296113
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM18/%'
Group 5: 142961581727
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM18/%'
Group 6: 4247451140526
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM18/%'
Group 7: 3648376970
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM18/%'
Group 8: 4767268184
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM18/%'
Group 9: 205724572138
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM18/%'
Group 10: 8570744595091
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM18/%'
Group 100: 5197367747109
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM18/%'
Group 310: 251838001744
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM18/%'
Group 311: 284123212749
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM18/%'
Group 400: 41868378840
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM18/%'
Group 401: 31031753772
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM18/%'
Group 10000: 525228906
total bytes /SUM18 = 30,556,900,006,277
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: 8974959073512
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM19/%'
Group 1: 960060812302
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM19/%'
Group 2: 709853980946
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM19/%'
Group 3: 573330802388
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM19/%'
Group 4: 317831556837
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM19/%'
Group 5: 149996598051
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM19/%'
Group 6: 4221693848544
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM19/%'
Group 7: 3927211084
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM19/%'
Group 8: 4869366291
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM19/%'
Group 9: 192708293724
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM19/%'
Group 10: 8604235726193
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM19/%'
Group 100: 5197873976862
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM19/%'
Group 310: 253413622814
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM19/%'
Group 311: 280558567424
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM19/%'
Group 400: 41714081802
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM19/%'
Group 401: 33260021312
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM19/%'
Group 10000: 531991313
total bytes /SUM19 = 30,520,819,531,399
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: 8965094623825
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM2/%'
Group 1: 1151421732667
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM2/%'
Group 2: 699222061292
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM2/%'
Group 3: 576563979251
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM2/%'
Group 4: 301950291340
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM2/%'
Group 5: 146227839652
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM2/%'
Group 6: 4236246913888
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM2/%'
Group 7: 3622899807
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM2/%'
Group 8: 4973384385
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM2/%'
Group 9: 174830547496
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM2/%'
Group 10: 8537541580350
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM2/%'
Group 11: 33787659
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM2/%'
Group 12: 40786156
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM2/%'
Group 100: 5198383478823
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM2/%'
Group 310: 251492682993
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM2/%'
Group 311: 286458648526
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM2/%'
Group 400: 39405155439
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM2/%'
Group 401: 34828528831
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM2/%'
Group 10000: 538246710
total bytes /SUM2 = 30,608,877,169,090
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: 9133653009396
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM20/%'
Group 1: 940712055328
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM20/%'
Group 2: 657451813166
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM20/%'
Group 3: 571269851892
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM20/%'
Group 4: 286481526413
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM20/%'
Group 5: 125625291673
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM20/%'
Group 6: 4239820723297
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM20/%'
Group 7: 3228680401
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM20/%'
Group 8: 4726065513
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM20/%'
Group 9: 197731303813
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM20/%'
Group 10: 8588931516411
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM20/%'
Group 100: 5206720901568
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM20/%'
Group 310: 260169007588
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM20/%'
Group 311: 306513142299
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM20/%'
Group 400: 37044153492
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM20/%'
Group 401: 31365880294
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM20/%'
Group 10000: 578794534
total bytes /SUM20 = 30,592,023,717,078
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: 9013396299948
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM21/%'
Group 1: 1033883781182
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM21/%'
Group 2: 682300488895
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM21/%'
Group 3: 557451772996
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM21/%'
Group 4: 253275244373
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM21/%'
Group 5: 119344026925
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM21/%'
Group 6: 4256566979290
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM21/%'
Group 7: 3002907490
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM21/%'
Group 8: 5013682579
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM21/%'
Group 9: 183448747785
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM21/%'
Group 10: 8614385816195
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM21/%'
Group 100: 5203469366421
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM21/%'
Group 310: 237849179541
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM21/%'
Group 311: 275195425421
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM21/%'
Group 400: 40262762953
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM21/%'
Group 401: 32342299861
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM21/%'
Group 10000: 496636006
total bytes /SUM21 = 30,511,685,417,861
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: 8598229683199
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM22/%'
Group 1: 1049005882471
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM22/%'
Group 2: 692196428698
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM22/%'
Group 3: 567513459987
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM22/%'
Group 4: 378056614942
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM22/%'
Group 5: 153514106386
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM22/%'
Group 6: 4437638154815
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM22/%'
Group 7: 3553449982
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM22/%'
Group 8: 4929575740
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM22/%'
Group 9: 193222456251
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM22/%'
Group 10: 8580339646550
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM22/%'
Group 100: 5200377414558
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM22/%'
Group 310: 253316092076
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM22/%'
Group 311: 275800479627
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM22/%'
Group 400: 83333170132
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM22/%'
Group 401: 61414646104
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM22/%'
Group 10000: 520793902
total bytes /SUM22 = 30,532,962,055,420
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: 8811798300827
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM3/%'
Group 1: 1293453832201
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM3/%'
Group 2: 663956182315
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM3/%'
Group 3: 550763962630
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM3/%'
Group 4: 295969035565
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM3/%'
Group 5: 133916560739
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM3/%'
Group 6: 4220984566167
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM3/%'
Group 7: 3151236182
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM3/%'
Group 8: 4830960905
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM3/%'
Group 9: 196057875311
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM3/%'
Group 10: 8565253955099
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM3/%'
Group 11: 20550200
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM3/%'
Group 12: 65382614
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM3/%'
Group 100: 5200027913808
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM3/%'
Group 310: 227095024990
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM3/%'
Group 311: 271054900916
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM3/%'
Group 400: 34035780445
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM3/%'
Group 401: 20059222842
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM3/%'
Group 10000: 515822903
total bytes /SUM3 = 30,493,011,066,659
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: 60058417974
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM30/%'
Group 2: 1708626060957
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM30/%'
Group 3: 1414724087051
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM30/%'
Group 6: 10542770854087
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM30/%'
Group 7: 5251210729896
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM30/%'
Group 30: 626211718856
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM30/%'
Group 310: 1897283108741
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM30/%'
Group 311: 1322935856511
320
select sum(bytes) from sum_partn_alloc where group_id=320 and wd like '/SUM30/%'
Group 320: 7310589410
total bytes /SUM30 = 22,831,131,423,483
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: 37822693542
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM31/%'
Group 2: 1674116624221
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM31/%'
Group 3: 1406684522405
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM31/%'
Group 6: 10683580680198
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM31/%'
Group 7: 5118960759961
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM31/%'
Group 30: 628151684438
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM31/%'
Group 310: 1912404917389
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM31/%'
Group 311: 1350308994609
total bytes /SUM31 = 22,812,030,876,763
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: 83236023934
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM32/%'
Group 2: 1699571740229
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM32/%'
Group 3: 1404247836077
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM32/%'
Group 6: 10726508609272
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM32/%'
Group 7: 5056333390124
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM32/%'
Group 30: 632452754951
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM32/%'
Group 310: 1911496250693
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM32/%'
Group 311: 1322686904104
320
select sum(bytes) from sum_partn_alloc where group_id=320 and wd like '/SUM32/%'
Group 320: 21928297874
total bytes /SUM32 = 22,858,461,807,258
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: 141738404738
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM33/%'
Group 2: 1701246678525
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM33/%'
Group 3: 1425155723542
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM33/%'
Group 6: 10735955482283
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM33/%'
Group 7: 5104717427448
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM33/%'
Group 30: 626931606930
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM33/%'
Group 310: 1886253879376
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM33/%'
Group 311: 1291148659382
total bytes /SUM33 = 22,913,147,862,224
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: 8839148150363
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM4/%'
Group 1: 1134625260302
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM4/%'
Group 2: 672574573609
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM4/%'
Group 3: 570055871280
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM4/%'
Group 4: 284831524821
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM4/%'
Group 5: 145725338140
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM4/%'
Group 6: 4258273195425
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM4/%'
Group 7: 3402904482
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM4/%'
Group 8: 4491914803
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM4/%'
Group 9: 204937108273
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM4/%'
Group 10: 8598549493515
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM4/%'
Group 11: 805122
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM4/%'
Group 100: 5198177129739
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM4/%'
Group 310: 229112492617
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM4/%'
Group 311: 289895436343
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM4/%'
Group 400: 39388853812
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM4/%'
Group 401: 24624058708
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM4/%'
Group 10000: 526651913
total bytes /SUM4 = 30,498,340,763,267
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: 36433227478
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM40/%'
Group 2: 1694399019427
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM40/%'
Group 3: 1393382295169
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM40/%'
Group 6: 10719020189110
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM40/%'
Group 7: 5098365860070
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM40/%'
Group 30: 618072263066
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM40/%'
Group 310: 1876495915239
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM40/%'
Group 311: 1369959975221
total bytes /SUM40 = 22,806,128,744,780
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: 173489412332
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM41/%'
Group 2: 1735175457512
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM41/%'
Group 3: 1401458921943
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM41/%'
Group 6: 10704142760571
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM41/%'
Group 7: 5101915463123
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM41/%'
Group 30: 628355613372
39
select sum(bytes) from sum_partn_alloc where group_id=39 and wd like '/SUM41/%'
Group 39: 2474007
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM41/%'
Group 310: 1876804642273
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM41/%'
Group 311: 1322875193547
total bytes /SUM41 = 22,944,219,938,680
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: 75503300922
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM42/%'
Group 2: 1698967956542
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM42/%'
Group 3: 1426212829946
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM42/%'
Group 6: 10712954027590
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM42/%'
Group 7: 5046472142309
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM42/%'
Group 30: 629635568158
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM42/%'
Group 310: 1918941246565
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM42/%'
Group 311: 1336881518196
total bytes /SUM42 = 22,845,568,590,228
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: 82879595882
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM43/%'
Group 2: 1687938100212
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM43/%'
Group 3: 1395377143590
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM43/%'
Group 6: 10758894933142
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM43/%'
Group 7: 5100026661863
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM43/%'
Group 30: 628160429004
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM43/%'
Group 310: 1872247101751
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM43/%'
Group 311: 1329231478147
total bytes /SUM43 = 22,854,755,443,591
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: 8821966654093
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM5/%'
Group 1: 1248644543799
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM5/%'
Group 2: 685310299613
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM5/%'
Group 3: 554009030465
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM5/%'
Group 4: 239456481039
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM5/%'
Group 5: 118087774011
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM5/%'
Group 6: 4137559094212
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM5/%'
Group 7: 3085494747
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM5/%'
Group 8: 5007523802
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM5/%'
Group 9: 193740410146
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM5/%'
Group 10: 8669626126870
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM5/%'
Group 11: 13774296
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM5/%'
Group 12: 268389
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM5/%'
Group 100: 5197894953402
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM5/%'
Group 310: 205482845252
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM5/%'
Group 311: 278220115877
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM5/%'
Group 400: 41998496957
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM5/%'
Group 401: 25645975251
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM5/%'
Group 10000: 543338544
total bytes /SUM5 = 30,426,293,200,765
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: 8799506293586
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM6/%'
Group 1: 1199850141155
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM6/%'
Group 2: 701267214856
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM6/%'
Group 3: 570886776543
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM6/%'
Group 4: 294525284174
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM6/%'
Group 5: 134419062078
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM6/%'
Group 6: 4224357315706
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM6/%'
Group 7: 3517291552
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM6/%'
Group 8: 4903611464
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM6/%'
Group 9: 189744079277
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM6/%'
Group 10: 8580833937530
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM6/%'
Group 11: 14468175
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM6/%'
Group 12: 52950187
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM6/%'
Group 100: 5196475395336
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM6/%'
Group 310: 238457236453
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM6/%'
Group 311: 286473836906
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM6/%'
Group 400: 33946914400
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM6/%'
Group 401: 31417394274
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM6/%'
Group 10000: 526718033
total bytes /SUM6 = 30,491,175,921,685
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: 8920311016578
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM7/%'
Group 1: 1145502645260
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM7/%'
Group 2: 723168470763
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM7/%'
Group 3: 572679529505
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM7/%'
Group 4: 339900327956
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM7/%'
Group 5: 155272860640
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM7/%'
Group 6: 4158775324761
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM7/%'
Group 7: 4087908075
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM7/%'
Group 8: 4930767710
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM7/%'
Group 9: 187623658249
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM7/%'
Group 10: 8514776041375
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM7/%'
Group 11: 40138058
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM7/%'
Group 12: 40786155
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM7/%'
Group 100: 5195045267403
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM7/%'
Group 310: 257187077367
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM7/%'
Group 311: 275323511168
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM7/%'
Group 400: 39764003305
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM7/%'
Group 401: 28531640066
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM7/%'
Group 10000: 568510288
total bytes /SUM7 = 30,523,529,484,682
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: 9008627590822
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM8/%'
Group 1: 1115154727114
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM8/%'
Group 2: 711904632245
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM8/%'
Group 3: 576456527269
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM8/%'
Group 4: 319687808451
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM8/%'
Group 5: 143966584059
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM8/%'
Group 6: 4091081068874
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM8/%'
Group 7: 3832872359
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM8/%'
Group 8: 4782894670
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM8/%'
Group 9: 194689268275
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM8/%'
Group 10: 8553143728999
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM8/%'
Group 11: 33926415
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM8/%'
Group 12: 40517769
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM8/%'
Group 100: 5196768697296
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM8/%'
Group 310: 268097489690
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM8/%'
Group 311: 272340941284
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM8/%'
Group 400: 37692953630
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM8/%'
Group 401: 27706332663
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM8/%'
Group 10000: 517962974
total bytes /SUM8 = 30,526,526,524,858
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: 9221940833963
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM9/%'
Group 1: 1066783973224
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM9/%'
Group 2: 636060348576
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM9/%'
Group 3: 564536575511
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM9/%'
Group 4: 247500238801
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM9/%'
Group 5: 138439071233
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM9/%'
Group 6: 4155903533488
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM9/%'
Group 7: 3066114766
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM9/%'
Group 8: 4491226411
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM9/%'
Group 9: 182034998563
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM9/%'
Group 10: 8453795342572
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM9/%'
Group 11: 1073495
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM9/%'
Group 12: 268389
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM9/%'
Group 100: 5194957796529
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM9/%'
Group 310: 255505370319
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM9/%'
Group 311: 267287817151
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM9/%'
Group 400: 42546589301
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM9/%'
Group 401: 32873831979
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM9/%'
Group 10000: 541017363
total bytes /SUM9 = 30,468,266,021,634
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> 
csh> ^Dexit

Script done on Tue Feb  7 16:32:41 2012