Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section
bordertrue


Column


Panel

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

Archive size [TiB]


SQL
border0
noDataErrortrue
enableSortingfalse
columnStylesfont-size: 1.0em
rowOrientationhorizontal
expandArrayfalse
stylefumble:0
convertNullfalse
idmydata3
dataSourcemars_apistats
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
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


SQL
border0
noDataErrortrue
enableSortingfalse
columnStylesfont-size: 1.0em
rowOrientationhorizontal
expandArrayfalse
stylefumble:0
convertNullfalse
idmydata3
dataSourcemars_apistats
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
SELECT  to_char(Number_of_fields, 'FM999,999,999,990.999') FROM mars_dataset_details
WHERE name = 's2s' ORDER BY Date DESC LIMIT 1





Column

Available statistics Statistics for the period since 2015-05-01 - present

Panel


Number of active users


SQL
dataSourcemars_apistats
tablefalse
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'20150501'
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]


SQL
dataSourcemars_apistats
tablefalse
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'20150501';


Number of retrieved fields


SQL
border0
noDataErrortrue
enableSortingfalse
columnStylesfont-size: 1.0em
rowOrientationhorizontal
expandArrayfalse
stylefumble:0
convertNullfalse
idmydata3
dataSourcemars_apistats
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
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'20150501';


Number of requests


SQL
border0
noDataErrortrue
enableSortingfalse
columnStylesfont-size: 1.0em
rowOrientationhorizontal
expandArrayfalse
stylefumble:0
convertNullfalse
idmydata3
dataSourcemars_apistats
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
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'20150501';





...