Is there any query or option from Database or user interface in confluence that how to check the original size of the confluence page and the size of the page after versioning
Hello, hope it's okay to post on this thread, it's more a continuation of the question!
I've read that any page over 2mb can cause slow rendering (https://confluence.atlassian.com/confkb/slow-page-rendering-of-large-pages-due-to-http-post-limitations-183137.html), but I'm not sure what a 2MB page looks like. I understand this will likely depend on how many macros / images etc. will be used, but is there a way I can check some pages in my existing Confluence to get an idea?
@Kiran Patil did you figure this out .
I want to know the size of the page in kb or mb utilized by a single page .
This helps in identifying how much space (size) a particular space is utilizing in the database apart from attachments .
I couldn't find a straight forward answer for this anywhere .
I can get the number pf pages using SQL but how to calculate the disk utilization of that pages in the database .
You will not find a "straight forward answer" until you can define what you mean by "size". A text file takes up a certain amount of disk space. The same content in a database as a simple blob field takes up a different amount. The same content in a Confluence system, and hence stored in a database takes up a different amount. Most databases will store differently, so both the database examples will vary by the type of database you are using. And most do some form of compression, so you'll need to take account of that too.
I do not think "how much disk space does a page take up" is a particularly useful question for most people.
It would be far better to look at why you are asking the question. Of what use is "page 14713451 consumes 76 bytes of physical disk space" to you? Why is that useful?