Script started on Mon Feb  6 20:20:20 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: 8945381283035
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM0/%'
Group 1: 1049331283361
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM0/%'
Group 2: 701905922238
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM0/%'
Group 3: 577006552761
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM0/%'
Group 4: 238837730442
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM0/%'
Group 5: 122610284504
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: 3183831743
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: 8544994141875
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: 5164159679115
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM0/%'
Group 310: 262679445343
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM0/%'
Group 311: 270818493755
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,284,865,305,472
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: 8905150831174
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM1/%'
Group 1: 1106303286142
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM1/%'
Group 2: 667230986988
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM1/%'
Group 3: 583961218209
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM1/%'
Group 4: 269569010094
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM1/%'
Group 5: 121102781006
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: 3191515249
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: 8591686767760
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: 5173627211631
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM1/%'
Group 310: 259951991958
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM1/%'
Group 311: 290226447532
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,371,713,952,765
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: 9249668204654
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM10/%'
Group 1: 1236431670574
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM10/%'
Group 2: 555317022966
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM10/%'
Group 3: 562394971075
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM10/%'
Group 4: 240487732034
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM10/%'
Group 5: 121354031589
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: 3414237240
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: 192113970509
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM10/%'
Group 10: 8545295751034
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: 5174039502603
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM10/%'
Group 310: 251074241689
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM10/%'
Group 311: 275395593241
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,639,462,069,529
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: 9269154273462
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM11/%'
Group 1: 1010028333394
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM11/%'
Group 2: 487719145867
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM11/%'
Group 3: 576832677349
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM11/%'
Group 4: 254512745568
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM11/%'
Group 5: 124369038585
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: 3337004213
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: 192745772100
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM11/%'
Group 10: 8506153438351
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: 5173497477654
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM11/%'
Group 310: 265593229706
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM11/%'
Group 311: 276870234995
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,423,682,543,614
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: 9084503436889
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM12/%'
Group 1: 1075031591066
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM12/%'
Group 2: 678706755176
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM12/%'
Group 3: 565575563297
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM12/%'
Group 4: 234300226069
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: 3276564284
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: 181251450849
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM12/%'
Group 10: 8601567904859
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: 5180311413615
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM12/%'
Group 310: 263621473138
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM12/%'
Group 311: 290635499201
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,521,070,170,087
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: 8881549610822
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM13/%'
Group 1: 970528908975
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM13/%'
Group 2: 666656547673
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM13/%'
Group 3: 572017804108
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM13/%'
Group 4: 320100308850
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM13/%'
Group 5: 133414059573
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: 3207105769
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: 188451099204
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM13/%'
Group 10: 8622772973178
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM13/%'
Group 100: 5174230843776
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM13/%'
Group 310: 277333917631
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM13/%'
Group 311: 285451564576
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,349,280,575,282
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: 9002249712603
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM14/%'
Group 1: 974483090874
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: 290812780594
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM14/%'
Group 5: 120097778674
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: 3429335184
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: 8499282933476
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM14/%'
Group 100: 5174675861064
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,384,674,968,122
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: 8755039607478
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM15/%'
Group 1: 1284626928795
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM15/%'
Group 2: 694549964196
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM15/%'
Group 3: 579133024618
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM15/%'
Group 4: 247087738403
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM15/%'
Group 5: 131655305492
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: 3499557868
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: 198294653314
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM15/%'
Group 10: 8489325333727
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM15/%'
Group 100: 5176136792706
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM15/%'
Group 310: 268281106930
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM15/%'
Group 311: 283923053922
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,403,294,069,525
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: 8983478530110
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM16/%'
Group 1: 898192406495
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: 322575311242
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM16/%'
Group 5: 116329019929
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: 3808545814
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: 8503215126547
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM16/%'
Group 100: 5179540308651
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,392,825,176,598
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: 8863854567476
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM17/%'
Group 1: 1125041219340
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM17/%'
Group 2: 695121012680
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM17/%'
Group 3: 570647950389
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM17/%'
Group 4: 249356490594
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM17/%'
Group 5: 116329019929
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: 3060681965
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: 8558822369704
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM17/%'
Group 100: 5177797747965
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM17/%'
Group 310: 237064396760
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM17/%'
Group 311: 272708533801
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,382,398,875,624
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: 9061608318293
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM18/%'
Group 1: 888678909120
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: 289987779795
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM18/%'
Group 5: 124620289168
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: 3333767440
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: 8538794058161
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM18/%'
Group 100: 5171707466667
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,405,498,525,197
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: 8912611531083
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM19/%'
Group 1: 959922825199
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM19/%'
Group 2: 710076687849
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM19/%'
Group 3: 573340500184
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM19/%'
Group 4: 294319034151
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM19/%'
Group 5: 132409057241
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: 3579248111
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: 8571526790460
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM19/%'
Group 100: 5172193664115
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM19/%'
Group 310: 253879328682
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM19/%'
Group 311: 284295731536
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,362,932,001,597
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: 8873229702594
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM2/%'
Group 1: 1151353451303
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM2/%'
Group 2: 699238519337
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM2/%'
Group 3: 576692695017
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM2/%'
Group 4: 283800273828
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM2/%'
Group 5: 124369038585
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: 3253246138
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: 8505068942778
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: 5172716806182
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,418,571,357,845
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: 9062389461974
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM20/%'
Group 1: 940547729301
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM20/%'
Group 2: 667087230239
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM20/%'
Group 3: 579557755274
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM20/%'
Group 4: 273487763876
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM20/%'
Group 5: 111304008269
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: 2986412741
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: 197731803872
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM20/%'
Group 10: 8554998310353
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM20/%'
Group 100: 5181533781258
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM20/%'
Group 310: 269132432482
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM20/%'
Group 311: 315322204912
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,469,614,511,681
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: 8917677175095
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM21/%'
Group 1: 1045034800931
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM21/%'
Group 2: 693969677679
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM21/%'
Group 3: 568022410631
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM21/%'
Group 4: 238837730443
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM21/%'
Group 5: 110550256520
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: 2764624248
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: 8581171259180
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM21/%'
Group 100: 5177624893293
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM21/%'
Group 310: 258827132654
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM21/%'
Group 311: 283628416721
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,396,239,485,869
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: 8541981457139
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM22/%'
Group 1: 1048798171434
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: 361762849221
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM22/%'
Group 5: 132911558407
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: 3210294552
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: 8545893486730
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM22/%'
Group 100: 5174884526355
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,379,327,601,170
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: 8701625298421
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM3/%'
Group 1: 1303872976525
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM3/%'
Group 2: 677947989465
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM3/%'
Group 3: 562207328184
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM3/%'
Group 4: 287306527207
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM3/%'
Group 5: 124871539751
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: 3082912877
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: 8529542577114
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: 5174739414003
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM3/%'
Group 310: 239005776881
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM3/%'
Group 311: 279512117616
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,360,284,619,431
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: 66883190244
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM30/%'
Group 2: 1635012806088
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM30/%'
Group 3: 1349273309614
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM30/%'
Group 6: 10651809628339
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM30/%'
Group 7: 5374931279523
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM30/%'
Group 30: 626140669208
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM30/%'
Group 310: 1849186294010
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM30/%'
Group 311: 1267339551647
320
select sum(bytes) from sum_partn_alloc where group_id=320 and wd like '/SUM30/%'
Group 320: 7310589410
total bytes /SUM30 = 22,827,887,318,083
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: 42712474568
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM31/%'
Group 2: 1600537101155
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM31/%'
Group 3: 1347075645336
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM31/%'
Group 6: 10774653948404
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM31/%'
Group 7: 5254911095672
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: 1862391020256
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM31/%'
Group 311: 1295051225878
total bytes /SUM31 = 22,805,484,195,707
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: 94260964626
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM32/%'
Group 2: 1619606042949
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM32/%'
Group 3: 1344538452302
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM32/%'
Group 6: 10821680462718
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM32/%'
Group 7: 5200361613723
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM32/%'
Group 30: 632263792512
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM32/%'
Group 310: 1861313034049
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM32/%'
Group 311: 1259185550017
320
select sum(bytes) from sum_partn_alloc where group_id=320 and wd like '/SUM32/%'
Group 320: 21928297874
total bytes /SUM32 = 22,855,138,210,770
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: 149527061542
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM33/%'
Group 2: 1629468240221
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM33/%'
Group 3: 1366363019683
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM33/%'
Group 6: 10838048086323
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM33/%'
Group 7: 5236889741947
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: 1836595501030
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM33/%'
Group 311: 1230013363359
total bytes /SUM33 = 22,913,836,621,035
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: 8719291825152
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM4/%'
Group 1: 1138014581130
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM4/%'
Group 2: 682912727084
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM4/%'
Group 3: 579807528328
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM4/%'
Group 4: 273487763876
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM4/%'
Group 5: 133162808990
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: 3181199176
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: 8566813150746
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: 5172961498404
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM4/%'
Group 310: 242447388802
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM4/%'
Group 311: 302029247669
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,346,352,307,413
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: 69285704854
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM40/%'
Group 2: 1618010665750
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM40/%'
Group 3: 1331655414760
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM40/%'
Group 6: 10826120751297
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM40/%'
Group 7: 5236783343144
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: 1828559099238
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM40/%'
Group 311: 1302697215371
total bytes /SUM40 = 22,831,184,457,480
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: 45329453226
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM41/%'
Group 2: 1659413792019
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM41/%'
Group 3: 1337393053577
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM41/%'
Group 6: 10803606249576
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM41/%'
Group 7: 5235217106097
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: 1831140533498
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM41/%'
Group 311: 1270663564309
total bytes /SUM41 = 22,811,121,839,681
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: 76893265658
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM42/%'
Group 2: 1623398844356
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM42/%'
Group 3: 1360125460047
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM42/%'
Group 6: 10820858284819
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM42/%'
Group 7: 5182067094906
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: 1871763672732
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM42/%'
Group 311: 1276644102907
total bytes /SUM42 = 22,841,386,293,583
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: 95194100742
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM43/%'
Group 2: 1609229675515
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM43/%'
Group 3: 1332207675552
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM43/%'
Group 6: 10863239877030
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM43/%'
Group 7: 5242787095277
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: 1825018752814
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM43/%'
Group 311: 1262520803078
total bytes /SUM43 = 22,858,358,409,012
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: 8831247534127
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM5/%'
Group 1: 1258318479854
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM5/%'
Group 2: 707186735307
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM5/%'
Group 3: 574425081860
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM5/%'
Group 4: 239043980641
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM5/%'
Group 5: 117836523428
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: 3222236931
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: 196133759973
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM5/%'
Group 10: 8636659238256
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: 5172851663769
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM5/%'
Group 310: 235505289176
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM5/%'
Group 311: 297148771043
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,480,347,765,816
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: 8711673852535
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM6/%'
Group 1: 1199555814530
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM6/%'
Group 2: 710547966901
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM6/%'
Group 3: 578055335311
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM6/%'
Group 4: 281325271438
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM6/%'
Group 5: 122359033921
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: 3296017815
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: 189746659518
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM6/%'
Group 10: 8543431320418
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: 5171637089391
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM6/%'
Group 310: 246523020301
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM6/%'
Group 311: 294918934920
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,348,289,689,238
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: 8864148597763
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM7/%'
Group 1: 1145266458629
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM7/%'
Group 2: 723363846940
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: 322987811638
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM7/%'
Group 5: 133916560739
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: 3728435553
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: 8480047725154
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: 5170275736428
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,369,200,119,476
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: 8950346941718
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM8/%'
Group 1: 1115005078259
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: 299887789347
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM8/%'
Group 5: 125122790334
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: 3590373786
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: 8522886150556
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: 5171963733081
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,374,147,372,839
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: 9147193582680
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM9/%'
Group 1: 1078199513600
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM9/%'
Group 2: 648615092888
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM9/%'
Group 3: 576605585953
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM9/%'
Group 4: 236775228453
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM9/%'
Group 5: 128137797330
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: 2998294001
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: 8418329449948
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: 5170294031388
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM9/%'
Group 310: 269649149646
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM9/%'
Group 311: 275041324067
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,370,231,588,943
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 Mon Feb  6 20:50:50 2012