...
Section |
---|
|
Column |
---|
Panel |
---|
Statistics for the entire archiving period since 2006-01-01 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_new |
---|
enableHighlighting | false |
---|
table | false |
---|
retainRowStyleOrder | false |
---|
| SELECT to_char(Grand_total/1024^5, 'FM999,999,999,999.000') 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_new |
---|
enableHighlighting | false |
---|
table | false |
---|
retainRowStyleOrder | false |
---|
| SELECT to_char(Number_of_fields, 'FM999,999,999,990') FROM mars_dataset_details
WHERE name = 'tigge' ORDER BY Date DESC LIMIT 1 |
|
---|
last updated on: SQL |
---|
border | 1 |
---|
noDataError | true |
---|
enableSorting | false |
---|
columnStyles | font-size: 1.0em |
---|
rowOrientation | horizontal |
---|
expandArray | false |
---|
style | fumble:0 |
---|
convertNull | false |
---|
id | mydata3 |
---|
dataSource | mars_apistats_new |
---|
enableHighlighting | false |
---|
table | false |
---|
retainRowStyleOrder | false |
---|
| SELECT date FROM mars_dataset_details
WHERE name = 'tigge' ORDER BY Date DESC LIMIT 1 |
|
|
Column |
---|
Panel |
---|
Statistics for the period since 2014-01-01 Number of active users |
SQL |
---|
dataSource | mars_apistats_new |
---|
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_new |
---|
table | false |
---|
| SELECT to_char(sum(delivered/1024^4), 'FM999,999,999,990.0')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_new |
---|
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_new |
---|
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'; |
|
---|
last updated: 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_new |
---|
enableHighlighting | false |
---|
table | false |
---|
retainRowStyleOrder | false |
---|
| SELECT to_char( datasets_stats_monthly.month, 'YYYY-MM') FROM datasets_stats_monthly WHERE datasets_stats_monthly.dataset='tigge-global' order by datasets_stats_monthly.month desc LIMIT 1; |
|
|
|
Monthly sums
(Monthly statistics are available only since 2015-01-01)
...