1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
select date_serv_jour,sum(nb_serv_app_jour),sum(val_obj_sauve_jour),
sum(val_vol_sauve_jour),sum(val_nb_sauve_jour),sum(val_err_sauve_jour)
sum(val_obj_rest_jour),sum(val_vol_rest_jour),sum(val_nb_rest_jour)
sum(val_err_rest_jour)
from (SELECT ssj.date as date_serv_jour,
saj.nb_serveurs as nb_serv_app_jour,
sum(ssj.obj_sauve) as val_obj_sauve_jour,
sum(ssj.vol_sauve) as val_vol_sauve_jour,
sum(ssj.nb_sauve) as val_nb_sauve_jour,
sum(ssj.err_sauve) as val_err_sauve_jour,
sum(ssj.obj_rest) as val_obj_rest_jour,
sum(ssj.vol_rest) as val_vol_rest_jour,
sum(ssj.nb_rest) as val_nb_rest_jour,
sum(ssj.err_rest) as val_err_rest_jour,
a.appli
FROM stat_serveur_jour ssj
LEFT OUTER JOIN serveurs s on ssj.id_serv=s.id_serv
LEFT OUTER JOIN applis a on s.id_app=a.id_app
LEFT OUTER JOIN groupe_app ga on a.id_app=ga.id_app
LEFT OUTER JOIN domaines d on ga.id_dom=d.id_dom
LEFT OUTER JOIN stat_app_jour saj on s.id_app=saj.id_app
WHERE ssj.date=saj.date
AND date_part('month',ssj.date)='02'
AND date_part('year',ssj.date)='2010'
AND d.domaine='Mon_domaine'
GROUP BY ssj.date,saj.nb_serveurs,appli
ORDER BY ssj.date,saj.nb_serveurs,appli
) as TB
group by date_serv_jour
order by date_serv_jour; |
Partager