Page History

...

SELECT to_char(sum(fields),'FM999,999,999,999,999')  as "Total fields", to_char(sum(requests), 'FM999,999,999,999,999') as "Total requests", to_char(sum(delivered/1024^4), 'FM999.999') as "Delivered volume (TB)"
FROM  datasets_stats_monthly
WHERE datasets_stats_monthly.dataset='tigge-global' and datasets_stats_monthly.month>=date'20060101';

Monthly sums

...

Data volume [TB]

• Delivered: data volume delivered to user after post-processing(e.g. interpolation) applied if asked for
• Retrieved: data volume retrieved from MARS before post-processing
  
  • retrieved data volume is normally equal or bigger then the delivered one with exception when user asked for higher then archived grid resolution resulting in artificially bigger interpolated files

select  to_char(month, 'MM/YYYY') as monthyear, CAST(delivered AS FLOAT)/1024^4 as "data volumeDelivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'20061001' order by month ;
select  to_char(month, 'MM/YYYY') as monthyear, CAST(retrieved AS FLOAT)/1024^4 as "Retrieved" from datasets_stats_monthly where dataset='tigge-global' and month>=date'20061001' order by month

...