MIME-Version: 1.0
References: 
 <CAJk5Atb1v7=x-wsS-tL7Lxs7yXQy8Ng-GhXG+zzZ1gVAx=Xzjw@mail.gmail.com>
In-Reply-To: 
 <CAJk5Atb1v7=x-wsS-tL7Lxs7yXQy8Ng-GhXG+zzZ1gVAx=Xzjw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 13 Jun 2026 08:39:41 -0400
Message-ID: 
 <CANzqJaB7jSN7RQruqzBPnKKNkSMTKn7s5C5jGZDOk=M79hB9ug@mail.gmail.com>
Subject: Re: Size of /pgdata
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c3491d065421e349"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaB7jSN7RQruqzBPnKKNkSMTKn7s5C5jGZDOk%3DM79hB9ug%40mail.gmail.com>
Precedence: bulk

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

On Sat, Jun 13, 2026 at 2:48=E2=80=AFAM Raj <rajeshkumar.dba09@gmail.com> w=
rote:

> Hi all,
>
> I am using 17.9 version.
>
> I see suddenly du -sh /pgdata/17 shows  930GB. Total allocated is 1TB.
>

Don't stop with "-s".  Drill deeper:

du -hd2 /pgdata/17


>
> I checked the db size using \l+ and also pg_total_relation_size and size
> for particular db is 630GB. Ignoring postgres and template dbs as they ar=
e
> in KBs.
>

Use pg_database_size() instead, since pg_total_relation_size() might miss
something.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, Jun 13, 2026 at 2:48=E2=80=AFAM R=
aj &lt;<a href=3D"mailto:rajeshkumar.dba09@gmail.com">rajeshkumar.dba09@gma=
il.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi all=
,<div dir=3D"auto"><br></div><div dir=3D"auto">I am using 17.9 version.=C2=
=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">I see suddenly du -s=
h /pgdata/17 shows=C2=A0 930GB. Total allocated is 1TB.</div></div></blockq=
uote><div><br></div><div>Don&#39;t stop with &quot;-s&quot;.=C2=A0 Drill de=
eper:</div><div><br></div><div>du -hd2 /pgdata/17</div><div>=C2=A0</div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div dir=
=3D"auto"><br></div><div dir=3D"auto">I checked the db size using \l+ and a=
lso pg_total_relation_size and size for particular db is 630GB. Ignoring po=
stgres and template dbs as they are in KBs.</div></div></blockquote></div><=
div><br></div><div>Use pg_database_size() instead, since pg_total_relation_=
size() might miss something.</div><div><br></div><span class=3D"gmail_signa=
ture_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div =
dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil=
 me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div=
></div></div></div></div>

--000000000000c3491d065421e349--