Postgres - Determine Clarity database size

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

How to determine the size of PostgreSQL databases?

Environment

Release : 16.0.2

Resolution

To determine the size of a database:

Type the following command. Replace dbname with the name of the database that you want to check:

SELECT pg_size_pretty( pg_database_size('dbname') ); 

Psql displays the size of the database.