Postgres Pro
Downloads
Home   >   mailing lists

Thread: vacuuming postgresql15 issues

vacuuming postgresql15 issues

From
Benjamin Acquaye
Date:
Hi all,
I am trying to clean our database tuples with a manual vacuum but it's not working any help

"n_dead_tup" 74 17 1 1 6 8 6 8 16 9

thanks
Ben

Re: vacuuming postgresql15 issues

From
Keith Fiske
Date:


On Wed, Nov 8, 2023 at 9:18 AM Benjamin Acquaye <benjaminacquaye2@gmail.com> wrote:
Hi all,
I am trying to clean our database tuples with a manual vacuum but it's not working any help

"n_dead_tup" 74 17 1 1 6 8 6 8 16 9

thanks
Ben

Check for long running transactions. Vacuum can only clean up dead rows if there are no transactions running that could possibly need to see those old rows. The following query will show all currently running transactions, in order of transaction age along with an additional column to show their runtime.

SELECT *, now() - xact_start AS xact_runtime FROM pg_stat_activity WHERE state <> 'idle' ORDER BY xact_start;


--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

Re: vacuuming postgresql15 issues

From
Laurenz Albe
Date:
On Wed, 2023-11-08 at 09:17 -0500, Benjamin Acquaye wrote:
> I am trying to clean our database tuples with a manual vacuum but it's not working any help

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

Yours,
Laurenz Albe