Overview



Statistics for the entire archiving period since 2015-05-01

Archive size [TiB]


SELECT  to_char(Grand_total/1024^4, 'FM999,999,999,990.9') FROM mars_dataset_details
WHERE name = 's2s' ORDER BY Date DESC LIMIT 1


Number of  fields


SELECT  to_char(Number_of_fields, 'FM999,999,999,990.999') FROM mars_dataset_details
WHERE name = 's2s' ORDER BY Date DESC LIMIT 1


Last updated: 

SELECT date FROM mars_dataset_details
WHERE name = 's2s' ORDER BY Date DESC LIMIT 1




Statistics for the period since 2015-05-01


Number of active users


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


Delivered data volume [TiB]


SELECT to_char(sum(delivered/1024^4), 'FM999,999,999,990.9')FROM datasets_stats_monthly WHERE datasets_stats_monthly.dataset='s2s' and datasets_stats_monthly.month>=date'2015-01-01';


Number of retrieved fields


SELECT to_char(sum(fields),'FM999,999,999,999,999')
FROM  datasets_stats_monthly
WHERE datasets_stats_monthly.dataset='s2s' and datasets_stats_monthly.month>=date'2015-01-01';


Number of requests


SELECT to_char(sum(requests), 'FM999,999,999,999,999')
FROM  datasets_stats_monthly
WHERE datasets_stats_monthly.dataset='s2s' and datasets_stats_monthly.month>=date'2015-01-01';


Last updated: 

SELECT to_char( datasets_stats_monthly.month, 'YYYY-MM-dd') FROM  datasets_stats_monthly WHERE dataset='s2s' order by datasets_stats_monthly.month desc LIMIT 1;




Graphs


Data volumes

Volume of data retrieved from MARS before post-processing vs volume of data delivered to users after post-processing.


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


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


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;




Data volumes

Volume of data retrieved from MARS before post-processing vs volume of data delivered to users after post-processing.


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


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


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


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='s2s' and users_stats_monthly.month>=date'2015-05-01'
GROUP BY profile_country.name
HAVING count(DISTINCT auth_user.username)>=5
ORDER BY total_users DESC





At least one active user (as per June 2018)


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