...
Section |
---|
|
Column |
---|
Panel |
---|
Statistics for entire archiving period ( 2006-01-01 - present) Archive size [PiB] |
SQL |
---|
border | 0 |
---|
noDataError | true |
---|
enableSorting | false |
---|
columnStyles | font-size: 1.0em |
---|
rowOrientation | horizontal |
---|
expandArray | false |
---|
style | fumble:0 |
---|
convertNull | false |
---|
id | mydata3 |
---|
dataSource | mars_apistats |
---|
enableHighlighting | false |
---|
table | false |
---|
retainRowStyleOrder | false |
---|
| SELECT to_char(Grand_total/1024^5, 'FM999,999,999,990.999') FROM mars_dataset_details
WHERE name = 'tigge' ORDER BY Date DESC LIMIT 1 |
|
---|
Number of fields |
SQL |
---|
border | 0 |
---|
noDataError | true |
---|
enableSorting | false |
---|
columnStyles | font-size: 1.0em |
---|
rowOrientation | horizontal |
---|
expandArray | false |
---|
style | fumble:0 |
---|
convertNull | false |
---|
id | mydata3 |
---|
dataSource | mars_apistats |
---|
enableHighlighting | false |
---|
table | false |
---|
retainRowStyleOrder | false |
---|
| SELECT to_char(Number_of_fields, 'FM999,999,999,990.999') FROM mars_dataset_details
WHERE name = 'tigge' ORDER BY Date DESC LIMIT 1 |
|
---|
|
|
Column |
---|
Panel |
---|
Statistics Available statistics for the period 2014-01-01 - present (earlier statistics not available)present Number of active users |
SQL |
---|
dataSource | mars_apistats |
---|
table | false |
---|
| SELECT count(DISTINCT auth_user.username) as "Total number of users" FROM auth_user
RIGHT JOIN users_stats_monthly ON users_stats_monthly.username = auth_user.username
WHERE users_stats_monthly.dataset='tigge-global' and users_stats_monthly.month>=date'2006-01-01'
AND auth_user.username IN (
SELECT username
FROM users_stats_monthly
WHERE dataset='tigge-global'
GROUP BY username
HAVING sum(requests) >= 1) |
|
---|
Delivered data volume [TiB] |
SQL |
---|
dataSource | mars_apistats |
---|
table | false |
---|
| SELECT to_char(sum(delivered/1024^4), 'FM999,999,999,990')FROM datasets_stats_monthly WHERE datasets_stats_monthly.dataset='tigge-global' and datasets_stats_monthly.month>=date'2006-01-01'; |
|
---|
Number of retrieved fields |
SQL |
---|
border | 0 |
---|
noDataError | true |
---|
enableSorting | false |
---|
columnStyles | font-size: 1.0em |
---|
rowOrientation | horizontal |
---|
expandArray | false |
---|
style | fumble:0 |
---|
convertNull | false |
---|
id | mydata3 |
---|
dataSource | mars_apistats |
---|
enableHighlighting | false |
---|
table | false |
---|
retainRowStyleOrder | false |
---|
| SELECT to_char(sum(fields),'FM999,999,999,999,999')
FROM datasets_stats_monthly
WHERE datasets_stats_monthly.dataset='tigge-global' and datasets_stats_monthly.month>=date'2006-01-01'; |
|
---|
Number of requests |
SQL |
---|
border | 0 |
---|
noDataError | true |
---|
enableSorting | false |
---|
columnStyles | font-size: 1.0em |
---|
rowOrientation | horizontal |
---|
expandArray | false |
---|
style | fumble:0 |
---|
convertNull | false |
---|
id | mydata3 |
---|
dataSource | mars_apistats |
---|
enableHighlighting | false |
---|
table | false |
---|
retainRowStyleOrder | false |
---|
| SELECT to_char(sum(requests), 'FM999,999,999,999,999')
FROM datasets_stats_monthly
WHERE datasets_stats_monthly.dataset='tigge-global' and datasets_stats_monthly.month>=date'2006-01-01'; |
|
---|
|
|
|
Monthly sums
(Monthly statistics are available only since 2015-01-01)
Data volumes
Volume of data retrieved from MARS before post-processing vs volume of data delivered to users after post-processing.
Chart |
---|
showShapes | false |
---|
timePeriod | Quarter |
---|
width | 1200 |
---|
categoryLabelPosition | up45 |
---|
dataOrientation | vertical |
---|
type | bar |
---|
yLabel | TiB |
---|
height | 400 |
---|
|
SQL |
---|
id | mydata |
---|
dataSource | mars_apistats |
---|
| select to_char(month, 'MM/YYYY') as monthyear, CASTto_char(delivered AS FLOAT)/1024^4/1024^4, 'FM999,999,999,990.999') as "delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01' order by month ;
select to_char(month, 'MM/YYYY') as monthyear, CASTto_char(retrieved AS FLOAT)/1024^4/1024^4, 'FM999,999,999,990.999') as "retrieved" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01' order by month |
|
...