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
@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?
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events