vacuum cleans up dead rows. but only the ones no transaction could still see. one session left idle in transaction since lunch, and vacuum skips everything newer than it. autovacuum looks busy, the table keeps growing. check pg_stat_activity for old backend_xmin.
#PostgreSQL #PostgresVacuum #PG