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 2006-01-01

Archive size [PiB]


SQL
border0
noDataErrortrue
enableSortingfalse
columnStylesfont-size: 1.0em
rowOrientationhorizontal
expandArrayfalse
stylefumble:0
convertNullfalse
idmydata3
dataSourcemars_apistats_new
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
SELECT  to_char(Grand_total/1024^5, 'FM999,999,999,999.000') FROM mars_dataset_details
WHERE name = 'tigge' 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_new
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
SELECT  to_char(Number_of_fields, 'FM999,999,999,990') FROM mars_dataset_details
WHERE name = 'tigge' ORDER BY Date DESC LIMIT 1


last updated on

SQL
border1
noDataErrortrue
enableSortingfalse
columnStylesfont-size: 1.0em
rowOrientationhorizontal
expandArrayfalse
stylefumble:0
convertNullfalse
idmydata3
dataSourcemars_apistats_new
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
SELECT date FROM mars_dataset_details
WHERE name = 'tigge' ORDER BY Date DESC LIMIT 1




Column


Panel

Statistics for the period since 2014-01-01

Number of active users


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


Delivered data volume [TiB]


SQL
dataSourcemars_apistats_new
tablefalse
SELECT to_char(sum(delivered/1024^4), 'FM999,999,999,990.0')FROM datasets_stats_monthly WHERE datasets_stats_monthly.dataset='tigge-global' and datasets_stats_monthly.month>=date'2006-01-01';


Number of retrieved fields


SQL
border0
noDataErrortrue
enableSortingfalse
columnStylesfont-size: 1.0em
rowOrientationhorizontal
expandArrayfalse
stylefumble:0
convertNullfalse
idmydata3
dataSourcemars_apistats_new
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
SELECT to_char(sum(fields),'FM999,999,999,999,999')
FROM  datasets_stats_monthly
WHERE datasets_stats_monthly.dataset='tigge-global' and datasets_stats_monthly.month>=date'2006-01-01';


Number of requests


SQL
border0
noDataErrortrue
enableSortingfalse
columnStylesfont-size: 1.0em
rowOrientationhorizontal
expandArrayfalse
stylefumble:0
convertNullfalse
idmydata3
dataSourcemars_apistats_new
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
SELECT to_char(sum(requests), 'FM999,999,999,999,999')
FROM  datasets_stats_monthly
WHERE datasets_stats_monthly.dataset='tigge-global' and datasets_stats_monthly.month>=date'2006-01-01';


last updated

SQL
border0
noDataErrortrue
enableSortingfalse
columnStylesfont-size: 1.0em
rowOrientationhorizontal
expandArrayfalse
stylefumble:0
convertNullfalse
idmydata3
dataSourcemars_apistats_new
enableHighlightingfalse
tablefalse
retainRowStyleOrderfalse
SELECT to_char( datasets_stats_monthly.month, 'YYYY-MM') FROM  datasets_stats_monthly WHERE datasets_stats_monthly.dataset='tigge-global' order by datasets_stats_monthly.month desc LIMIT 1;




Monthly sums

(Monthly statistics are available only since  2015-01-01)

...