Postgres storage 16.5TB with DB size under 1TB

[Miroslav Kosteckij]

Hi,

Got a disk usage on Postgres indicating we are utilising 16.5 TB of data, however running various table size queries (https://wiki.postgresql.org/wiki/Disk_Usage) does not show any significant disk usage amounting to that amount? 

[Peter Kok]

Do you have point in time recovery on? That will do it...

Peter 

On Mon, May 30, 2022, 10:39 AM Miroslav Kosteckij <miro...@carted.com> wrote:

Hi,

Got a disk usage on Postgres indicating we are utilising 16.5 TB of data, however running various table size queries (https://wiki.postgresql.org/wiki/Disk_Usage) does not show any significant disk usage amounting to that amount? 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3a241566-002d-4352-9ff7-84e0cd73e28cn%40googlegroups.com.

[Andres Marquez Rodriguez]

Hi, Miroslav, 

Can you please share  the output of the queries below?

1) select pg_size_pretty(sum(size)) as "Total WAL disk usage" from pg_ls_waldir();

2) select pg_size_pretty(sum(size)) as "Total WAL disk usage" from pg_ls_waldir() where name not like '%.backup';

3) select * from pg_ls_waldir() order by modification Asc;