sql query to find attachment size after migrate to file system?

Question

Hello,

I have migrated attachment from database to file system on Confluence 5.8.x.

Now I need a query to sum the size (Gb) of all attachment from current version ?

Can I query this now they are on file system ?

Thanks for any help.

Michael

Guilherme V. · Answer

I tried this query:

select sum(filesize) from attachments

But it will take everything from the attachments table such as the other attachments versions. I'm also not sure how you could convert it to GB 
.

Also: In Confluence 5.8 the attachments are stored in the content table, if I'm not wrong...

Mirek · Answer

By default, Confluence stores attachments in the attachments directory within the configured Confluence home folder. You can log in to a server and check the size of this directory.

-Mirek