...
SQL | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||
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
Chart | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||
|
...