Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- chimera=> WITH
- chimera-> atime_atlas AS ( SELECT to_char(iatime, 'yyyy-mm') AS period, round(SUM(isize)/1000/1000/1000) AS atime_atlas_GB FROM t_inodes WHERE igid=4000 GROUP BY to_char(iatime, 'yyyy-mm') ),
- chimera-> atime_cms AS ( SELECT to_char(iatime, 'yyyy-mm') AS period, round(SUM(isize)/1000/1000/1000) AS atime_cms_GB FROM t_inodes WHERE igid=4001 GROUP BY to_char(iatime, 'yyyy-mm') ),
- chimera-> atime_lhcb AS ( SELECT to_char(iatime, 'yyyy-mm') AS period, round(SUM(isize)/1000/1000/1000) AS atime_lhcb_GB FROM t_inodes WHERE igid=4002 GROUP BY to_char(iatime, 'yyyy-mm') ),
- chimera-> atime_dteam AS ( SELECT to_char(iatime, 'yyyy-mm') AS period, round(SUM(isize)/1000/1000/1000) AS atime_dteam_GB FROM t_inodes WHERE igid=4003 GROUP BY to_char(iatime, 'yyyy-mm') ),
- chimera-> atime_ops AS ( SELECT to_char(iatime, 'yyyy-mm') AS period, round(SUM(isize)/1000/1000/1000) AS atime_ops_GB FROM t_inodes WHERE igid=4004 GROUP BY to_char(iatime, 'yyyy-mm') ),
- chimera-> atime_hone AS ( SELECT to_char(iatime, 'yyyy-mm') AS period, round(SUM(isize)/1000/1000/1000) AS atime_hone_GB FROM t_inodes WHERE igid=4005 GROUP BY to_char(iatime, 'yyyy-mm') ),
- chimera-> atime_dech AS ( SELECT to_char(iatime, 'yyyy-mm') AS period, round(SUM(isize)/1000/1000/1000) AS atime_dech_GB FROM t_inodes WHERE igid=4006 GROUP BY to_char(iatime, 'yyyy-mm') ),
- chimera-> atime_gear AS ( SELECT to_char(iatime, 'yyyy-mm') AS period, round(SUM(isize)/1000/1000/1000) AS atime_gear_GB FROM t_inodes WHERE igid=4007 GROUP BY to_char(iatime, 'yyyy-mm') )
- chimera->
- chimera-> SELECT * FROM
- chimera->
- chimera-> atime_atlas
- chimera->
- chimera-> NATURAL FULL OUTER JOIN atime_cms
- chimera-> NATURAL FULL OUTER JOIN atime_lhcb
- chimera-> NATURAL FULL OUTER JOIN atime_dteam
- chimera-> NATURAL FULL OUTER JOIN atime_ops
- chimera-> NATURAL FULL OUTER JOIN atime_hone
- chimera-> NATURAL FULL OUTER JOIN atime_dech
- chimera-> NATURAL FULL OUTER JOIN atime_gear
- chimera->
- chimera->
- chimera-> ORDER BY period ASC ;
- period | atime_atlas_gb | atime_cms_gb | atime_lhcb_gb | atime_dteam_gb | atime_ops_gb | atime_hone_gb | atime_dech_gb | atime_gear_gb
- ---------+----------------+--------------+---------------+----------------+--------------+---------------+---------------+---------------
- 2007-12 | 17 | 0 | | | | 3 | |
- 2008-01 | 5 | 121 | | | | | |
- 2008-02 | 0 | 382 | | | | | |
- 2008-03 | 0 | 0 | | | | 1 | |
- 2008-04 | 0 | 850 | | | | 0 | |
- 2008-05 | 0 | 0 | | | | 2 | |
- 2008-06 | 0 | 74 | | | | 0 | | 0
- 2008-07 | 0 | 0 | | | | 0 | |
- 2008-08 | 0 | 0 | | | | | |
- 2008-09 | 0 | 0 | | | | 0 | |
- 2008-10 | 0 | 0 | | | | 0 | |
- 2008-11 | 0 | 0 | | | | 0 | |
- 2008-12 | 0 | 181 | 0 | | | 0 | |
- 2009-01 | 0 | 227 | | | | 0 | |
- 2009-02 | 0 | 257 | | | | 0 | |
- 2009-03 | 0 | 8 | | | | 0 | |
- 2009-04 | 0 | 0 | | | | 0 | |
- 2009-05 | 0 | 0 | | | | 0 | |
- 2009-06 | 0 | 0 | | | | 0 | |
- 2009-07 | 0 | 0 | | | | 0 | |
- 2009-08 | 0 | 2 | | | | 0 | |
- 2009-09 | 0 | 0 | | | | 0 | |
- 2009-10 | 0 | 2 | | 0 | | 0 | |
- 2009-11 | 3 | 0 | | | | 0 | |
- 2009-12 | 0 | 0 | | | | | |
- 2010-01 | 0 | 170 | | | | 3 | |
- 2010-02 | 0 | 120 | | | | 0 | |
- 2010-03 | 0 | 76 | | | | | |
- 2010-04 | 2703 | 976 | | 0 | | | 0 |
- 2010-05 | 1 | 707 | | | 0 | 0 | |
- 2010-06 | 0 | 766 | | | | 0 | |
- 2010-07 | 0 | 1156 | | | | | |
- 2010-08 | 0 | 1648 | | | | | |
- 2010-09 | 0 | 832 | | | | 1 | |
- 2010-10 | 0 | 3184 | | | | 0 | |
- 2010-11 | 0 | 4662 | | | | 0 | |
- 2010-12 | 6 | 499 | | | | 0 | |
- 2011-01 | 0 | 3207 | | | | 0 | |
- 2011-02 | 0 | 878 | | | | | |
- 2011-03 | 0 | 1461 | | | 0 | 0 | |
- 2011-04 | 0 | 4065 | | | 0 | 0 | |
- 2011-05 | 0 | 2955 | | 0 | 0 | | |
- 2011-06 | 0 | 2118 | | | 0 | | 0 |
- 2011-07 | 0 | 3136 | | 0 | 0 | | |
- 2011-08 | 0 | 3706 | | 0 | 0 | 0 | |
- 2011-09 | 0 | 1379 | | | 0 | 0 | 0 |
- 2011-10 | 0 | 7994 | 0 | 0 | 0 | | |
- 2011-11 | 0 | 9894 | | 0 | 0 | | |
- 2011-12 | 0 | 10243 | | 0 | 0 | 0 | |
- 2012-01 | 0 | 4200 | | 0 | 0 | 0 | |
- 2012-02 | 0 | 1729 | | 0 | 0 | 0 | |
- 2012-03 | 0 | 1468 | | | 0 | 0 | |
- 2012-04 | 0 | 5069 | | | 0 | 0 | |
- 2012-05 | 0 | 23323 | | | 0 | 0 | |
- 2012-06 | 81 | 13646 | 0 | 0 | 0 | 0 | |
- 2012-07 | 0 | 14169 | 0 | | 0 | 0 | |
- 2012-08 | 0 | 7525 | 0 | 0 | 0 | 0 | |
- 2012-09 | 0 | 10526 | 0 | | 0 | 0 | |
- 2012-10 | 0 | 6220 | 0 | | 0 | 0 | |
- 2012-11 | 0 | 7927 | 0 | 0 | 0 | 0 | |
- 2012-12 | 0 | 1746 | 0 | | 0 | 0 | |
- 2013-01 | 1 | 10258 | | | 0 | 0 | |
- 2013-02 | 290 | 31066 | | 0 | 0 | 0 | |
- 2013-03 | 1108 | 2773 | | 0 | 0 | 0 | |
- 2013-04 | 10578 | 8620 | | 0 | 0 | 0 | |
- 2013-05 | 10049 | 7662 | 0 | 1 | 0 | 0 | |
- 2013-06 | 846 | 9464 | 0 | 0 | 0 | 0 | |
- 2013-07 | 253 | 2167 | 0 | 0 | 0 | 0 | |
- 2013-08 | 1036 | 4338 | 4 | | 0 | 0 | |
- 2013-09 | 633 | 8889 | 0 | | 0 | 0 | |
- 2013-10 | 287 | 2213 | 9259 | 0 | 0 | 0 | |
- 2013-11 | 28 | 11462 | 9928 | 0 | 0 | 0 | |
- 2013-12 | 37015 | 15857 | 8340 | 0 | 0 | 0 | |
- 2014-01 | 20705 | 12429 | 2233 | | 0 | 0 | |
- 2014-02 | 349 | 16894 | 4087 | | 0 | 2 | |
- 2014-03 | 28142 | 16356 | 2913 | | 0 | 0 | |
- 2014-04 | 19 | 11061 | 524 | | 0 | 0 | |
- 2014-05 | 59 | 16818 | 1864 | 0 | 0 | 0 | |
- 2014-06 | 751 | 27332 | 3965 | 0 | 0 | 0 | |
- 2014-07 | 6319 | 29123 | 2013 | | 0 | 0 | |
- 2014-08 | 2915 | 10017 | 2949 | | 0 | 0 | |
- 2014-09 | 1296 | 16826 | 1865 | | 0 | 3 | |
- 2014-10 | 417 | 6738 | 3519 | | 0 | 0 | |
- 2014-11 | 6076 | 14633 | 2717 | | 0 | 2 | |
- 2014-12 | 4720 | 7528 | 5125 | 0 | 0 | 7 | |
- 2015-01 | 45904 | 7241 | 7072 | 0 | 0 | 6 | |
- 2015-02 | 10082 | 9725 | 7846 | 0 | 0 | | |
- 2015-03 | 10602 | 13457 | 4613 | 0 | 0 | | |
- 2015-04 | 16950 | 16697 | 5623 | 0 | 0 | | |
- 2015-05 | 20867 | 22644 | 4897 | 0 | 0 | | |
- 2015-06 | 17121 | 36834 | 4191 | 0 | 0 | 0 | |
- 2015-07 | 87663 | 34376 | 15686 | | 0 | 0 | |
- 2015-08 | 35671 | 46395 | 8153 | 0 | | | |
- 2015-09 | 65210 | 145683 | 14935 | 0 | 0 | | |
- 2015-10 | 125654 | 204671 | 41456 | 11 | 0 | | |
- (95 ROWS)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
