...
Section |
---|
|
Statistics for the entire archiving period since 2017-05-01
Column |
---|
Panel |
---|
Archive size [TiB] |
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^4, 'FM999,999,999,990.0') FROM mars_dataset_details
WHERE name = 'yopp' 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 = 'yopp' 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 = 'yopp' ORDER BY Date DESC LIMIT 1 |
|
|
Column |
---|
Panel |
---|
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='yopp' and users_stats_monthly.month>=date'2017-01-01'
AND auth_user.username IN (
SELECT username
FROM users_stats_monthly
WHERE dataset='yopp'
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.999')FROM datasets_stats_monthly WHERE datasets_stats_monthly.dataset='yopp' and datasets_stats_monthly.month>=date'2017-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='yopp' and datasets_stats_monthly.month>=date'2017-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='yopp' and datasets_stats_monthly.month>=date'2017-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='yopp' order by datasets_stats_monthly.month desc LIMIT 1; |
|
|
|
Monthly sums
Data volumes
Volume of data retrieved from MARS before post-processing vs volume of data delivered to users after post-processing.
...