How do I get the current database size of the cloud environment?

1
Hi there, In our project we need to know the database size of the application for monitoring purposes. The application runs in the mx cloud environment. Next we want also to known the size of some specific tables. Is there a API available on the cloud environment, or do we have to do it in a java action? And if it has to be done in a java action, how should I do that? Kind regards, Wouter
asked
1 answers
1

Wouter,

In the cloud portal under the monitor tab and then trends you can review the database size. The size of specific tables can't be seen directly, for this you could create a backup and restore this locally. Then perform some queries on the database to get the size of the tables, have a look at :

http://www.quantprinciple.com/invest/index.php/docs/tipsandtricks/postgres_commands/tablesize/

and

https://wiki-bsse.ethz.ch/display/ITDOC/Check+size+of+tables+and+objects+in+PostgreSQL+database

answered