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.kla...@aklaver.com
