Obtaining Confluence Instance Metrics

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 usage

ユーザー

What is the typical number of concurrent active users i.e. number of concurrent requests being processed?

• users with currently active requests
• users currently using Confluence: eg including reading a page, editing a page, viewing search results.
• users with sessions held in application server memory.
• users logged in active users (Note that Confluence uses "Remember Me" Session cookies and in my experience of Confluence, users never explicitly log out).
• define user types (viewer, editor, etc)

– light viewer
– rss reader
– searcher
– infrequent editor
– frequent editor
– administrator
– commenter

用途

What 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)
To help interpret the raw access data, consider these important URL patterns:

Usage statistics gather from database

Note: specify the date range

1 日あたりの作成されたコンテンツ

select 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

• 結果の例:

1 日あたりの編集コンテンツ数

select 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

• 結果の例:

  CONTENTTYPE	min	max	avg
  BLOGPOST	1	718	14.4705882352941176
  COMMENT	1	73	23.5120000000000000
  下書き	4	6	5.0000000000000000
  メール	1	1	1.00000000000000000000
  ページ	1	4658	130.2650602409638554
  SPACEDESCRIPTION	1	4	1.2033898305084746
  USERINFO	1	48	16.7991967871485944

Number of existing pages

select contenttype, count(*) from content group by content.contenttype

• 結果の例:

  CONTENTTYPE	count
  メール	7914
  COMMENT	12983
  SPACEDESCRIPTION	232
  下書き	10
  ページ	81465
  USERINFO	13782
  BLOGPOST	3308

Number of links per page

select 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

• 結果の例:

  http	max	min	avg	stddev_pop	stddev_samp	var_pop	var_samp
  false	1994	1	5.8366957470010905	32.7082672608353032	32.7104967872521825	1069.8307472062305489	1069.9766000688353519
  true	189	1	2.9633190883190883	6.3609167066017375	6.3614831031752836	40.4612613483250948	40.4684672719846362

Number of characters per content body

select max(blength), min(blength), avg(blength), stddev(blength), variance(blength) 
from (select length(body) as blength from bodycontent) as bodylengths
where blength > 0

• 結果の例:

  max	min	avg	stddev	variance
  488707	1	2826.5649320388349515	8858.740996699238	78477292.046599816739

(Note this query takes a long time to execute.)

Number of characters per page body

select 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

• 結果の例:

  max	min	avg	stddev	variance
  488707	1	3333.0885906386048069	9884.337162920180	97700121.150284961908

添付ファイル

select count(*), max(filesize), min(filesize), avg(filesize), stddev(filesize), sum(filesize) from attachments;

• 結果の例:

  count	max	min	avg	stddev	sum
  16082	107431588	0	207641.309725158562	2447904.9322	3339287543

Attachments per page

List 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

• 結果の例:

  pages_with_attachments	avg	max	min	stddev
  4197	3.8317846080533715	231	1	10.7013051235493489

Configuration / plugin data stored in Bandana

• Just the global context

  select count(*), sum(length(bandanavalue)) from bandana where bandanacontext = '_GLOBAL' 

• 結果の例:

  count	sum
  84	47729

• All of the information

  select count(*), sum(length(bandanavalue)) from bandana 

• 結果の例:

  count	sum
  665	153094

コンテンツ

It is essential to obtain the typical configuration of database (#pages, #spaces, #registered users, etc), based on Global Stats Plugin