Confluence Docs 2.10 : Obtaining Confluence Instance Metrics
This page last changed on Feb 19, 2008 by pfragemann.
This page can be used as a guide to obtain detailed performance information of your instance. It is important to know the following : Users and usageUsersWhat is the typical number of concurrent active users i.e. number of concurrent requests being processed?
– light viewer UsageWhat is the average number of pages created per day, and similar usage stats (AWStat reports are a good starting place when User Access Logging is enabled) Searches: http://<host>/dosearchsite.action Usage statistics gather from database
Note: specify the date range Content created per dayselect contenttype, min(number_of_changes), max(number_of_changes), avg(number_of_changes) from ( select contenttype, date_trunc('day', creationdate) , count(*) as number_of_changes from content where content.creationdate > date '2007-01-01' and version = 1 group by contenttype, date_trunc('day', creationdate) ) as dates group by contenttype
Content edited per dayselect contenttype, min(number_of_changes), max(number_of_changes), avg(number_of_changes) from ( select contenttype, date_trunc('day', lastmoddate) as changedate, count(*) as number_of_changes from content where content.creationdate > date '2007-01-01' group by contenttype, date_trunc('day', lastmoddate) ) as dates group by contenttype
Number of existing pagesselect contenttype, count(*) from content group by content.contenttype
Number of links per pageselect http, max(linkcount), min(linkcount), avg(linkcount), stddev_pop(linkcount), stddev_samp(linkcount), var_pop(linkcount), var_samp(linkcount) from ( select contentid, (links.destspacekey = 'http') as http, count(*) as linkcount from links group by contentid, (links.destspacekey = 'http') ) as links_per_page group by http
Number of characters per content bodyselect max(blength), min(blength), avg(blength), stddev(blength), variance(blength) from (select length(body) as blength from bodycontent) as bodylengths where blength > 0
(Note this query takes a long time to execute.) Number of characters per page bodyselect max(blength), min(blength), avg(blength), stddev(blength), variance(blength) from (select length(bodycontent.body) as blength from bodycontent, content where bodycontent.contentid = content.contentid and contenttype='PAGE' ) as bodylengths where blength > 0
Attachmentsselect count(*), max(filesize), min(filesize), avg(filesize), stddev(filesize), sum(filesize) from attachments;
Attachments per pageList the stats for attachments per page, only for those pages that actually have attachments. select count(*) as pages_with_attachments, avg(attachments_per_page), max(attachments_per_page), min(attachments_per_page), stddev(attachments_per_page) from ( select count(*) as attachments_per_page from attachments group by attachments.pageid ) as app
Configuration / plugin data stored in Bandana
ContentIt is essential to obtain the typical configuration of database (#pages, #spaces, #registered users, etc), based on Global Stats Plugin |
![]() |
Document generated by Confluence on Dec 03, 2008 15:04 |