{sql:dataSource=wiki|output=wiki}
select 218000000000/1024/1024 as total, trunc((218000000000 - sum(repo_size)*2)/1024/1024) as free, trunc((sum(repo_size)*2)/1024/1024) as used from owl_repository_data
{sql}
Chart
3D
truefalse
ylabel
Size in Megabytes
timePeriod
Day
categoryLabelPosition
down45
type
bar
dataOrientation
vertical
title
Top 5 Repository Sizes
colors
bluetimePeriod=Day
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select repo_group_code || '.' || repo_name as name, (repo_size/1024/1024) as size from owl_repository_data order by repo_size desc limit 5
{sql}
Chart
3D
truefalse
ylabel
Number of Revisions
timePeriod
Day
categoryLabelPosition
down45
type
line
dataOrientation
vertical
title
Top 5 Repository Revisions
colors
green
Wiki Markup
{sql:dataSource=wiki|output=wiki}
select repo_group_code || '.' || repo_name as name, max(repo_revision) as revision from owl_repository_data where repo_group_code <> 'it.svn' and repo_name <> 'subversion' group by name order by revision desc limit 5
{sql}