I have a single primary database on my server of which when I take a pg_dump is only around 5 gb. But surprisingly, the base directory inside data directory of postgres is taking up a lot of space. Also I’m having trouble managing the pg_wal, it grows at an abnormal rate and fills up disk space.

du -sh /* | sort -rh

SELECT version(); -> PostgreSQL 14.13 (Ubuntu 14.13-0ubuntu0.22.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit

I am ready to provide any more information.

I haven’t tried anything yet.

EDIT:

select * from pg_stat_activity;

EDIT:

ps ax | grep postgres