MIME-Version: 1.0
References: <AM9PR02MB741013EB8C5698CD8C44387CE8A12@AM9PR02MB7410.eurprd02.prod.outlook.com>
In-Reply-To: <AM9PR02MB741013EB8C5698CD8C44387CE8A12@AM9PR02MB7410.eurprd02.prod.outlook.com>
From: Muhammad Imtiaz <imtiaz.m@bitnine.net>
Date: Mon, 15 Jul 2024 20:26:07 +0500
Message-ID: <CANwR1ORGpwejXsyvf8W-1+UoMU3XsQbdvY+asuHYkJXbgV4THw@mail.gmail.com>
Subject: Re: Monitoring DB size
To: "Shenavai, Manuel" <manuel.shenavai@sap.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d8f25d061d4ad961"
Archived-At: <https://www.postgresql.org/message-id/CANwR1ORGpwejXsyvf8W-1%2BUoMU3XsQbdvY%2BasuHYkJXbgV4THw%40mail.gmail.com>
Precedence: bulk

--000000000000d8f25d061d4ad961
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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, <manuel.shenavai@sap.com>
wrote:

> Hi everyone,
>
>
>
> we currently capture the db size (pg_database_size) which gives the =E2=
=80=9CDisk
> space used by the database with the specified name=E2=80=9D. Is it possib=
le 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
>

--000000000000d8f25d061d4ad961
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi,<div dir=3D"auto"><br></div><div dir=3D"auto">You can =
choose from the following options. Hopefully, they will meet your requireme=
nts</div><div dir=3D"auto"><br></div><div dir=3D"auto">1) pg_stat_user_tabl=
es view<br></div><div dir=3D"auto">2) pgstattuple extension<br></div><div d=
ir=3D"auto"><br></div><div dir=3D"auto">Regards,</div><div dir=3D"auto"><br=
></div><div dir=3D"auto">Muhammad imtiaz</div></div><br><div class=3D"gmail=
_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, 15 Jul 2024, 19:42 Sh=
enavai, Manuel, &lt;<a href=3D"mailto:manuel.shenavai@sap.com">manuel.shena=
vai@sap.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">


<div lang=3D"en-DE" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:b=
reak-word">
<div class=3D"m_-4810205695106735401WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-US">Hi everyone,<u></u><u></u></spa=
n></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">we currently capture the db siz=
e (pg_database_size) which gives the =E2=80=9CDisk space used by the databa=
se with the specified name=E2=80=9D. Is it possible to further split this d=
ata how much space is occupied by live tuples, dead
 tuples and free space?<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">We would like to have something=
 like:<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">DB Size: 200 MB, live tuple 100=
MB, Dead Tuple: 20 MB, free space 80MB<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Is this possible?<u></u><u></u>=
</span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Best regards,<u></u><u></u></sp=
an></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Manuel<u></u><u></u></span></p>
</div>
</div>

</blockquote></div>

--000000000000d8f25d061d4ad961--