Re: Disk is filling up with large files. How can I clean? - Mailing list pgsql-general

On 10/8/24 04:06, Mikael Petterson wrote:
> Hi,
> I find our disk is filling up.

Query the pg_stat_activity view:

https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ACTIVITY-VIEW

and look for rows that have with state showing 'idle in transaction'.

Report back what you find.

You should also check out this post:

https://www.cybertec-postgresql.com/en/reasons-why-vacuum-wont-remove-dead-rows/


> What can I do to clean up. We are using pgsql 12.
> Br,
> //Mikael
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com