public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muhammad Imtiaz <[email protected]>
To: Shenavai, Manuel <[email protected]>
Cc: [email protected]
Subject: Re: Monitoring DB size
Date: Mon, 15 Jul 2024 20:26:07 +0500
Message-ID: <CANwR1ORGpwejXsyvf8W-1+UoMU3XsQbdvY+asuHYkJXbgV4THw@mail.gmail.com> (raw)
In-Reply-To: <AM9PR02MB741013EB8C5698CD8C44387CE8A12@AM9PR02MB7410.eurprd02.prod.outlook.com>
References: <AM9PR02MB741013EB8C5698CD8C44387CE8A12@AM9PR02MB7410.eurprd02.prod.outlook.com>

Hi,

You can choose from the following options. Hopefully, they will meet your
requirements

1) pg_stat_user_tables view
2) pgstattuple extension

Regards,

Muhammad imtiaz

On Mon, 15 Jul 2024, 19:42 Shenavai, Manuel, <[email protected]>
wrote:

> Hi everyone,
>
>
>
> we currently capture the db size (pg_database_size) which gives the “Disk
> space used by the database with the specified name”. Is it possible to
> further split this data how much space is occupied by live tuples, dead
> tuples and free space?
>
>
>
> We would like to have something like:
>
> DB Size: 200 MB, live tuple 100MB, Dead Tuple: 20 MB, free space 80MB
>
>
>
> Is this possible?
>
>
>
> Best regards,
>
> Manuel
>

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Monitoring DB size
  In-Reply-To: <CANwR1ORGpwejXsyvf8W-1+UoMU3XsQbdvY+asuHYkJXbgV4THw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox