nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to calculate size of each space in confluence

Saketh Reddy

Accepted answers

Vladimir Yakimov _Botron_

Hello,

I believe you would find those two links quite helpful:

https://confluence.atlassian.com/confkb/how-to-find-the-total-amount-of-space-used-for-a-single-space-s-attachments-229839506.html

and

https://answers.atlassian.com/questions/75048

Regards,

Vladimir

All comments

Vladimir Yakimov _Botron_

Hello,

I believe you would find those two links quite helpful:

https://confluence.atlassian.com/confkb/how-to-find-the-total-amount-of-space-used-for-a-single-space-s-attachments-229839506.html

and

https://answers.atlassian.com/questions/75048

Regards,

Vladimir

Greg Della-Croce

I tried the code from the first link and (with some modification of tables name[see below]) it worked great. I now can get a list of space with attachments and get their sizes.

My question does go beyond the attachment sizes. What can we do to get the actual size of the space itself (with or without attachments)?

My modified code:

SELECT
    s.spacekey,
    s.SPACENAME,
    SUM(filesize)
FROM
    ATTACHMENTS_BACKUP a
JOIN CONTENT c
ON
    a.pageid = c.contentid
JOIN SPACES s
ON
    c.spaceid = s.spaceid
GROUP BY
    s.spacekey

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-administration