Page History

...

Expand

title	Monthly sums

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_new

select  to_char(month, 'MM/YYYY') as monthyear, to_char(delivered/1024^4, 'FM999,999,999,990.9999') as "delivered" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-05-01' order by month ;
select  to_char(month, 'MM/YYYY') as monthyear, to_char(retrieved/1024^4, 'FM999,999,999,990.9999') as "retrieved" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-05-01' order by month

Number of requests

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='s2s' and month>=date'2015-05-01' order by month;

Number of active users

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='s2s' AND month>=date'2015-05-01' 
AND username IN (
      SELECT username                        
      FROM  users_stats_monthly
      WHERE dataset='s2s'
      GROUP BY username
      HAVING sum(requests) >= 1
      )
GROUP BY month
ORDER BY month;

Expand

title	Yearly sums

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_new

select  to_char(month, 'YYYY') as year, to_char(sum(delivered/1024^4), 'FM999,999,999,990.9999') as "delivered" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-01-01' group by year order by year ;
select  to_char(month, 'YYYY') as year, to_char(sum(retrieved/1024^4), 'FM999,999,999,990.9999') as "retrieved" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-01-01' group by year order by year

Number of requests

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, 'YYYY') as year, sum(requests) as "user requests" from datasets_stats_monthly where dataset='s2s' and month>=date'2015-01-01' group by year order by year;

Number of active users

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, 'YYYY') as year, count(DISTINCT username) as "active users"
FROM  users_stats_monthly 
WHERE dataset='s2s' AND month>=date'2015-01-01' 
AND username IN (
      SELECT username                        
      FROM  users_stats_monthly
      WHERE dataset='s2s'
      GROUP BY username
      HAVING sum(requests) >= 1
      )
GROUP BY year
ORDER BY year;

Users per country

only countries with at least 5 active users are shown

...

Section

Column

At least one active user (as per June 2018)

Column

At least one active user with colour density depending on the number of active users (from 1 to 125) (as per June 2018)

Space shortcuts

Page tree

Versions Compared

Old Version 4

New Version Current

Key

Users per country