GratiaPie SELECT site, MAX(CASE WHEN total > 3000000 THEN total/1073741824 ELSE total END) FROM se_info WHERE date >= :starttime AND date < :endtime AND site regexp :facility AND ((:sekind='srm' AND se not like '%%disk') OR (se regexp :sekind)) GROUP BY se srm 2009-11-24 11:55:52 86400 2009-11-17 11:55:52 .* /gratia/xml /gratia/static/content /gratia/gip_graphs/se_space_pie?span=86400&endtime=2009-11-24 11:55:52&sekind=srm&starttime=2009-11-17 11:55:52&facility=.*& Total Space 412.06462230075442, 217.34199222842619, 531.36524161759201, 268.98850450775626, 533.9692015605433, 262.50030879906296 27621.0 412.06462230075442, 217.34199222842619, 531.36524161759201, 268.98850450775626, 533.9692015605433, 262.50030879906296 2199.0 411.08363450120981, 219.29360333281176, 518.54234085059284, 292.45524922543132, 525.04370804898076, 281.84839241395758 49164.0 411.08363450120981, 219.29360333281176, 518.54234085059284, 292.45524922543132, 525.04370804898076, 281.84839241395758 412.0 411.08363450120981, 219.29360333281176, 518.54234085059284, 292.45524922543132, 525.04370804898076, 281.84839241395758 1258.0 412.93026948730693, 213.84466761157535, 542.02632107835461, 229.14857115287992, 542.41289022321507, 225.43133785634205 14764.0 412.93026948730693, 213.84466761157535, 542.02632107835461, 229.14857115287992, 542.41289022321507, 225.43133785634205 536.01 412.93026948730693, 213.84466761157535, 542.02632107835461, 229.14857115287992, 542.41289022321507, 225.43133785634205 76.0 412.82768564030027, 214.60961634275844, 540.76039864627171, 237.70119365856226, 541.41756417502586, 233.70524773908926 15998.0 404.8980874780969, 224.54195744291229, 420.49192072021407, 353.60330860900319, 434.11357440156644, 351.21656154264713, 447.40461593374272, 347.39632260202802, 460.21463947831751, 342.18582287926591, 472.39868255610378, 335.64402611903972, 483.81886649069475, 327.84496146527692 273278.0 396.58229156724667, 225.04269783853084, 317.67056192514019, 328.35261471436178, 329.5290753181016, 336.41534345066214, 342.20346341971378, 343.12293771507024, 355.53950972436877, 348.39378238422069, 369.37494695389518, 352.16374408615394, 383.54143145604013, 354.38695154761501, 397.86659153765697, 355.03635373598604, 412.17612480936378, 354.10404900462174 396732.0 396.58229156724667, 225.04269783853084, 317.67056192514019, 328.35261471436178, 329.5290753181016, 336.41534345066214, 342.20346341971378, 343.12293771507024, 355.53950972436877, 348.39378238422069, 369.37494695389518, 352.16374408615394, 383.54143145604013, 354.38695154761501, 397.86659153765697, 355.03635373598604, 412.17612480936378, 354.10404900462174 536.0 412.6528559913404, 215.48416408101184, 538.54694712753519, 247.89832482892396, 539.76332359917706, 242.74088847183185 20934.0 412.6528559913404, 215.48416408101184, 538.54694712753519, 247.89832482892396, 539.76332359917706, 242.74088847183185 9516.0 412.6528559913404, 215.48416408101184, 538.54694712753519, 247.89832482892396, 539.76332359917706, 242.74088847183185 492.0 412.6528559913404, 215.48416408101184, 538.54694712753519, 247.89832482892396, 539.76332359917706, 242.74088847183185 322.0 412.6528559913404, 215.48416408101184, 538.54694712753519, 247.89832482892396, 539.76332359917706, 242.74088847183185 451.0 412.6528559913404, 215.48416408101184, 538.54694712753519, 247.89832482892396, 539.76332359917706, 242.74088847183185 961.0 412.6528559913404, 215.48416408101184, 538.54694712753519, 247.89832482892396, 539.76332359917706, 242.74088847183185 32.0 412.6528559913404, 215.48416408101184, 538.54694712753519, 247.89832482892396, 539.76332359917706, 242.74088847183185 1771.0 412.6528559913404, 215.48416408101184, 538.54694712753519, 247.89832482892396, 539.76332359917706, 242.74088847183185 1099.0 412.75385945780374, 215.01775076816392, 539.86432706564028, 242.27447515898393, 540.68657246377518, 238.10932808396774 16772.0 412.75385945780374, 215.01775076816392, 539.86432706564028, 242.27447515898393, 540.68657246377518, 238.10932808396774 57.0 412.50198467591883, 216.0637591337084, 536.56506798200473, 254.90125854583832, 538.39607581211362, 248.47791988162049 26388.0 412.30244322865087, 216.70117728807315, 534.20702248843986, 261.85949385870993, 536.36552653473677, 255.53867670020304 26388.0 412.30244322865087, 216.70117728807315, 534.20702248843986, 261.85949385870993, 536.36552653473677, 255.53867670020304 5408.0 412.30244322865087, 216.70117728807315, 534.20702248843986, 261.85949385870993, 536.36552653473677, 255.53867670020304 549.0 409.44004952763788, 221.43786691083193, 488.36082854023567, 324.74087093319662, 503.84054480401664, 310.81653601915099, 516.8987558770209, 294.59951280345149 164675.0 409.44004952763788, 221.43786691083193, 488.36082854023567, 324.74087093319662, 503.84054480401664, 310.81653601915099, 516.8987558770209, 294.59951280345149 6369.0 412.88569126831305, 214.22016293929426, 541.47556980303852, 233.31579433562507, 541.98174285936068, 229.52406648059883 15112.0 412.88569126831305, 214.22016293929426, 541.47556980303852, 233.31579433562507, 541.98174285936068, 229.52406648059883 2261.0 412.99490695821055, 212.86385869159739, 542.90431505602305, 217.7162485848354, 542.97229715630579, 215.2883250848634 9595.0 407.0638873221269, 201.58663681992141, 537.0638873221269, 201.58663681992141, 536.47906140428927, 189.26946517690118, 534.72984551776347, 177.0631150909777, 531.83197792080091, 165.07741102203494, 527.81153166074273, 153.42019220673512, 522.70467998642175, 142.1963423942027, 516.55737088580292, 131.50684617318069, 509.42491367714746, 121.44788038118713, 501.37148137327847, 112.10994877055748, 492.46953329633214, 103.57706771705926, 482.79916313791836, 95.926010297521941, 472.4473783304021, 89.225615537758017, 461.50731721303441, 83.536169045694294, 450.07741103634078, 78.908860602357208, 438.26049834448412, 75.385323590939038, 426.1628997037879, 72.997260407850945, 413.89346110238546, 71.766157226060727, 401.56257462783719, 71.703090677079899, 389.28118523399286, 72.808628190945228, 377.15979253353811, 75.072822890868224, 365.30745659741939, 78.475303088486726, 353.83081670628837, 82.985455574500634 1023330.0 407.0638873221269, 201.58663681992141, 537.0638873221269, 201.58663681992141, 536.47906140428927, 189.26946517690118, 534.72984551776347, 177.0631150909777, 531.83197792080091, 165.07741102203494, 527.81153166074273, 153.42019220673512, 522.70467998642175, 142.1963423942027, 516.55737088580292, 131.50684617318069, 509.42491367714746, 121.44788038118713, 501.37148137327847, 112.10994877055748, 492.46953329633214, 103.57706771705926, 482.79916313791836, 95.926010297521941, 472.4473783304021, 89.225615537758017, 461.50731721303441, 83.536169045694294, 450.07741103634078, 78.908860602357208, 438.26049834448412, 75.385323590939038, 426.1628997037879, 72.997260407850945, 413.89346110238546, 71.766157226060727, 401.56257462783719, 71.703090677079899, 389.28118523399286, 72.808628190945228, 377.15979253353811, 75.072822890868224, 365.30745659741939, 78.475303088486726, 353.83081670628837, 82.985455574500634 1156.0 407.0638873221269, 201.58663681992141, 537.0638873221269, 201.58663681992141, 536.47906140428927, 189.26946517690118, 534.72984551776347, 177.0631150909777, 531.83197792080091, 165.07741102203494, 527.81153166074273, 153.42019220673512, 522.70467998642175, 142.1963423942027, 516.55737088580292, 131.50684617318069, 509.42491367714746, 121.44788038118713, 501.37148137327847, 112.10994877055748, 492.46953329633214, 103.57706771705926, 482.79916313791836, 95.926010297521941, 472.4473783304021, 89.225615537758017, 461.50731721303441, 83.536169045694294, 450.07741103634078, 78.908860602357208, 438.26049834448412, 75.385323590939038, 426.1628997037879, 72.997260407850945, 413.89346110238546, 71.766157226060727, 401.56257462783719, 71.703090677079899, 389.28118523399286, 72.808628190945228, 377.15979253353811, 75.072822890868224, 365.30745659741939, 78.475303088486726, 353.83081670628837, 82.985455574500634 10.0 407.0638873221269, 201.58663681992141, 537.0638873221269, 201.58663681992141, 536.47906140428927, 189.26946517690118, 534.72984551776347, 177.0631150909777, 531.83197792080091, 165.07741102203494, 527.81153166074273, 153.42019220673512, 522.70467998642175, 142.1963423942027, 516.55737088580292, 131.50684617318069, 509.42491367714746, 121.44788038118713, 501.37148137327847, 112.10994877055748, 492.46953329633214, 103.57706771705926, 482.79916313791836, 95.926010297521941, 472.4473783304021, 89.225615537758017, 461.50731721303441, 83.536169045694294, 450.07741103634078, 78.908860602357208, 438.26049834448412, 75.385323590939038, 426.1628997037879, 72.997260407850945, 413.89346110238546, 71.766157226060727, 401.56257462783719, 71.703090677079899, 389.28118523399286, 72.808628190945228, 377.15979253353811, 75.072822890868224, 365.30745659741939, 78.475303088486726, 353.83081670628837, 82.985455574500634 295.0 412.98373459343458, 213.15010461254388, 542.72809641797016, 221.29875939379349, 542.89314269124714, 218.0024945057819 13038.0 412.98373459343458, 213.15010461254388, 542.72809641797016, 221.29875939379349, 542.89314269124714, 218.0024945057819 641.0 412.98373459343458, 213.15010461254388, 542.72809641797016, 221.29875939379349, 542.89314269124714, 218.0024945057819 624.0 388.06118560360687, 217.64438633934861, 258.77431606673622, 204.04639511431219, 258.06157976061331, 217.32426032304545, 258.70891392726298, 230.60547472610523, 260.7095460839505, 243.75108876718309, 264.04254539242038, 256.62357155618281, 268.67304163967589, 269.08824973283492, 274.5525900540631, 281.01471643451293, 281.61967813991095, 292.27819562747197, 289.80036922816805, 302.76084752772448, 299.00907601013546, 312.3530014540907, 309.14945596150045, 320.95430321517955 525504.0 388.06118560360687, 217.64438633934861, 258.77431606673622, 204.04639511431219, 258.06157976061331, 217.32426032304545, 258.70891392726298, 230.60547472610523, 260.7095460839505, 243.75108876718309, 264.04254539242038, 256.62357155618281, 268.67304163967589, 269.08824973283492, 274.5525900540631, 281.01471643451293, 281.61967813991095, 292.27819562747197, 289.80036922816805, 302.76084752772448, 299.00907601013546, 312.3530014540907, 309.14945596150045, 320.95430321517955 7984.0 388.06118560360687, 217.64438633934861, 258.77431606673622, 204.04639511431219, 258.06157976061331, 217.32426032304545, 258.70891392726298, 230.60547472610523, 260.7095460839505, 243.75108876718309, 264.04254539242038, 256.62357155618281, 268.67304163967589, 269.08824973283492, 274.5525900540631, 281.01471643451293, 281.61967813991095, 292.27819562747197, 289.80036922816805, 302.76084752772448, 299.00907601013546, 312.3530014540907, 309.14945596150045, 320.95430321517955 1799.0 388.06118560360687, 217.64438633934861, 258.77431606673622, 204.04639511431219, 258.06157976061331, 217.32426032304545, 258.70891392726298, 230.60547472610523, 260.7095460839505, 243.75108876718309, 264.04254539242038, 256.62357155618281, 268.67304163967589, 269.08824973283492, 274.5525900540631, 281.01471643451293, 281.61967813991095, 292.27819562747197, 289.80036922816805, 302.76084752772448, 299.00907601013546, 312.3530014540907, 309.14945596150045, 320.95430321517955 845.0 388.06118560360687, 217.64438633934861, 258.77431606673622, 204.04639511431219, 258.06157976061331, 217.32426032304545, 258.70891392726298, 230.60547472610523, 260.7095460839505, 243.75108876718309, 264.04254539242038, 256.62357155618281, 268.67304163967589, 269.08824973283492, 274.5525900540631, 281.01471643451293, 281.61967813991095, 292.27819562747197, 289.80036922816805, 302.76084752772448, 299.00907601013546, 312.3530014540907, 309.14945596150045, 320.95430321517955 81.0 388.06118560360687, 217.64438633934861, 258.77431606673622, 204.04639511431219, 258.06157976061331, 217.32426032304545, 258.70891392726298, 230.60547472610523, 260.7095460839505, 243.75108876718309, 264.04254539242038, 256.62357155618281, 268.67304163967589, 269.08824973283492, 274.5525900540631, 281.01471643451293, 281.61967813991095, 292.27819562747197, 289.80036922816805, 302.76084752772448, 299.00907601013546, 312.3530014540907, 309.14945596150045, 320.95430321517955 10.0 412.96248900073977, 213.48685303145908, 542.44510973664796, 225.07352327622579, 542.70685082527541, 221.63550781270862 13621.0 389.47156250103967, 204.87425388368547, 336.23849188520114, 86.273072638264694, 324.16755554156089, 92.46701801767756, 312.80790141344568, 99.885287469845025, 302.28325728314707, 108.44708222946963, 292.70825611950045, 118.05914841169766, 284.18718751143655, 128.6167927205401, 276.81286176019682, 140.00502275377914, 270.66559900236336, 152.09979948431533, 265.81235437403564, 164.76938827610235, 262.30598874474447, 177.87579371959026, 260.18469296416896, 191.27626265864899 536198.0 412.99943474266331, 212.62122859084405, 542.97682494075866, 215.04569498411007, 542.99943474266331, 212.621228590844 9578.0 412.99943474266331, 212.62122859084405, 542.97682494075866, 215.04569498411007, 542.99943474266331, 212.621228590844 246.0