Technical Tip: How to check FortiClient EMS 7.4 database size and specific table size

The command is used to check the FortiClient EMS Postgres database size in a Linux environment.

#df -h

#sudo -u postgres psql -Atc "SELECT datname, pg_size_pretty(pg_database_size(datname)) FROM pg_database ORDER BY pg_database_size(datname) DESC;"

The command below can be used to check the FortiClient EMS table size: 

#sudo -u postgres psql -Atc "SELECT schemaname AS schema_name, tablename AS table_name, pg_size_pretty(pg_total_relation_size(schemaname || '.' || tablename)) AS total_size, pg_relation_size(schemaname || '.' || tablename) AS table_size, pg_indexes_size(schemaname || '.' || tablename) AS indexes_size FROM pg_tables WHERE schemaname NOT IN ('pg_catalog', 'infomation_schema') ORDER BY pg_total_relation_size(schemaname || '.' || tablename) DESC limit 10;"