AnsweredAssumed Answered

how can I query the SIZE ( Mb? Gb? Tb? ) of our Bb SaaS database? We have DDA access but sql like this{ SELECT pg_size_pretty( pg_database_size('BB5a333e152bba2') ); } does not agree with a monthly report that Bb provides to us in PDF format.

Question asked by dl0055113 on Jul 26, 2018
Latest reply on Aug 1, 2018 by dl0055113

how can I query the SIZE ( Mb? Gb? Tb? ) of our Bb SaaS database? We have DDA access but sql like this{ SELECT pg_size_pretty( pg_database_size('BB5a333e152bba2') ); } does not agree with a monthly report that Bb provides to us in PDF format.

 

our monthly report shows this as our total Bb SaaS database size is just over 5 Tb :

Disk Usage Statistics Production Size:

Content 4744 GB

Database 441 GB

Total 5185 GB  

 

But using SQL queries against our DDA (read-only copy of our) database show very different ( smaller ) numbers:

1) SELECT pg_size_pretty( pg_database_size('BB5b333e152bba2') );

218Gb

 

Likewise CMS (CONTENT management system database) reports as 1223 Mb (not Gb! , not Tb! ???)

2) SELECT pg_size_pretty( pg_database_size('BB5b333e152bba2_cms') );

1223 Mb

 

Is there a REST API call or other programming means of determining how large our database and course content are:

I plan to delete 1000's of old/defunct courses soon, and I 'd like to know (right away) how much disk space was saved as I delete each course, and not have to wait for a monthy Bb report ( which I do not trust, at this point )

Outcomes