Re: Calculation of Database Size in postgres

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Calculation of Database Size in postgres
Date: 2018-02-14 11:16:30
Message-ID: 1518606990.2402.2.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

pavan95 wrote:
> Do you know how does it calculate internally using what functions or what
> system catalogs or whatever?

The functions are in backend/utils/adt/dbsize.c, note in particular
db_dir_size which walks through a directory and adds up the sizes of
all files therein.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pavan95 2018-02-14 12:21:16 Re: Calculation of Database Size in postgres
Previous Message pavan95 2018-02-14 10:23:57 Re: Calculation of Database Size in postgres