Page History

...

Section

border	true

Column

Panel

Statistics for the entire archiving period since 2006-01-01

Archive size [PiB]

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^5, 'FM999,999,999,999.000') FROM mars_dataset_details
WHERE name = 'tigge' 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 = 'tigge' ORDER BY Date DESC LIMIT 1

last updated:

SQL

border	1
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 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

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='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

dataSource	mars_apistats_new
table	false

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

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='tigge-global' and datasets_stats_monthly.month>=date'2006-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='tigge-global' and datasets_stats_monthly.month>=date'2006-01-01';

last updated:

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( datasets_stats_monthly.month, 'YYYY-MM-DD') FROM  datasets_stats_monthly WHERE datasets_stats_monthly.dataset='tigge-global' order by datasets_stats_monthly.month desc LIMIT 1;

Graphs

Expand

title	Monthly sums

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

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') as "delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01' order by month ;
select  to_char(month, 'MM/YYYY') as monthyear, to_char(retrieved/1024^4, 'FM999,999,999,990') as "retrieved" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01' order by month

Delivered data volume (zoom from the previous graph)

Chart

showShapes	false
timePeriod	Quarter
width	1200
categoryLabelPosition	up45
dataOrientation	vertical
type	bar
yLabel	TiB
colors	#008DA6, white
height	300

SQL

id	mydata
dataSource	mars_apistats_new

select  to_char(month, 'MM/YYYY') as monthyear, to_char(delivered/1024^4, 'FM999,999,999,990') as "delivered" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-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='tigge-global' and month>=date'2015-01-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='tigge-global' AND month>=date'2015-01-01' 
AND username IN (
      SELECT username                        
      FROM  users_stats_monthly
      WHERE dataset='tigge-global'
      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') as "delivered" from datasets_stats_monthly where dataset='tigge-global' 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') as "retrieved" from datasets_stats_monthly where dataset='tigge-global' and month>=date'2015-01-01' group by year order by year

Delivered data volume (zoom from the previous graph)

Chart

showShapes	false
timePeriod	Quarter
width	1200
categoryLabelPosition	up45
dataOrientation	vertical
type	bar
yLabel	TiB
colors	#008DA6, white
height	300

SQL

id	mydata
dataSource	mars_apistats_new

select  to_char(month, 'YYYY') as year, to_char(sum(delivered/1024^4), 'FM999,999,999,990') as "delivered" from datasets_stats_monthly where dataset='tigge-global' 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

;

Users per country

, 'YYYY') as year, sum(requests) as "user requests" from datasets_stats_monthly where dataset='tigge-global' 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='tigge-global' AND month>=date'2015-01-01' 
AND username IN (
      SELECT username                        
      FROM  users_stats_monthly
      WHERE dataset='tigge-global'
      GROUP BY username
      HAVING sum(requests) >= 1
      )
GROUP BY year
ORDER BY year;

Users per country

as per 2018-06-01
only countries with at least 5 active users are shown

...

Section

Column

At least one active user (as per 2018-06-01)

Column

At least one active user with colour density depending on the number of active users (from 1 to 742) (as per 2018-06-01)

Space shortcuts

Page tree

Versions Compared

Old Version 33

New Version Current

Key

Graphs

Users per country

Users per country