How do we verify the size of a Confluence wiki space?

JohnK August 6, 2012

What can be the options to tell how big is a confluence wiki space, including all the attachments and pages? Thanks.

4 answers

2 votes
jose_castro January 13, 2016

@John Kung

I know this is an older post but I wrote a SQL query that will pull all your spaces and display the total attachment size for each space: 

 

https://confluence.atlassian.com/display/CONFKB/How+to+Find+the+Total+Amount+of+Space+Used+for+Multiple+Space%27s+Attachments

1 vote
assemhakmeh May 26, 2013

If you have access to the DB you could run the following query to get an estimate:

SELECT S.`SPACENAME`, C.SPACEID, CONCAT(ROUND((SUM(A.`FILESIZE`) / (1024 * 1024))), ' MB') AS 'SIZE'
FROM ATTACHMENTS A LEFT JOIN CONTENT C ON C.`CONTENTID` = A.`PAGEID` LEFT JOIN SPACES S ON C.SPACEID = S.SPACEID
GROUP BY C.`SPACEID`

Harry Chan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 26, 2013

For OnDemand customers, this won't be possible.

wdonovan December 8, 2021

There is no 'Attachments' table

1 vote
YvonneY August 22, 2012

The only way to see the size of a space at the moment is to make a full export of the space (ensure you ticked the box "Include hidden pages") and check the size of the export.

Bertrand Drouhard April 1, 2019

You're right Yvonne, if you don't have database access, then it's a acceptable way to get it.

0 votes
NikE
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 7, 2012

Currently, in OnDemand, you cannot access that information. It the future you will be able to access that yourself, but in the meantime, if you enter a support request, we can send the info to you.

alanger June 10, 2021

That was 9 years ago. We don't need emoji's we need stuff like this working. What is wrong with this company?

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events