[Building Sakai] Used space of particular site in DB

[Yegeneswari Nagappan]

Hi All,

We have configured our Sakai instance ( 2.9) to save the resources in DB. Is there way to know the space occupied by a particular site in database ? I understand that the resources are saved in content_resource_body_binary table and I could get the size of all resources related to a particular site by querying this table.

What we are looking for is to get the space used by all tools/resources of one single site like Assignments, Tests&Quizzes, Lessons, Resources etc., One way we could think of getting this info is:

1) Archive the particular site
2) Get the sakai db size ( used space)
3) Import the archived file and create a new site
4) Check the sakai db size (used space) 
5) Difference between the values reported in step 4 and step 2.

Anyone have other suggestions/thoughts on this ? 

Thanks
Esh