Clarity Database Size

book

Article ID: 242271

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

How to determine the size of PostgreSQL databases

Environment

Release : 16.0.2

Component : Clarity SaaS Operations

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:

Copy SELECT pg_size_pretty( pg_database_size('dbname') ); Psql displays the size of the database.