How to check the original size of the confluence page and the size of the page after versioning

[Kiran Patil]

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 

[Nic Brough _Adaptavist_]

You'll need to start by defining what you think is the "size" of a confluence page, and how it matters?

[Abyakta Lenka]

@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 .

[Nic Brough _Adaptavist_]

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?