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: 8257.04237692337
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM0/%'
Group 1: 965.331442773342
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM0/%'
Group 2: 581.343292457983
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM0/%'
Group 3: 480.196003312245
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM0/%'
Group 4: 111.793741414323
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM0/%'
Group 5: 117.231665256433
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM0/%'
Group 6: 3852.61376283038
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM0/%'
Group 7: 3.07958211470395
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM0/%'
Group 8: 4.38470349926502
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM0/%'
Group 9: 181.858099477366
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM0/%'
Group 10: 8142.91920039989
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM0/%'
Group 11: 0.000749827362596989
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM0/%'
Group 12: 0.00124978646636009
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM0/%'
Group 100: 4928.26981924474
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM0/%'
Group 310: 170.30077558849
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM0/%'
Group 311: 212.390999931842
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM0/%'
Group 400: 33.1178555367514
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM0/%'
Group 401: 26.8184854406863
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM0/%'
Group 10000: 0.481255685910583
total GB /SUM0 = 28,069
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: 8273.23091093916
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM1/%'
Group 1: 1013.63938419148
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM1/%'
Group 2: 541.460187524557
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM1/%'
Group 3: 476.814021294005
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM1/%'
Group 4: 185.554560491815
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM1/%'
Group 5: 129.633418428712
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM1/%'
Group 6: 3860.40878782608
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM1/%'
Group 7: 3.35827257297933
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM1/%'
Group 8: 4.14480201341212
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM1/%'
Group 9: 176.430484018289
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM1/%'
Group 10: 8180.5277620079
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM1/%'
Group 11: 0.0310965515673161
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM1/%'
Group 12: 0.03980862069875
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM1/%'
Group 100: 4937.12297820859
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM1/%'
Group 310: 171.425607719459
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM1/%'
Group 311: 222.024539995007
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM1/%'
Group 400: 31.2443642839789
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM1/%'
Group 401: 27.605697831139
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM1/%'
Group 10000: 0.456528391689062
total GB /SUM1 = 28,235
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: 8578.23217517044
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM10/%'
Group 1: 1105.9396060938
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM10/%'
Group 2: 443.759956776164
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM10/%'
Group 3: 467.041981177405
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM10/%'
Group 4: 116.595878395252
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM10/%'
Group 5: 100.851991468109
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM10/%'
Group 6: 3879.00428373087
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM10/%'
Group 7: 3.37848711945117
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM10/%'
Group 8: 4.46938720438629
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM10/%'
Group 9: 182.093749398366
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM10/%'
Group 10: 8146.45724066999
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM10/%'
Group 11: 0.000749828293919563
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM10/%'
Group 100: 4937.10664372332
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM10/%'
Group 310: 162.507527898997
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM10/%'
Group 311: 214.484006747603
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM10/%'
Group 400: 32.6246647564694
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM10/%'
Group 401: 25.2171679483727
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM10/%'
Group 10000: 0.470451849512756
total GB /SUM10 = 28,400
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: 3647.40012457035
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM100/%'
Group 10000: 49822.9583126809
total GB /SUM100 = 53,470
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: 53054.6315829922
total GB /SUM101 = 53,054
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: 491.726629447192
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM102/%'
Group 10000: 45952.273497873
total GB /SUM102 = 46,444
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: 12300.4344771318
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM103/%'
Group 10000: 66240.2592585795
total GB /SUM103 = 78,540
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: 8556.08029410336
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM11/%'
Group 1: 965.175563886762
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM11/%'
Group 2: 377.007419911213
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM11/%'
Group 3: 473.846838925965
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM11/%'
Group 4: 119.285074601881
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM11/%'
Group 5: 121.209586194716
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM11/%'
Group 6: 3920.71707751881
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM11/%'
Group 7: 3.40611876547337
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM11/%'
Group 8: 4.67650367226452
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM11/%'
Group 9: 181.757962501608
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM11/%'
Group 10: 8108.69510222785
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM11/%'
Group 11: 0.000499885529279709
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM11/%'
Group 12: 0.000249956734478474
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM11/%'
Group 100: 4937.07522606477
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM11/%'
Group 310: 167.573844083585
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM11/%'
Group 311: 218.77556488663
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM11/%'
Group 400: 33.0065968930721
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM11/%'
Group 401: 29.8443537205458
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM11/%'
Group 10000: 0.481279955245554
total GB /SUM11 = 28,218
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: 8475.79426382948
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM12/%'
Group 1: 984.277558955364
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM12/%'
Group 2: 558.008548303507
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM12/%'
Group 3: 470.402193920687
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM12/%'
Group 4: 114.098767012358
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM12/%'
Group 5: 111.849772441201
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM12/%'
Group 6: 3896.06506728753
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM12/%'
Group 7: 3.0188363911584
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM12/%'
Group 8: 4.723703074269
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM12/%'
Group 9: 167.700947996229
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM12/%'
Group 10: 8185.39165007044
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM12/%'
Group 11: 0.000749828293919563
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM12/%'
Group 12: 0.000499915331602097
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM12/%'
Group 100: 4943.75061668269
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM12/%'
Group 310: 164.662908989936
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM12/%'
Group 311: 230.02469636593
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM12/%'
Group 400: 31.3082994241267
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM12/%'
Group 401: 25.7647698530927
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM12/%'
Group 10000: 0.468504458665848
total GB /SUM12 = 28,367
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: 8264.16686089709
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM13/%'
Group 1: 892.143587675877
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM13/%'
Group 2: 541.047438414767
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM13/%'
Group 3: 464.623682235368
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM13/%'
Group 4: 254.129072140902
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM13/%'
Group 5: 138.057250823826
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM13/%'
Group 6: 3897.52595075872
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM13/%'
Group 7: 3.18547279387712
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM13/%'
Group 8: 4.43247887026519
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM13/%'
Group 9: 174.129973170348
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM13/%'
Group 10: 8209.9245187277
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM13/%'
Group 100: 4937.86005878728
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM13/%'
Group 310: 170.108044669963
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM13/%'
Group 311: 226.182959900238
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM13/%'
Group 400: 33.9872626625001
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM13/%'
Group 401: 25.0187066886574
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM13/%'
Group 10000: 0.473434598185122
total GB /SUM13 = 28,236
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: 8291.3386605829
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM14/%'
Group 1: 897.211934379302
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM14/%'
Group 2: 560.838089818135
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM14/%'
Group 3: 467.93293052353
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM14/%'
Group 4: 298.884985640645
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM14/%'
Group 5: 133.845334706828
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM14/%'
Group 6: 3941.07968847267
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM14/%'
Group 7: 3.52661298029125
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM14/%'
Group 8: 4.64869873784482
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM14/%'
Group 9: 197.591224249452
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM14/%'
Group 10: 8102.48604317382
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM14/%'
Group 100: 4938.23558631912
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM14/%'
Group 310: 167.072548396885
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM14/%'
Group 311: 218.663058316335
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM14/%'
Group 400: 28.1790263336152
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM14/%'
Group 401: 25.0174414031208
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM14/%'
Group 10000: 0.481982757337391
total GB /SUM14 = 28,277
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: 8142.86913431995
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM15/%'
Group 1: 1056.99384567235
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM15/%'
Group 2: 570.275980183855
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM15/%'
Group 3: 473.433318645693
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM15/%'
Group 4: 251.05570451729
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM15/%'
Group 5: 135.717297425494
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM15/%'
Group 6: 3929.64116924722
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM15/%'
Group 7: 3.43966155685484
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM15/%'
Group 8: 4.7182937450707
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM15/%'
Group 9: 182.613590841182
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM15/%'
Group 10: 8090.15753616579
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM15/%'
Group 100: 4939.35055490211
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM15/%'
Group 310: 168.568194786087
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM15/%'
Group 311: 219.61198529508
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM15/%'
Group 400: 34.4008244052529
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM15/%'
Group 401: 27.753339109011
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM15/%'
Group 10000: 0.464167295955122
total GB /SUM15 = 28,231
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: 8228.18762213644
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM16/%'
Group 1: 825.331101921387
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM16/%'
Group 2: 576.875203109346
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM16/%'
Group 3: 485.840178240091
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM16/%'
Group 4: 352.284745289013
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM16/%'
Group 5: 160.988794127479
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM16/%'
Group 6: 4021.06355618779
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM16/%'
Group 7: 4.5322799962014
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM16/%'
Group 8: 4.27694555558264
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM16/%'
Group 9: 174.717744681984
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM16/%'
Group 10: 8102.04546971712
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM16/%'
Group 100: 4942.08807750419
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM16/%'
Group 310: 168.581938067451
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM16/%'
Group 311: 212.308912498876
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM16/%'
Group 400: 35.919027400203
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM16/%'
Group 401: 28.1916682524607
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM16/%'
Group 10000: 0.502351557835937
total GB /SUM16 = 28,323
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: 8258.56368337199
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM17/%'
Group 1: 951.641651943326
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM17/%'
Group 2: 573.426701920107
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM17/%'
Group 3: 473.529222699814
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM17/%'
Group 4: 140.798647156917
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM17/%'
Group 5: 134.781315905042
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM17/%'
Group 6: 3950.96705696918
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM17/%'
Group 7: 3.24157317634672
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM17/%'
Group 8: 4.3373764231801
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM17/%'
Group 9: 189.513837289996
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM17/%'
Group 10: 8168.75415035244
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM17/%'
Group 100: 4940.62331675179
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM17/%'
Group 310: 162.606626232155
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM17/%'
Group 311: 226.338341320865
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM17/%'
Group 400: 33.585430143401
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM17/%'
Group 401: 23.6474047973752
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM17/%'
Group 10000: 0.465688045136631
total GB /SUM17 = 28,236
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: 8277.80759113003
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM18/%'
Group 1: 815.51399956923
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM18/%'
Group 2: 555.240852486342
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM18/%'
Group 3: 464.519036862999
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM18/%'
Group 4: 299.461242037825
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM18/%'
Group 5: 149.289026977494
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM18/%'
Group 6: 3955.74713174812
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM18/%'
Group 7: 3.85065137781203
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM18/%'
Group 8: 4.43986447900534
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM18/%'
Group 9: 191.056513489224
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM18/%'
Group 10: 8142.02019791026
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM18/%'
Group 100: 4935.08944348432
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM18/%'
Group 310: 165.982337570749
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM18/%'
Group 311: 224.230946017429
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM18/%'
Group 400: 38.992966376245
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM18/%'
Group 401: 28.9005728177726
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM18/%'
Group 10000: 0.489157536998391
total GB /SUM18 = 28,252
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: 8228.1311134696
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM19/%'
Group 1: 884.609619373456
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM19/%'
Group 2: 575.436372297816
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM19/%'
Group 3: 473.349619911984
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM19/%'
Group 4: 271.608849741518
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM19/%'
Group 5: 131.037390306592
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM19/%'
Group 6: 3931.73966215178
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM19/%'
Group 7: 3.74339991249144
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM19/%'
Group 8: 4.53495075087994
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM19/%'
Group 9: 178.333233045414
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM19/%'
Group 10: 8160.17087696865
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM19/%'
Group 100: 4936.18587629311
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM19/%'
Group 310: 165.494309613481
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM19/%'
Group 311: 225.44547215756
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM19/%'
Group 400: 38.8492660615593
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM19/%'
Group 401: 30.9758086800575
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM19/%'
Group 10000: 0.495455519296229
total GB /SUM19 = 28,240
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: 8120.07134928834
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM2/%'
Group 1: 1060.24969494715
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM2/%'
Group 2: 572.761218280531
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM2/%'
Group 3: 471.489322571084
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM2/%'
Group 4: 267.959225560538
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM2/%'
Group 5: 131.271385968663
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM2/%'
Group 6: 3945.30349076912
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM2/%'
Group 7: 3.29639139398932
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM2/%'
Group 8: 4.63182514999062
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM2/%'
Group 9: 162.4309404511
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM2/%'
Group 10: 8098.28428003192
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM2/%'
Group 11: 0.0314672095701098
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM2/%'
Group 12: 0.0379850678145885
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM2/%'
Group 100: 4936.83981337119
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM2/%'
Group 310: 158.765374733135
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM2/%'
Group 311: 229.078561351635
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM2/%'
Group 400: 36.6989108165726
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM2/%'
Group 401: 32.4365951409563
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM2/%'
Group 10000: 0.501281311735511
total GB /SUM2 = 28,232
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: 8315.31065744441
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM20/%'
Group 1: 860.83104555402
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM20/%'
Group 2: 541.951235437766
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM20/%'
Group 3: 480.993133596145
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM20/%'
Group 4: 197.463859408163
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM20/%'
Group 5: 126.123488493264
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM20/%'
Group 6: 3948.63186014909
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM20/%'
Group 7: 2.98200359288603
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM20/%'
Group 8: 4.40149150136858
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM20/%'
Group 9: 181.880658617243
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM20/%'
Group 10: 8160.77163114864
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM20/%'
Group 100: 4943.73677607346
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM20/%'
Group 310: 169.647518591955
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM20/%'
Group 311: 246.710369614884
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM20/%'
Group 400: 34.5000564046204
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM20/%'
Group 401: 29.211752390489
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM20/%'
Group 10000: 0.539044415578246
total GB /SUM20 = 28,245
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: 8273.32863523252
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM21/%'
Group 1: 962.986294916831
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM21/%'
Group 2: 574.500600756146
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM21/%'
Group 3: 468.617530653253
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM21/%'
Group 4: 117.940476500429
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM21/%'
Group 5: 113.487739819102
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM21/%'
Group 6: 3964.22467082366
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM21/%'
Group 7: 2.79297525621951
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM21/%'
Group 8: 4.66935576777905
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM21/%'
Group 9: 169.54610907007
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM21/%'
Group 10: 8170.72666917089
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM21/%'
Group 100: 4941.41785228439
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM21/%'
Group 310: 156.247762991115
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM21/%'
Group 311: 229.558838419616
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM21/%'
Group 400: 37.4976200545207
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM21/%'
Group 401: 30.1211139755324
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM21/%'
Group 10000: 0.462528323754668
total GB /SUM21 = 28,218
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: 7827.39943934232
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM22/%'
Group 1: 963.385439841077
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM22/%'
Group 2: 566.32880540099
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM22/%'
Group 3: 460.990007022396
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM22/%'
Group 4: 360.736505964771
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM22/%'
Group 5: 149.289026975632
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM22/%'
Group 6: 4132.87259155419
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM22/%'
Group 7: 3.57309475075454
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM22/%'
Group 8: 4.5910251699388
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM22/%'
Group 9: 180.803464133292
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM22/%'
Group 10: 8151.18405369017
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM22/%'
Group 100: 4937.66004880797
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM22/%'
Group 310: 161.247051691636
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM22/%'
Group 311: 217.639918161556
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM22/%'
Group 400: 77.6100625582039
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM22/%'
Group 401: 57.1968463286757
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM22/%'
Group 10000: 0.485027117654681
total GB /SUM22 = 28,252
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: 8178.03563820757
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM3/%'
Group 1: 1028.4461030094
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM3/%'
Group 2: 554.312750214711
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM3/%'
Group 3: 461.106820897199
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM3/%'
Group 4: 265.846285427921
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM3/%'
Group 5: 128.931432249025
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM3/%'
Group 6: 3931.07916669454
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM3/%'
Group 7: 3.06942687742412
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM3/%'
Group 8: 4.49918294791132
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM3/%'
Group 9: 181.782567614689
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM3/%'
Group 10: 8123.78662241623
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM3/%'
Group 11: 0.019138865172863
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM3/%'
Group 12: 0.06089230440557
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM3/%'
Group 100: 4938.15513958409
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM3/%'
Group 310: 153.000221461989
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM3/%'
Group 311: 228.632149079815
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM3/%'
Group 400: 31.6982906730846
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM3/%'
Group 401: 18.6816070619971
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM3/%'
Group 10000: 0.48039751406759
total GB /SUM3 = 28,231
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: 2.34292209800333
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM30/%'
Group 2: 1918.63058910705
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM30/%'
Group 3: 1580.54477071017
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM30/%'
Group 4: 0.192085466347635
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM30/%'
Group 6: 9490.57310871407
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM30/%'
Group 7: 4434.2034677444
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM30/%'
Group 30: 524.444640538655
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM30/%'
Group 310: 1908.41883059125
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM30/%'
Group 311: 1341.86941237655
320
select sum(bytes) from sum_partn_alloc where group_id=320 and wd like '/SUM30/%'
Group 320: 6.80851695127785
total GB /SUM30 = 21,208
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: 2.54453699011356
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM31/%'
Group 2: 1887.02161424141
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM31/%'
Group 3: 1574.98586346675
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM31/%'
Group 5: 0.2339953398332
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM31/%'
Group 6: 9639.09460305329
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM31/%'
Group 7: 4299.85875384044
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM31/%'
Group 30: 527.882957458496
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM31/%'
Group 310: 1930.41539802309
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM31/%'
Group 311: 1346.1852745004
total GB /SUM31 = 21,208
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: 7.47650071512908
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM32/%'
Group 2: 1899.42713732552
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM32/%'
Group 3: 1574.92721300758
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM32/%'
Group 6: 9656.51654437091
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM32/%'
Group 7: 4268.14349285886
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM32/%'
Group 30: 529.314467051066
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM32/%'
Group 310: 1935.76833389979
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM32/%'
Group 311: 1322.51119448245
320
select sum(bytes) from sum_partn_alloc where group_id=320 and wd like '/SUM32/%'
Group 320: 20.4223188329488
total GB /SUM32 = 21,214
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: 4.59254036191851
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM33/%'
Group 1: 0.0243422938510776
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM33/%'
Group 2: 1914.01791335177
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM33/%'
Group 3: 1592.42726138048
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM33/%'
Group 6: 9665.769858527
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM33/%'
Group 7: 4293.23599703237
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM33/%'
Group 30: 529.39036231488
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM33/%'
Group 310: 1913.24819212127
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM33/%'
Group 311: 1298.03930492792
total GB /SUM33 = 21,210
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: 8139.37114998139
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM4/%'
Group 1: 1081.14457394648
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM4/%'
Group 2: 556.593642681837
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM4/%'
Group 3: 474.989544513635
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM4/%'
Group 4: 136.764852039516
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM4/%'
Group 5: 137.589259821922
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM4/%'
Group 6: 3965.80898492876
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM4/%'
Group 7: 3.11842758860439
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM4/%'
Group 8: 4.18342165928334
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM4/%'
Group 9: 187.012491488829
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM4/%'
Group 10: 8157.36495711561
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM4/%'
Group 11: 0.000749828293919563
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM4/%'
Group 100: 4936.58529770561
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM4/%'
Group 310: 159.129770349711
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM4/%'
Group 311: 233.214441901073
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM4/%'
Group 400: 36.6837287433445
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM4/%'
Group 401: 22.9329417534173
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM4/%'
Group 10000: 0.490482815541327
total GB /SUM4 = 28,232
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: 2.9855915363878
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM40/%'
Group 1: 0.000127867795526981
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM40/%'
Group 2: 1890.61236760207
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM40/%'
Group 3: 1555.21553016547
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM40/%'
Group 6: 9663.00031316653
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM40/%'
Group 7: 4290.27382558305
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM40/%'
Group 30: 521.308832580224
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM40/%'
Group 310: 1902.67208425049
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM40/%'
Group 311: 1379.24486679491
total GB /SUM40 = 21,205
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: 3.20436097402126
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM41/%'
Group 2: 1931.52933096699
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM41/%'
Group 3: 1566.77109583374
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM41/%'
Group 4: 0.192085466347635
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM41/%'
Group 6: 9652.61385524273
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM41/%'
Group 7: 4279.20620025042
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM41/%'
Group 30: 531.087852180935
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM41/%'
Group 310: 1898.59610392153
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM41/%'
Group 311: 1344.66566701047
total GB /SUM41 = 21,207
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: 9.3335543172434
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM42/%'
Group 2: 1894.49269334413
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM42/%'
Group 3: 1592.06336980686
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM42/%'
Group 5: 0.2339953398332
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM42/%'
Group 6: 9644.91586802993
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM42/%'
Group 7: 4265.34582091123
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM42/%'
Group 30: 529.404521523975
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM42/%'
Group 310: 1925.41080383677
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM42/%'
Group 311: 1353.19560313504
total GB /SUM42 = 21,214
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: 4.85891364514828
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM43/%'
Group 2: 1895.15333973151
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM43/%'
Group 3: 1568.60117421299
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM43/%'
Group 4: 0.192085466347635
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM43/%'
Group 6: 9682.9860622324
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM43/%'
Group 7: 4309.69851188455
30
select sum(bytes) from sum_partn_alloc where group_id=30 and wd like '/SUM43/%'
Group 30: 527.831206768751
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM43/%'
Group 310: 1887.63600940723
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM43/%'
Group 311: 1334.13724414725
total GB /SUM43 = 21,211
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: 8185.596234967
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM5/%'
Group 1: 1157.46395329759
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM5/%'
Group 2: 588.3576644063
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM5/%'
Group 3: 475.121037447825
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM5/%'
Group 4: 119.092989136465
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM5/%'
Group 5: 100.150005449541
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM5/%'
Group 6: 3853.39329646528
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM5/%'
Group 7: 2.74223555903882
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM5/%'
Group 8: 4.66361995972693
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM5/%'
Group 9: 181.245358343236
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM5/%'
Group 10: 8232.00466375705
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM5/%'
Group 11: 0.0128283128142357
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM5/%'
Group 12: 0.000249956734478474
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM5/%'
Group 100: 4935.80375268403
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM5/%'
Group 310: 151.141006431542
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM5/%'
Group 311: 232.867336528376
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM5/%'
Group 400: 39.1141483159736
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM5/%'
Group 401: 23.8846756992862
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM5/%'
Group 10000: 0.506023451685905
total GB /SUM5 = 28,283
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: 8084.39854113944
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM6/%'
Group 1: 1104.5832247939
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM6/%'
Group 2: 583.376590382308
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM6/%'
Group 3: 470.265875433572
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM6/%'
Group 4: 220.129944434389
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM6/%'
Group 5: 135.015311245807
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM6/%'
Group 6: 3934.22992459498
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM6/%'
Group 7: 3.37117584142834
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM6/%'
Group 8: 4.56684405356646
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM6/%'
Group 9: 173.458593057469
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM6/%'
Group 10: 8147.06779186521
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM6/%'
Group 11: 0.0134745379909873
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM6/%'
Group 12: 0.049313704483211
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM6/%'
Group 100: 4934.24911352433
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM6/%'
Group 310: 158.77206810005
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM6/%'
Group 311: 225.32680325862
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM6/%'
Group 400: 31.6155277192593
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM6/%'
Group 401: 29.2597285229713
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM6/%'
Group 10000: 0.490544394589961
total GB /SUM6 = 28,240
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: 8138.6057067737
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM7/%'
Group 1: 1048.04395958222
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM7/%'
Group 2: 588.433669827878
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM7/%'
Group 3: 467.388500200585
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM7/%'
Group 4: 323.66401079949
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM7/%'
Group 5: 154.904915292747
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM7/%'
Group 6: 3873.16134270374
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM7/%'
Group 7: 3.78420548141003
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM7/%'
Group 8: 4.59213527850807
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM7/%'
Group 9: 175.69541867543
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM7/%'
Group 10: 8086.21145842317
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM7/%'
Group 11: 0.0373814795166254
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM7/%'
Group 12: 0.037985066883266
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM7/%'
Group 100: 4933.06842765212
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM7/%'
Group 310: 172.202313604765
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM7/%'
Group 311: 220.852225344628
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM7/%'
Group 400: 37.033113935031
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM7/%'
Group 401: 26.5721604842693
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM7/%'
Group 10000: 0.529466465115547
total GB /SUM7 = 28,254
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: 8174.72393464204
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM8/%'
Group 1: 1024.65345169511
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM8/%'
Group 2: 596.405772308819
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM8/%'
Group 3: 481.141471236013
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM8/%'
Group 4: 334.228711445816
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM8/%'
Group 5: 164.264728724025
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM8/%'
Group 6: 3810.11615402438
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM8/%'
Group 7: 4.21518552210182
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM8/%'
Group 8: 4.45441777817905
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM8/%'
Group 9: 181.296966116875
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM8/%'
Group 10: 8124.67179143149
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM8/%'
Group 11: 0.0315964361652732
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM8/%'
Group 12: 0.0377351129427552
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM8/%'
Group 100: 4934.61858614814
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM8/%'
Group 310: 176.931071010418
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM8/%'
Group 311: 211.192742077634
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM8/%'
Group 400: 35.1042986195534
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM8/%'
Group 401: 25.8035330688581
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM8/%'
Group 10000: 0.48239061050117
total GB /SUM8 = 28,284
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: 8509.73478370067
1
select sum(bytes) from sum_partn_alloc where group_id=1 and wd like '/SUM9/%'
Group 1: 987.634504877031
2
select sum(bytes) from sum_partn_alloc where group_id=2 and wd like '/SUM9/%'
Group 2: 529.072899186052
3
select sum(bytes) from sum_partn_alloc where group_id=3 and wd like '/SUM9/%'
Group 3: 471.57294419501
4
select sum(bytes) from sum_partn_alloc where group_id=4 and wd like '/SUM9/%'
Group 4: 125.239724058658
5
select sum(bytes) from sum_partn_alloc where group_id=5 and wd like '/SUM9/%'
Group 5: 134.54732040409
6
select sum(bytes) from sum_partn_alloc where group_id=6 and wd like '/SUM9/%'
Group 6: 3870.48677866161
7
select sum(bytes) from sum_partn_alloc where group_id=7 and wd like '/SUM9/%'
Group 7: 3.16452026367188
8
select sum(bytes) from sum_partn_alloc where group_id=8 and wd like '/SUM9/%'
Group 8: 4.18278054427356
9
select sum(bytes) from sum_partn_alloc where group_id=9 and wd like '/SUM9/%'
Group 9: 169.221511106938
10
select sum(bytes) from sum_partn_alloc where group_id=10 and wd like '/SUM9/%'
Group 10: 8026.1896385625
11
select sum(bytes) from sum_partn_alloc where group_id=11 and wd like '/SUM9/%'
Group 11: 0.000999770127236843
12
select sum(bytes) from sum_partn_alloc where group_id=12 and wd like '/SUM9/%'
Group 12: 0.000249956734478474
100
select sum(bytes) from sum_partn_alloc where group_id=100 and wd like '/SUM9/%'
Group 100: 4932.92401622515
310
select sum(bytes) from sum_partn_alloc where group_id=310 and wd like '/SUM9/%'
Group 310: 179.124512961134
311
select sum(bytes) from sum_partn_alloc where group_id=311 and wd like '/SUM9/%'
Group 311: 217.058172116987
400
select sum(bytes) from sum_partn_alloc where group_id=400 and wd like '/SUM9/%'
Group 400: 39.6245990889147
401
select sum(bytes) from sum_partn_alloc where group_id=401 and wd like '/SUM9/%'
Group 401: 30.6161418361589
10000
select sum(bytes) from sum_partn_alloc where group_id=10000 and wd like '/SUM9/%'
Group 10000: 0.503861683420837
total GB /SUM9 = 28,230