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
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';
...
Chart
showShapes
false
timePeriod
Quarter
width
1200
categoryLabelPosition
up45
dataOrientation
vertical
type
bar
yLabel
GiB
height
400
SQL
id
mydata
dataSource
mars_apistats_new
select to_char(month, 'MM/YYYY') as monthyear, to_char(delivered/1024^3, 'FM999,999,999,990.999') as "delivered" from datasets_stats_monthly where dataset='yopp' and month>=date'2017-01-01' order by month ;
select to_char(month, 'MM/YYYY') as monthyear, to_char(retrieved/1024^3, 'FM999,999,999,990.999') as "retrieved" from datasets_stats_monthly where dataset='yopp' and month>=date'2017-01-01' order by month
...
Chart
showShapes
false
width
1200
categoryLabelPosition
up45
dataOrientation
vertical
type
bar
yLabel
Nr of requests
colors
#FFAB00
height
300
SQL
id
mydata
dataSource
mars_apistats_new
select to_char(month, 'MM/YYYY') as monthyear, requests as "user requests" from datasets_stats_monthly where dataset='yopp' and month>=date'2017-01-01' order by month;
...
Chart
showShapes
false
width
1200
categoryLabelPosition
up45
dataOrientation
vertical
type
bar
yLabel
Nr of users
colors
#36B37E
height
300
SQL
id
mydata
dataSource
mars_apistats_new
SELECT to_char(month, 'MM/YYYY') as monthyear, count(DISTINCT username) as "active users"
FROM users_stats_monthly
WHERE dataset='yopp' AND month>=date'2017-01-01'
AND username IN (
SELECT username
FROM users_stats_monthly
WHERE dataset='yopp'
GROUP BY username
HAVING sum(requests) >= 1
)
GROUP BY month
ORDER BY month;
...
Chart
stacked
true
width
900
dataOrientation
vertical
opacity
75
height
700
SQL
id
mydata
dataSource
mars_apistats_new
SELECT profile_country.name, count(DISTINCT auth_user.username) as total_users
FROM profile_country
RIGHT JOIN profile_profile ON profile_profile.country_id = profile_country.id
RIGHT JOIN auth_user ON auth_user.id = profile_profile.user_id
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'
GROUP BY profile_country.name
HAVING count(DISTINCT auth_user.username)>=1
ORDER BY total_users DESC