search cancel

Postgres - Determine Clarity database size

book

Article ID: 242271

calendar_today

Updated On:

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.