Page History

...

Section

border	true

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

Column

Panel

Archive size [TiB]

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
enableHighlighting	false
table	false
retainRowStyleOrder	false

SELECT  to_char(Grand_total/1024^4, 'FM999,999,999,990.90') FROM mars_dataset_details
WHERE name = 'yopp' 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
enableHighlighting	false
table	false
retainRowStyleOrder	false

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

Column

Panel

Number of active users

SQL

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

Delivered data volume [TiB]

SQL

dataSource	mars_apistats
table	false

SELECT to_char(sum(delivered/1024^4), 'FM999,999,999,990.999')FROM datasets_stats_monthly WHERE datasets_stats_monthly.dataset='yopp' and datasets_stats_monthly.month>=date'2017-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
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='yopp' and datasets_stats_monthly.month>=date'2017-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
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='yopp' and datasets_stats_monthly.month>=date'2017-01-01';

...

Space shortcuts

Page tree

Versions Compared

Old Version 23

New Version 24

Key