Pgbackrest info output interpretation

From: KK CHN <kkchn(dot)in(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Pgbackrest info output interpretation
Date: 2025-11-14 08:32:38
Message-ID: CAKgGyB-4HmSMCg8L1_HCvK6jF=-bJtxn9v4oCH-jY0EdzKH-Lw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am having confusion trying to understand the database size, backupsize
and repo backup size..

In my DB server I have du output as follows.

/data/edb/as16
[root(at)db1 as16]# du -h -d 1
5.3G ./data
25G ./tablespace
30G .
[root(at)db1 as16]#

On my Repo Server pgbackest info says ....

full backup: 20251114-121504F
timestamp start/stop: 2025-11-14 12:15:04+05:30 / 2025-11-14
12:20:58+05:30
wal start/stop: 000000010000000500000024 /
000000010000000500000024
database size: 3GB, database backup size: 3GB
repo1: backup size: 431.0MB

Could someone shed some light on 431 MB and database size:3GB, database
backup size : 3GB compared to the DB cluster on disk usage output ?

How to correlate the pgbackrest ( info) database size, database backup size
and repo1 backup size and actual du output on DB cluster.

Note: I am using zst compression on pgbackrest

Regards,
Krishane

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2025-11-14 13:42:46 Re: Pgbackrest info output interpretation
Previous Message Laurenz Albe 2025-11-13 22:10:18 Re: Question about MVCC caveats