Query for listing largest Confluence spaces?

[Maria Ahvenlampi]

Hello,

We are currently facing problems editing and saving pages in Confluence (pages including macros, text, JIRA links etc.). 

Atlassian has noted the following:

''You may experience problems saving extremely large pages. Confluence can accept approximately 5mb of content (not including attached files) which is roughly equivalent to 800,000 words.  If you do experience errors that indicate the page is too large to save, you should break up the page into several smaller pages. ''

The pages where this problem pops up are def not the max size (5mb) Atlassian has mentioned in their site.

I have the largest pages listed already, still needing more information to resolve this problem.

Any helpful queries for listing the data size information are welcome! THANKS! :)

[Rilwan Ahmed · Accepted solution]

Hi @Maria Ahvenlampi ,

Refer below link to find the largest Confluence pages by storage size in the database.

https://confluence.atlassian.com/confkb/how-to-find-the-largest-confluence-pages-by-storage-size-in-the-database-800862464.html 

Also Pages with too many tables, columns, rows  add for page slowness. 

[Maria Ahvenlampi]

Thank you Rilwan for the quick answer! Cheers :)